public Response GetNonAmigoDetailByRunDate(string dtmID)
{
try
{
RECEIPT_DETAILS_NON_AMIGO oRecpt = new RECEIPT_DETAILS_NON_AMIGO(Properties.Settings.Default.MyConnection);
string strMessage = "";
DataTable dt = oRecpt.GetNonAmigoDetailByRunDate(dtmID, out strMessage);
response.Data = Utility.Utility_Component.DtToJSon(dt, "31Result");
if (dt.Rows.Count > 0)
{
response.Status = 1;
}
else
{
if (strMessage == "")
{
response.Status = 1;
response.Message = "There has no data to display.";
}
else
{
response.Status = 0;
response.Message = strMessage;
}
}
return(response);
}
catch (Exception ex)
{
response.Status = 0;
response.Message = ex.Message + "\n" + ex.StackTrace;
return(response);
}
}
public Response do3A_BatchProcess()
{
using (TransactionScope dbTxn = new TransactionScope())
{
try
{
convertDataToDataTable(_UploadData);
seperateAmigo_NonAmigo();
string strMessage = "";
for (int i = 0; i < lstAmigo.Count; i++)
{
strMessage = "";
RECEIPT_DETAILS oDetail = new RECEIPT_DETAILS(Properties.Settings.Default.MyConnection);
if (oDetail.GetDataByDuplicateKeys(lstAmigo[i], out strMessage).Rows.Count <= 0)
{
oDetail.insert(lstAmigo[i], out strMessage);
}
}
for (int i = 0; i < lstNonAmigo.Count; i++)
{
strMessage = "";
RECEIPT_DETAILS_NON_AMIGO oDetail = new RECEIPT_DETAILS_NON_AMIGO(Properties.Settings.Default.MyConnection);
if (oDetail.GetDataByDuplicateKeys(lstNonAmigo[i], out strMessage).Rows.Count <= 0)
{
oDetail.insert(lstNonAmigo[i], out strMessage);
}
}
if (strMessage == "")
{
dbTxn.Complete();
response.Status = 1;
}
else
{
dbTxn.Dispose();
response.Status = 0;
}
return(response);
}
catch (Exception ex)
{
response.Status = 0;
response.Message = ex.Message + "\n" + ex.StackTrace;
dbTxn.Dispose();
return(response);
}
}
}
public Response ConvertAmigoToNoAmigo(string strData)
{
try
{
string strMessage = "";
DataTable dtAmigo = Utility.Utility_Component.JsonToDt(strData);
for (int i = 0; i < dtAmigo.Rows.Count; i++)
{
int intSEQNO = int.Parse(dtAmigo.Rows[i]["SEQNO"] == null ? "0" : dtAmigo.Rows[i]["SEQNO"].ToString());
RECEIPT_DETAILS_NON_AMIGO oRecpNonAmigo = new RECEIPT_DETAILS_NON_AMIGO(Properties.Settings.Default.MyConnection);
RECEIPT_DETAILS oRecpAmigo = new RECEIPT_DETAILS(Properties.Settings.Default.MyConnection);
oRecpNonAmigo.ConvertFromAmigoToNonAmigo(intSEQNO, out strMessage);
if (strMessage == "")
{
oRecpAmigo.removeAmigo(intSEQNO, out strMessage);
}
}
if (strMessage != "")
{
response.Status = 0;
response.Message = strMessage;
}
else
{
response.Status = 1;
response.Message = "Successfully converted.";
}
return(response);
}
catch (Exception ex)
{
response.Status = 0;
response.Message = ex.Message + "\n" + ex.StackTrace;
return(response);
}
}
