public MetaResponse UpdateCustomerMasterMaintenances(string ClientCertificateList)
{
DataTable dgvList = Utility.Utility_Component.JsonToDt(ClientCertificateList);
for (int i = 0; i < dgvList.Rows.Count; i++)
{
BOL_CUSTOMER_MASTER oCUSTOMER_MMASTER = new BOL_CUSTOMER_MASTER();
BOL_BANK_ACCOUNT_MASTER oBANK_ACCOUNT_MASTER = new BOL_BANK_ACCOUNT_MASTER();
oCUSTOMER_MMASTER = Cast_CUSTOMER_MASTER(dgvList.Rows[i]);
oBANK_ACCOUNT_MASTER = Cast_BANK_ACCOUNT_MASTER(dgvList.Rows[i]);
switch (dgvList.Rows[i]["MK"].ToString())
{
case "M":
HandleModify(oCUSTOMER_MMASTER, oBANK_ACCOUNT_MASTER, "M", dgvList.Rows[i]);
break;
default:
break;
}
}
response.Data = Utility.Utility_Component.DtToJSon(dgvList, "CustomerMaster Update");
timer.Stop();
response.Meta.Duration = timer.Elapsed.TotalMilliseconds;
return(response);
}
public bool IsAlreadyUpdated(BOL_BANK_ACCOUNT_MASTER oBANK_ACCOUNT_MASTER, out string strMsg)
{
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strAlreadyUpdate);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", oBANK_ACCOUNT_MASTER.COMPANY_NO_BOX));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@REQ_SEQ", oBANK_ACCOUNT_MASTER.REQ_SEQ));
oMaster.ExcuteQuery(4, out strMsg);
int count;
try
{
count = int.Parse(oMaster.dtExcuted.Rows[0][0].ToString());
}
catch (Exception)
{
count = 0;
}
if (count <= 0)
{
return(true);
}
else
{
return(false);
}
}
private void HandleModify(BOL_CUSTOMER_MASTER oCUSTOMER_MASTER, BOL_BANK_ACCOUNT_MASTER oBANK_ACCOUNT_MASTER, string OPERATION, DataRow row)
{
string strMsg = "";
CUSTOMER_MASTER DAL_CUSTOMER_MASTER = new CUSTOMER_MASTER(con);
using (TransactionScope dbTxn = new TransactionScope())
{
//check condition
if (!DAL_CUSTOMER_MASTER.IsAlreadyUpdate(oCUSTOMER_MASTER, out strMsg)) // IF updated_at is not already modified
{
DAL_CUSTOMER_MASTER.CustomerMasterUpdate(oCUSTOMER_MASTER, CURRENT_DATETIME, CURRENT_USER, out strMsg);
if (!string.IsNullOrEmpty(strMsg))
{
dbTxn.Dispose();
ResponseUtility.ReturnFailMessage(row);
return;
}
}
else
{
//already use in another process
dbTxn.Dispose();
ResponseUtility.ReturnFailMessage(row);
return;
}
#region UPDATE BANK_ACCOUNT_MASTER
BANK_ACCOUNT_MASTER DAL_BANK_ACCOUNT_MASTER = new BANK_ACCOUNT_MASTER(con);
if (!DAL_BANK_ACCOUNT_MASTER.IsAlreadyUpdated(oBANK_ACCOUNT_MASTER, out strMsg)) // If updated_at is not already modified
{
//insert the record
DAL_BANK_ACCOUNT_MASTER.BankAccountMasterUpdate(oBANK_ACCOUNT_MASTER, CURRENT_DATETIME, CURRENT_USER, out strMsg);
}
else
{
dbTxn.Dispose();
ResponseUtility.ReturnFailMessage(row);
return;
}
//return message and MK value
if (String.IsNullOrEmpty(strMsg)) //success
{
dbTxn.Complete();
string S = Convert.ToDateTime(oCUSTOMER_MASTER.ORG_EFFECTIVE_DATE).ToString("yyyy/MM/dd");
row["EFFECTIVE_DATE"] = Convert.ToDateTime(oCUSTOMER_MASTER.EFFECTIVE_DATE).ToString("yyyy/MM/dd");
row["ORG_EFFECTIVE_DATE"] = Convert.ToDateTime(oCUSTOMER_MASTER.EFFECTIVE_DATE).ToString("yyyy/MM/dd");
ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER);
}
else //failed
{
dbTxn.Dispose();
ResponseUtility.ReturnFailMessage(row);
}
#endregion
}
}
public void Update(BOL_BANK_ACCOUNT_MASTER BANK_ACCOUNT, out string strMsg)
{
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strUpdate);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", BANK_ACCOUNT.COMPANY_NO_BOX));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@REQ_SEQ", BANK_ACCOUNT.REQ_SEQ));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_1", BANK_ACCOUNT.BILL_BANK_ACCOUNT_NAME_1));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_2", BANK_ACCOUNT.BILL_BANK_ACCOUNT_NAME_2));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_3", BANK_ACCOUNT.BILL_BANK_ACCOUNT_NAME_3));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_4", BANK_ACCOUNT.BILL_BANK_ACCOUNT_NAME_4));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATED_AT", BANK_ACCOUNT.UPDATED_AT));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATED_BY", BANK_ACCOUNT.UPDATED_BY));
oMaster.ExcuteQuery(2, out strMsg);
}
public void BankAccountMasterUpdate(BOL_BANK_ACCOUNT_MASTER oCUSTOMER_MASTER, string CURRENT_DATETIME, string CURRENT_USER, out String strMsg)
{
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strBankAccountMasterUpdate);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", oCUSTOMER_MASTER.COMPANY_NO_BOX != null ? oCUSTOMER_MASTER.COMPANY_NO_BOX : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@REQ_SEQ", oCUSTOMER_MASTER.REQ_SEQ.ToString() != null ? oCUSTOMER_MASTER.REQ_SEQ : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_1", oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NAME_1 != null ? oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NAME_1 : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_2", oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NAME_2 != null ? oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NAME_2 : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_3", oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NAME_3 != null ? oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NAME_3 : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_4", oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NAME_4 != null ? oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NAME_4 : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NUMBER_1", oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NUMBER_1 != null ? oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NUMBER_1 : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NUMBER_2", oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NUMBER_2 != null ? oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NUMBER_2 : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NUMBER_3", oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NUMBER_3 != null ? oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NUMBER_3 : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NUMBER_4", oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NUMBER_4 != null ? oCUSTOMER_MASTER.BILL_BANK_ACCOUNT_NUMBER_4 : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_DATETIME", CURRENT_DATETIME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_USER", CURRENT_USER));
oMaster.ExcuteQuery(2, out strMsg);
}
private BOL_BANK_ACCOUNT_MASTER Cast_BANK_ACCOUNT_MASTER(DataRow row)
{
BOL_BANK_ACCOUNT_MASTER oBANK_ACCOUNT_MASTER = new BOL_BANK_ACCOUNT_MASTER();
oBANK_ACCOUNT_MASTER.COMPANY_NO_BOX = row["COMPANY_NO_BOX"].ToString().Trim();
oBANK_ACCOUNT_MASTER.REQ_SEQ = Utility_Component.dtColumnToInt(row["REQ_SEQ"].ToString().Trim());
oBANK_ACCOUNT_MASTER.BILL_BANK_ACCOUNT_NAME_1 = row["BILL_BANK_ACCOUNT_NAME-1"].ToString().Trim();
oBANK_ACCOUNT_MASTER.BILL_BANK_ACCOUNT_NAME_2 = row["BILL_BANK_ACCOUNT_NAME-2"].ToString().Trim();
oBANK_ACCOUNT_MASTER.BILL_BANK_ACCOUNT_NAME_3 = row["BILL_BANK_ACCOUNT_NAME-3"].ToString().Trim();
oBANK_ACCOUNT_MASTER.BILL_BANK_ACCOUNT_NAME_4 = row["BILL_BANK_ACCOUNT_NAME-4"].ToString().Trim();
oBANK_ACCOUNT_MASTER.BILL_BANK_ACCOUNT_NUMBER_1 = row["BILL_BANK_ACCOUNT_NUMBER-1"].ToString().Trim();
oBANK_ACCOUNT_MASTER.BILL_BANK_ACCOUNT_NUMBER_2 = row["BILL_BANK_ACCOUNT_NUMBER-2"].ToString().Trim();
oBANK_ACCOUNT_MASTER.BILL_BANK_ACCOUNT_NUMBER_3 = row["BILL_BANK_ACCOUNT_NUMBER-3"].ToString().Trim();
oBANK_ACCOUNT_MASTER.BILL_BANK_ACCOUNT_NUMBER_4 = row["BILL_BANK_ACCOUNT_NUMBER-4"].ToString();
oBANK_ACCOUNT_MASTER.UPDATED_AT = row["UPDATED_AT"].ToString().Length >= 1 ? row["UPDATED_AT"].ToString() : null;
oBANK_ACCOUNT_MASTER.UPDATED_AT_RAW = row["UPDATED_AT_RAW"].ToString() == "" ? null : row["UPDATED_AT_RAW"].ToString();
oBANK_ACCOUNT_MASTER.UPDATED_BY = row["UPDATED_BY"].ToString().Length >= 1 ? row["UPDATED_BY"].ToString() : null;
return(oBANK_ACCOUNT_MASTER);
}
public Response UpdateCustomer(string Customers)
{
using (TransactionScope dbTxn = new TransactionScope())
{
try
{
string strMessage = "";
DataTable dgvList = Utility.Utility_Component.JsonToDt(Customers);
if (dgvList.Rows.Count > 0)
{
for (int i = 0; i < dgvList.Rows.Count; i++)
{
BOL_CUSTOMER_MASTER B_Customer = new BOL_CUSTOMER_MASTER();
B_Customer.COMPANY_NO_BOX = (dgvList.Rows[i]["COMPANY_NO_BOX"] != null ? dgvList.Rows[i]["COMPANY_NO_BOX"].ToString() : "");
B_Customer.TRANSACTION_TYPE = Utility.Utility_Component.dtColumnToInt((dgvList.Rows[i]["TRANSACTION_TYPE"] != null ? dgvList.Rows[i]["TRANSACTION_TYPE"].ToString() : ""));
B_Customer.NCS_CUSTOMER_CODE = (dgvList.Rows[i]["NCS_CUSTOMER_CODE"] != null ? dgvList.Rows[i]["NCS_CUSTOMER_CODE"].ToString() : "");
B_Customer.EFFECTIVE_DATE = DateTime.Parse(dgvList.Rows[i]["EFFECTIVE_DATE"] != null ? dgvList.Rows[i]["EFFECTIVE_DATE"].ToString() : "");
B_Customer.BILL_BILLING_INTERVAL = Utility.Utility_Component.dtColumnToInt((dgvList.Rows[i]["BILL_BILLING_INTERVAL"] != null ? dgvList.Rows[i]["BILL_BILLING_INTERVAL"].ToString() : ""));
B_Customer.BILL_DEPOSIT_RULES = Utility.Utility_Component.dtColumnToInt((dgvList.Rows[i]["BILL_DEPOSIT_RULES"] != null ? dgvList.Rows[i]["BILL_DEPOSIT_RULES"].ToString() : ""));
B_Customer.BILL_TRANSFER_FEE = Utility.Utility_Component.dtColumnToDecimal((dgvList.Rows[i]["BILL_TRANSFER_FEE"] != null ? dgvList.Rows[i]["BILL_TRANSFER_FEE"].ToString() : ""));
B_Customer.BILL_EXPENSES = Utility.Utility_Component.dtColumnToDecimal(dgvList.Rows[i]["BILL_EXPENSES"] != null ? dgvList.Rows[i]["BILL_EXPENSES"].ToString() : "");
B_Customer.REQ_SEQ = Utility.Utility_Component.dtColumnToInt((dgvList.Rows[i]["REQ_SEQ"] != null ? dgvList.Rows[i]["REQ_SEQ"].ToString() : ""));
B_Customer.UPDATED_AT = CURRENT_DATETIME;
B_Customer.UPDATED_BY = CURRENT_USER;
CUSTOMER_MASTER DAL_Customer = new CUSTOMER_MASTER(con);
DAL_Customer.Update(B_Customer, out strMessage);
if (!string.IsNullOrEmpty(strMessage))
{
break;
}
BOL_BANK_ACCOUNT_MASTER B_BankAccounts = new BOL_BANK_ACCOUNT_MASTER();
B_BankAccounts.COMPANY_NO_BOX = B_Customer.COMPANY_NO_BOX;
B_BankAccounts.REQ_SEQ = B_Customer.REQ_SEQ;
B_BankAccounts.BILL_BANK_ACCOUNT_NAME_1 = (dgvList.Rows[i]["BILL_BANK_ACCOUNT_NAME-1"] != null ? dgvList.Rows[i]["BILL_BANK_ACCOUNT_NAME-1"].ToString() : "");
B_BankAccounts.BILL_BANK_ACCOUNT_NAME_2 = (dgvList.Rows[i]["BILL_BANK_ACCOUNT_NAME-2"] != null ? dgvList.Rows[i]["BILL_BANK_ACCOUNT_NAME-2"].ToString() : "");
B_BankAccounts.BILL_BANK_ACCOUNT_NAME_3 = (dgvList.Rows[i]["BILL_BANK_ACCOUNT_NAME-3"] != null ? dgvList.Rows[i]["BILL_BANK_ACCOUNT_NAME-3"].ToString() : "");
B_BankAccounts.BILL_BANK_ACCOUNT_NAME_4 = (dgvList.Rows[i]["BILL_BANK_ACCOUNT_NAME-4"] != null ? dgvList.Rows[i]["BILL_BANK_ACCOUNT_NAME-4"].ToString() : "");
B_BankAccounts.UPDATED_AT = CURRENT_DATETIME;
B_BankAccounts.UPDATED_BY = CURRENT_USER;
BANK_ACCOUNT_MASTER DAL_BankAccount = new BANK_ACCOUNT_MASTER(con);
DAL_BankAccount.Update(B_BankAccounts, out strMessage);
if (!string.IsNullOrEmpty(strMessage))
{
break;
}
}
}
if (string.IsNullOrEmpty(strMessage))
{
dbTxn.Complete();
response.Status = 1;
response.Message = "Customer updated";
}
else
{
response.Status = 0;
response.Message = strMessage;
}
return(response);
}
catch (Exception ex)
{
dbTxn.Dispose();
response.Status = 0;
response.Message = ex.Message + "\n" + ex.StackTrace;
return(response);
}
}
}
