public Response RefundProcess(string strData)
{
using (TransactionScope dbTxn = new TransactionScope())
{
try
{
string strReturnMsg = "";
DataTable dtData = AmigoProcessManagement.Utility.Utility_Component.JsonToDt(strData);
if (dtData.Rows.Count > 0)
{
for (int i = 0; i < dtData.Rows.Count; i++)
{
int SEQ_NO = AmigoProcessManagement.Utility.Utility_Component.dtColumnToInt((dtData.Rows[i]["SEQ_NO"] == null ? "" : dtData.Rows[i]["SEQ_NO"].ToString()));
DAL_AmigoProcess.DAL.RECEIPT_DETAILS oRecpt = new DAL_AmigoProcess.DAL.RECEIPT_DETAILS(Properties.Settings.Default.MyConnection);
strReturnMsg = oRecpt.RefundUpdate(SEQ_NO); //update refund status
if (strReturnMsg != "") //get DB error
{
break;
}
}
}
else
{
response.Status = 0;
strReturnMsg = "Data Error.";
}
if (strReturnMsg != "")
{
dbTxn.Dispose(); //rollback
response.Status = 0;
}
else
{
dbTxn.Complete(); //commit operation
response.Status = 1;
}
response.Message = strReturnMsg;
return(response);
}
catch (Exception ex)
{
response.Status = 0;
response.Message = ex.Message + "\n" + ex.StackTrace;
dbTxn.Dispose();
return(response);
}
}
}
public Response ConvertNonAmigoToAmigo(string strData)
{
try
{
string strMessage = "";
int fail_count = 0;
DataTable dtConvert = Utility.Utility_Component.JsonToDt(strData);
response.Status = 1;
for (int i = 0; i < dtConvert.Rows.Count; i++)
{
DAL_AmigoProcess.DAL.RECEIPT_DETAILS_NON_AMIGO oRecpNonAmigo = new DAL_AmigoProcess.DAL.RECEIPT_DETAILS_NON_AMIGO(Properties.Settings.Default.MyConnection);
DAL_AmigoProcess.DAL.RECEIPT_DETAILS oRecpAmigo = new DAL_AmigoProcess.DAL.RECEIPT_DETAILS(Properties.Settings.Default.MyConnection);
int intSEQNO = int.Parse(dtConvert.Rows[i]["SEQNO"] == null ? "0" : dtConvert.Rows[i]["SEQNO"].ToString());
string bankAccountName = dtConvert.Rows[i]["bankAccountName"] == null ? "0" : dtConvert.Rows[i]["bankAccountName"].ToString();
//search with bankAccountName
DAL_AmigoProcess.DAL.CUSTOMER_MASTER oCustomer = new DAL_AmigoProcess.DAL.CUSTOMER_MASTER(Properties.Settings.Default.MyConnection);
DataTable dt = oCustomer.SearchByBankAccountName(bankAccountName);
if (dt.Rows.Count > 0)
{
oRecpAmigo.ConvertFromNonAmigoToAmigo(intSEQNO, out strMessage);
if (strMessage == "")
{
oRecpNonAmigo.removeNonAmigo(intSEQNO, out strMessage);
}
if (strMessage != "")
{
response.Status = 0;
response.Message = strMessage;
}
}
else
{
fail_count++;
response.Status = 0;
}
}
response.Message = fail_count.ToString();
return(response);
}
catch (Exception ex)
{
response.Status = 0;
response.Message = ex.Message + "\n" + ex.StackTrace;
return(response);
}
}
