You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
172 lines
7.3 KiB
172 lines
7.3 KiB
using System;
|
|
using System.Data;
|
|
using Swift.DAL.SwiftDAL;
|
|
|
|
namespace Swift.DAL.MobileDao
|
|
{
|
|
public class MobileConfigDao : RemittanceDao
|
|
{
|
|
public DbResult DeleteBroadCast(string user, string rowId)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = 'DELETE'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(rowId);
|
|
return ParseDbResult(sql);
|
|
}
|
|
|
|
public DbResult DeleteGroup(string user, string rowId)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = 'DELETE-GROUP'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(rowId);
|
|
return ParseDbResult(sql);
|
|
}
|
|
|
|
public DbResult SaveBroadCast(string user, string rowId, string broadCastType, string bustomerGroup, string title, string body
|
|
, string imageURL, string scheduleDate, string customerId, string notificationType, string msgType)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = '" + (string.IsNullOrEmpty(rowId) ? "I-BROADCAST" : "U-BROADCAST") + "'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(rowId);
|
|
sql += ", @BroadcastTypeId = " + FilterString(broadCastType);
|
|
sql += ", @CustomerGroupIds = " + FilterString(bustomerGroup);
|
|
sql += ", @Title = N'" + title.Replace("'", "") + "'";
|
|
sql += ", @Body = N'" + body.Replace("'", "") + "'";
|
|
sql += ", @ImageURL = " + FilterString(imageURL);
|
|
sql += ", @ScheduleDate = " + FilterString(scheduleDate);
|
|
sql += ", @CustomerId = " + FilterString(customerId);
|
|
sql += ", @notificationType = " + FilterString(notificationType);
|
|
sql += ", @msgType = " + FilterString(msgType);
|
|
|
|
return ParseDbResult(sql);
|
|
}
|
|
|
|
public DataTable GetCustomerNoticeDetail(string user, string broadCastId)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = 'BROADCAST-DETAIL'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(broadCastId);
|
|
|
|
return ExecuteDataTable(sql);
|
|
}
|
|
|
|
public DataSet GetRepushData(string user, string broadCastId, string isRepush = null)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = 'RE-PUSH'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(broadCastId);
|
|
sql += ", @isRepush = " + FilterString(isRepush);
|
|
|
|
return ExecuteDataset(sql);
|
|
}
|
|
|
|
public DataTable GetCustomerList(string user, string customerGroupId)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = 'CUSTOMER-LIST'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(customerGroupId);
|
|
|
|
return ExecuteDataTable(sql);
|
|
}
|
|
|
|
public DbResult DeleteCustomerFromGroup(string user, string rowId)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = 'DELETE-CUSTOMER-FROM-GROUP'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(rowId);
|
|
|
|
return ParseDbResult(sql);
|
|
}
|
|
|
|
public DbResult SaveBroadCastCustomer(string user, string rowId, string customerId, string msgType, string body, string customerType , string nativeCountry, string postCode)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = '" + (string.IsNullOrEmpty(rowId) ? "IN-BROADCAST" : "UN-BROADCAST") + "'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(rowId);
|
|
sql += ", @Body = N'" + body.Replace("'", "") + "'";
|
|
sql += ", @CustomerId = " + FilterString(customerId);
|
|
sql += ", @msgType = " + FilterString(msgType);
|
|
sql += ", @customerType = " + FilterString(customerType);
|
|
sql += ", @nativeCountry = " + FilterString(nativeCountry);
|
|
sql += ", @postCode = " + FilterString(postCode);
|
|
|
|
return ParseDbResult(sql);
|
|
}
|
|
public DataTable GetCustomerGroup(string user, string broadCastId, string broadCastType)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = 'GROUP-LIST'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(broadCastId);
|
|
sql += ", @BroadcastTypeId = " + FilterString(broadCastType);
|
|
|
|
return ExecuteDataTable(sql);
|
|
}
|
|
|
|
public DbResult SaveCustomerGroup(string user, string broadCastId, string customerGroupIds)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = 'U-B-GROUP'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(broadCastId);
|
|
sql += ", @CustomerGroupIds = " + FilterString(customerGroupIds);
|
|
|
|
return ParseDbResult(sql);
|
|
}
|
|
|
|
public DbResult UploadCustomerData(string user, string customerGroup, string xml)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = 'UPLOAD-CUSTOMER'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(customerGroup);
|
|
sql += ", @xml = " + FilterStringForXml(xml);
|
|
|
|
return ParseDbResult(sql);
|
|
}
|
|
|
|
public DbResult UploadCustomerDataIndividual(string user, string customerGroup, string customerId)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = 'UPLOAD-CUSTOMER-SINGLE'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(customerGroup);
|
|
sql += ", @CustomerId = " + FilterString(customerId);
|
|
|
|
return ParseDbResult(sql);
|
|
}
|
|
|
|
public DataRow GetCustomerGroupData(string user, string rowId)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = 'S-GROUP-SINGLE'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(rowId);
|
|
|
|
return ExecuteDataRow(sql);
|
|
}
|
|
|
|
public DataRow GetBroadCastData(string user, string rowId)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = 'S-BROADCAST-SINGLE'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(rowId);
|
|
|
|
return ExecuteDataRow(sql);
|
|
}
|
|
public DataTable PopulateBroadCastData(string user, string rowId)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = 'S-BROADCAST-SINGLE'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(rowId);
|
|
|
|
return ExecuteDataTable(sql);
|
|
}
|
|
public DbResult SaveCustomerGroup(string user, string rowId, string broadCastType, string groupName, string groupDetail)
|
|
{
|
|
var sql = "EXEC ProcMobileConfig @flag = '" + (string.IsNullOrEmpty(rowId) ? "I-GROUP" : "U-GROUP") + "'";
|
|
sql += ", @User = " + FilterString(user);
|
|
sql += ", @RowId = " + FilterString(rowId);
|
|
sql += ", @BroadcastTypeId = " + FilterString(broadCastType);
|
|
sql += ", @GroupName = " + FilterString(groupName);
|
|
sql += ", @GroupDetail = " + FilterString(groupDetail);
|
|
|
|
return ParseDbResult(sql);
|
|
}
|
|
}
|
|
}
|