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); } }