public MetaResponse GetSubProgramLists() { try { string msg = ""; REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); DataTable dt = DAL_REQUEST_DETAIL.GetSubProgramLists(out msg); response.Data = Utility.Utility_Component.DtToJSon(dt, "Usage Application : Sub Program Lists"); if (dt.Rows.Count > 0) { response.Status = 1; } else { if (msg == "") { response.Status = 1; response.Message = "There is no data to display."; } else { response.Status = 0; response.Message = msg; } } timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse UpdateRequestDetail(string list) { try { DataTable dgvList = Utility.Utility_Component.JsonToDt(list); for (int i = 0; i < dgvList.Rows.Count; i++) { BOL_REQUEST_DETAIL oREQUEST_DETAIL = new BOL_REQUEST_DETAIL(); oREQUEST_DETAIL = Cast_REQUEST_DETAIL(dgvList.Rows[i]); BOL_REQUEST_ID oREQUEST_ID = new BOL_REQUEST_ID(); oREQUEST_ID = Cast_REQUEST_ID(dgvList.Rows[i]); switch (dgvList.Rows[i]["MK"].ToString()) { case "M": HandleModify(oREQUEST_DETAIL, oREQUEST_ID, dgvList.Rows[i]); break; default: break; } } response.Status = 1; response.Data = Utility.Utility_Component.DtToJSon(dgvList, "Application List Update");; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse getInitialData(string COMPANY_NO_BOX, string REQ_SEQ) { try { string msg = ""; REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); DataTable dt = DAL_REQUEST_DETAIL.Search(COMPANY_NO_BOX, REQ_SEQ, out msg); response.Data = Utility.Utility_Component.DtToJSon(dt, "Initial Data"); if (dt.Rows.Count > 0) { response.Status = 1; } else { if (msg == "") { response.Status = 1; response.Message = "There is no data to display."; } else { response.Status = 0; response.Message = msg; } } return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse SendMail(string CompanyCodeList) { try { string strMsg = ""; DataTable dgvList = Utility.Utility_Component.JsonToDt(CompanyCodeList); for (int i = 0; i < dgvList.Rows.Count; i++) { //cast to REQUEST_ID object BOL_REQUEST_ID oREQUEST_ID = new BOL_REQUEST_ID(); oREQUEST_ID = Cast_REQUEST_ID(dgvList.Rows[i]); REQUEST_ID DAL_REQUEST_ID = new REQUEST_ID(con); if (!DAL_REQUEST_ID.IsAlreadyUpdated(oREQUEST_ID, out strMsg)) // If updated_at is not already modified { bool mailSuccess = PrepareAndSendMail(oREQUEST_ID); if (mailSuccess) { //update email sent date oREQUEST_ID.EMAIL_SEND_DATE = TEMP; DAL_REQUEST_ID.UpdateMailDate(oREQUEST_ID, CURRENT_DATETIME, CURRENT_USER, out strMsg); if (String.IsNullOrEmpty(strMsg)) { //success message dgvList.Rows[i]["EMAIL_SEND_DATE"] = UPDATED_AT_DATETIME; ResponseUtility.ReturnMailSuccessMessage(dgvList.Rows[i], UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else { //fail message ResponseUtility.MailSendingFail(dgvList.Rows[i]); } } else { ResponseUtility.MailSendingFail(dgvList.Rows[i]); } } else { ResponseUtility.ReturnFailMessage(dgvList.Rows[i]); } } response.Status = 1; response.Data = Utility.Utility_Component.DtToJSon(dgvList, "Mail status");; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse GDConfirmRequest(string list) { try { string msg = ""; DataTable dgvList = Utility.Utility_Component.JsonToDt(list); for (int i = 0; i < dgvList.Rows.Count; i++) { BOL_REQUEST_DETAIL oREQUEST_DETAIL = new BOL_REQUEST_DETAIL(); BOL_REQUEST_ID oREQUEST_ID = new BOL_REQUEST_ID(); //cast into objects oREQUEST_ID = Cast_REQUEST_ID(dgvList.Rows[i]); oREQUEST_DETAIL = Cast_REQUEST_DETAIL(dgvList.Rows[i]); //send mail bool mailSuccess = PrepareAndSendMail(oREQUEST_DETAIL, true, null); if (mailSuccess) { REQUEST_ID DAL_REQUEST_ID = new REQUEST_ID(con); if (!DAL_REQUEST_ID.IsAlreadyUpdated(oREQUEST_ID, out msg)) { //set GD to 1 oREQUEST_ID.GD = 1; //insert the record DAL_REQUEST_ID.GDConfirmationRequestUpdate(oREQUEST_ID, CURRENT_DATETIME, CURRENT_USER, out msg); //return message and MK value if (String.IsNullOrEmpty(msg)) //success { ResponseUtility.ReturnSuccessMessage(dgvList.Rows[i], UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER, string.Format(Utility.Messages.Jimugo.I000ZZ016, "GD確認依頼")); } else //failed { ResponseUtility.ReturnFailMessage(dgvList.Rows[i]); } } } else { ResponseUtility.MailSendingFail(dgvList.Rows[i]); } } response.Status = 1; response.Data = Utility.Utility_Component.DtToJSon(dgvList, "GD Confirm Request");; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse UpdateApplicationCancel(string list) { try { string msg = ""; DataTable dgvList = Utility.Utility_Component.JsonToDt(list); for (int i = 0; i < dgvList.Rows.Count; i++) { BOL_REQUEST_DETAIL oREQUEST_DETAIL = new BOL_REQUEST_DETAIL(); oREQUEST_DETAIL = Cast_REQUEST_DETAIL(dgvList.Rows[i]); REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); //already setting if (oREQUEST_DETAIL.SYSTEM_SETTING_STATUS != 0) { ResponseUtility.ReturnFailMessage(dgvList.Rows[i], Messages.Jimugo.E000WB011); } else { if (!DAL_REQUEST_DETAIL.IsAlreadyUpdated(oREQUEST_DETAIL, out msg)) // If updated_at is not already modified { //insert the record DAL_REQUEST_DETAIL.ApplicationCancelUpdate(oREQUEST_DETAIL, CURRENT_DATETIME, CURRENT_USER, out msg); //return message and MK value if (String.IsNullOrEmpty(msg)) //success { dgvList.Rows[i]["REQ_STATUS"] = "申請取消"; ResponseUtility.ReturnSuccessMessage(dgvList.Rows[i], UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER, string.Format(Utility.Messages.Jimugo.I000ZZ016, "申請取消")); } else //failed { ResponseUtility.ReturnFailMessage(dgvList.Rows[i]); } } else { ResponseUtility.ReturnFailMessage(dgvList.Rows[i]); } } } response.Status = 1; response.Data = Utility.Utility_Component.DtToJSon(dgvList, "Application Cancel ");; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse GDConfirmComplete(string list) { try { string msg = ""; DataTable dgvList = Utility.Utility_Component.JsonToDt(list); for (int i = 0; i < dgvList.Rows.Count; i++) { //cast into objects BOL_REQUEST_DETAIL oREQUEST_DETAIL = new BOL_REQUEST_DETAIL(); BOL_REQUEST_ID oREQUEST_ID = new BOL_REQUEST_ID(); oREQUEST_DETAIL = Cast_REQUEST_DETAIL(dgvList.Rows[i]); oREQUEST_ID = Cast_REQUEST_ID(dgvList.Rows[i]); //get GD code By COMPANY NO BOX REQUEST_ID DAL_REQUEST_ID = new REQUEST_ID(con); string GD_CODE = DAL_REQUEST_ID.GetGDCode(oREQUEST_ID.COMPANY_NO_BOX.ToString(), out msg); if (string.IsNullOrEmpty(msg)) { #region Send Mail bool mailSuccess = PrepareAndSendMail(oREQUEST_DETAIL, false, GD_CODE); if (mailSuccess) //success { ResponseUtility.ReturnSuccessMessage(dgvList.Rows[i], UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER, string.Format(Utility.Messages.Jimugo.I000ZZ016, "GD確認完了")); } else //failed { ResponseUtility.MailSendingFail(dgvList.Rows[i]); } #endregion } else { ResponseUtility.ReturnFailMessage(dgvList.Rows[i]); } } response.Status = 1; response.Data = Utility.Utility_Component.DtToJSon(dgvList, "GD Confirmation Complete");; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse UpdateClientCertificateList(string ClientCertificateList, string authHeader) { try { DataTable dgvList = Utility.Utility_Component.JsonToDt(ClientCertificateList); for (int i = 0; i < dgvList.Rows.Count; i++) { BOL_CLIENT_CERTIFICATE oCLIENT_CERTIFICATE = new BOL_CLIENT_CERTIFICATE(); oCLIENT_CERTIFICATE = Cast_CLIENT_CERTIFICATE(dgvList.Rows[i]); //assign login ID switch (dgvList.Rows[i]["MK"].ToString()) { case "I": HandleInsert(oCLIENT_CERTIFICATE, "I", dgvList.Rows[i]); break; case "C": HandleInsert(oCLIENT_CERTIFICATE, "C", dgvList.Rows[i]); break; case "M": HandleModify(oCLIENT_CERTIFICATE, "M", dgvList.Rows[i]); break; case "D": HandleDelete(oCLIENT_CERTIFICATE, dgvList.Rows[i]); break; default: break; } } response.Data = Utility.Utility_Component.DtToJSon(dgvList, "CompanyCodeList Update"); timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalMilliseconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse SettingCompleteMail(string UsageInfoRegList) { try { string msg = ""; DataTable dgvList = Utility.Utility_Component.JsonToDt(UsageInfoRegList); for (int i = 0; i < dgvList.Rows.Count; i++) { USAGE_INFO_REGISTRATION oUSAGE_INFO_REG = new USAGE_INFO_REGISTRATION(); oUSAGE_INFO_REG = CAST_TO_USAGE_INFO_REGISTRATION(dgvList.Rows[i]); REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); DAL_REQUEST_DETAIL.UpdateSystemSettingStatus(2, oUSAGE_INFO_REG.COMPNAY_NO_BOX, CURRENT_USER, CURRENT_DATETIME, out msg); if (string.IsNullOrEmpty(msg)) { bool mailSuccess = PrepareAndSendMail(oUSAGE_INFO_REG); if (mailSuccess) { dgvList.Rows[i]["SYSTEM_SETTING_STATUS"] = 2; ResponseUtility.ReturnMailSuccessMessage(dgvList.Rows[i], UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else { ResponseUtility.MailSendingFail(dgvList.Rows[i]); } } else { ResponseUtility.MailSendingFail(dgvList.Rows[i]); } } response.Data = Utility.Utility_Component.DtToJSon(dgvList, "Mail status");; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse UpdateCompanyCodeList(string CompanyCodeList) { try { DataTable dgvList = Utility.Utility_Component.JsonToDt(CompanyCodeList); for (int i = 0; i < dgvList.Rows.Count; i++) { BOL_REQUEST_ID oREQUEST_ID = new BOL_REQUEST_ID(); oREQUEST_ID = Cast_REQUEST_ID(dgvList.Rows[i]); switch (dgvList.Rows[i]["MK"].ToString()) { case "I": HandleInsert(oREQUEST_ID, "I", dgvList.Rows[i]); break; case "C": HandleInsert(oREQUEST_ID, "C", dgvList.Rows[i]); break; case "M": HandleModify(oREQUEST_ID, dgvList.Rows[i]); break; case "D": HandleDelete(oREQUEST_ID, dgvList.Rows[i]); break; default: break; } } response.Status = 1; response.Data = Utility.Utility_Component.DtToJSon(dgvList, "CompanyCodeList Update");; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse UpdateUsageRegistrationList(string UsageInfoRegList) { try { DataTable dgvList = Utility.Utility_Component.JsonToDt(UsageInfoRegList); for (int i = 0; i < dgvList.Rows.Count; i++) { //CAST usage info registration list into view model USAGE_INFO_REGISTRATION oUSAGE_INFO_REG = CAST_TO_USAGE_INFO_REGISTRATION(dgvList.Rows[i]); switch (dgvList.Rows[i]["MK"].ToString()) { case "I": HandleInsert(oUSAGE_INFO_REG, "I", dgvList.Rows[i]); break; case "C": HandleInsert(oUSAGE_INFO_REG, "C", dgvList.Rows[i]); break; case "M": HandleModify(oUSAGE_INFO_REG, dgvList.Rows[i]); break; case "D": HandleDelete(oUSAGE_INFO_REG, dgvList.Rows[i]); break; default: break; } } response.Status = 1; response.Data = Utility.Utility_Component.DtToJSon(dgvList, "Usage Application Registration Update");; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse GeneratePassword() { try { //generate raw password string raw_password = Crypto.GenerateRawPassword(); #region PreparePasswordResultTable DataTable dt = new DataTable(); dt.Columns.Add("PASSWORD"); dt.Columns.Add("PASSWORD_SET_DATE"); dt.Columns.Add("PASSWORD_EXPIRATION_DATE"); #endregion //get expire date from config tbl BOL_CONFIG config = new BOL_CONFIG("CTS010", con); //add row and data DateTime startDate = DateTime.Now; DateTime stopDate = DateTime.Today.AddDays(config.getIntValue("password.days.add") + 1).AddTicks(-1); DataRow dr = dt.NewRow(); dr["PASSWORD"] = raw_password; dr["PASSWORD_SET_DATE"] = startDate.ToString("yyyy/MM/dd HH:mm"); //get from config table dr["PASSWORD_EXPIRATION_DATE"] = stopDate.ToString("yyyy/MM/dd HH:mm"); dt.Rows.Add(dr); response.Data = Utility.Utility_Component.DtToJSon(dt, "Password Generate"); //return response response.Status = 1; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse getCompanyCodeList(string COMPANY_NO_BOX, string COMPANY_NAME, string EMAIL, int OFFSET, int LIMIT) { try { string strMessage = ""; int TOTAL = 0; REQUEST_ID DAL_REQUEST_ID = new REQUEST_ID(con); DataTable dt = DAL_REQUEST_ID.GetCompanyCodeList(COMPANY_NO_BOX, COMPANY_NAME, EMAIL, OFFSET, LIMIT, out strMessage, out TOTAL); response.Data = Utility.Utility_Component.DtToJSon(dt, "CompnayCodeList"); if (dt.Rows.Count > 0) { response.Status = 1; } else { if (strMessage == "") { response.Status = 1; response.Message = "There is no data to display."; } else { response.Status = 0; response.Message = strMessage; } } response.Meta.Offset = OFFSET; response.Meta.Limit = LIMIT; response.Meta.Total = TOTAL; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse getRequestDetailList(String COMPANY_NO_BOX, String COMPANY_NAME, String CLOSE_FLAG, String GD, String REQUEST_STATUS, String REQ_DATE_FROM, String REQ_DATE_TO, String QUOTATION_DATE_FROM, String QUOTATION_DATE_TO, String ORDER_DATE_FROM, String ORDER_DATE_TO, String SYSTEM_SETTING_STATUS, int OFFSET, int LIMIT) { try { string strMessage = ""; int TOTAL = 0; REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); DataTable dt = DAL_REQUEST_DETAIL.GetRequestDetailList(COMPANY_NO_BOX, COMPANY_NAME, CLOSE_FLAG, GD, REQUEST_STATUS, REQ_DATE_FROM, REQ_DATE_TO, QUOTATION_DATE_FROM, QUOTATION_DATE_TO, ORDER_DATE_FROM, ORDER_DATE_TO, SYSTEM_SETTING_STATUS, OFFSET, LIMIT, out strMessage, out TOTAL); response.Data = Utility.Utility_Component.DtToJSon(dt, "UsageApplicatioList"); if (dt.Rows.Count > 0) { response.Status = 1; } else { if (strMessage == "") { response.Status = 1; response.Message = "There is no data to display."; } else { response.Status = 0; response.Message = strMessage; } } response.Meta.Offset = OFFSET; response.Meta.Limit = LIMIT; response.Meta.Total = TOTAL; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse SubmitOrderRegister(string list, System.Web.HttpPostedFile file) { using (TransactionScope dbTxn = new TransactionScope()) { try { string msg = ""; //set global PARAMETERS PARAMETERS = Utility.Utility_Component.JsonToDt(list); #region Update REQUEST_DETAIL //cast to REQUEST DETAIL OBJECT BOL_REQUEST_DETAIL oREQUEST_DETAIL = new BOL_REQUEST_DETAIL(); oREQUEST_DETAIL = Cast_REQUEST_DETAIL(); oREQUEST_DETAIL.SYSTEM_SETTING_STATUS = 1; REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); DAL_REQUEST_DETAIL.Update(oREQUEST_DETAIL, CURRENT_DATETIME, CURRENT_USER, out msg); //rollback if not success if (!String.IsNullOrEmpty(msg)) { dbTxn.Dispose(); return(ResponseUtility.ReturnFailMessage(response, timer, BodyMessage)); } #endregion #region Insert CUSTOMER MASTER //COUNT IN CUSTOMER MASTER string COMPANY_NAME = GetParameterByKey("COMPANY_NAME"); string COMPANY_NO_BOX = GetParameterByKey("COMPANY_NO_BOX"); string CONTRACT_PLAN = GetParameterByKey("CONTRACT_PLAN"); int TRANSACTION_TYPE = int.Parse(GetParameterByKey("TRANSACTION_TYPE")); int REQ_SEQ = int.Parse(GetParameterByKey("REQ_SEQ")); int REQ_TYPE = int.Parse(GetParameterByKey("REQ_TYPE")); DateTime START_USE_DATE = DateTime.Parse(GetParameterByKey("START_USE_DATE")); CUSTOMER_MASTER DAL_CUSTOMER_MASTER = new CUSTOMER_MASTER(con); int customer_count = DAL_CUSTOMER_MASTER.getCustomerCountByKeys(COMPANY_NO_BOX, TRANSACTION_TYPE, START_USE_DATE, REQ_SEQ, out msg); if (customer_count == 0) //if customer not found { DataTable LatestCustomer = new DataTable(); BOL_CUSTOMER_MASTER oCUSTOMER_MASTER = new BOL_CUSTOMER_MASTER(); if (REQ_TYPE == 2) { LatestCustomer = DAL_CUSTOMER_MASTER.GetTopCustomerByKeys(COMPANY_NO_BOX, TRANSACTION_TYPE, START_USE_DATE, out msg); if (LatestCustomer.Rows.Count > 0) { oCUSTOMER_MASTER = Cast_CUSTOMER_MASTER(LatestCustomer.Rows[0]); oCUSTOMER_MASTER.UPDATE_CONTENT = 3; } else //Need another message? { dbTxn.Dispose(); return(ResponseUtility.ReturnFailMessage(response, timer, BodyMessage)); } } if (REQ_TYPE == 1) { oCUSTOMER_MASTER.UPDATE_CONTENT = 1; } //insert info form screen oCUSTOMER_MASTER.COMPANY_NO_BOX = COMPANY_NO_BOX; oCUSTOMER_MASTER.TRANSACTION_TYPE = TRANSACTION_TYPE; oCUSTOMER_MASTER.EFFECTIVE_DATE = START_USE_DATE; oCUSTOMER_MASTER.REQ_SEQ = REQ_SEQ; DAL_CUSTOMER_MASTER.Insert(oCUSTOMER_MASTER, CURRENT_DATETIME, CURRENT_USER, out msg); //rollback if not success if (!String.IsNullOrEmpty(msg)) { dbTxn.Dispose(); return(ResponseUtility.ReturnFailMessage(response, timer, BodyMessage)); } #region Insert Browsing supplier CUSTOMER MASTER BOL_CUSTOMER_MASTER oBROWSING_SUPPLIER = new BOL_CUSTOMER_MASTER(); if (CONTRACT_PLAN == "PRODUCT" && REQ_TYPE == 2) { DateTime NEW_EFFECTIVE_DATE = Convert.ToDateTime(DAL_CUSTOMER_MASTER.GetEffectiveDateForNewApplyingTime(oREQUEST_DETAIL.COMPANY_NO_BOX, TRANSACTION_TYPE, START_USE_DATE, out msg)); if ((NEW_EFFECTIVE_DATE.Month + NEW_EFFECTIVE_DATE.Day) != (START_USE_DATE.Month + START_USE_DATE.Day)) { oBROWSING_SUPPLIER = Cast_CUSTOMER_MASTER(LatestCustomer.Rows[0]); oBROWSING_SUPPLIER.COMPANY_NO_BOX = COMPANY_NO_BOX; oBROWSING_SUPPLIER.TRANSACTION_TYPE = TRANSACTION_TYPE; oBROWSING_SUPPLIER.EFFECTIVE_DATE = Convert.ToDateTime(START_USE_DATE.Year + "/" + NEW_EFFECTIVE_DATE.Month + "/" + NEW_EFFECTIVE_DATE.Day); oBROWSING_SUPPLIER.UPDATE_CONTENT = 3; oBROWSING_SUPPLIER.REQ_SEQ = REQ_SEQ; DAL_CUSTOMER_MASTER.Insert(oBROWSING_SUPPLIER, CURRENT_DATETIME, CURRENT_USER, out msg); } //rollback if not success if (!String.IsNullOrEmpty(msg)) { dbTxn.Dispose(); return(ResponseUtility.ReturnFailMessage(response, timer, BodyMessage)); } } #endregion } #endregion #region Insert REPORT_HISTORY //Insert Report_History BOL_REPORT_HISTORY oREPORT_HISTORY = new BOL_REPORT_HISTORY(); oREPORT_HISTORY.COMPANY_NO_BOX = COMPANY_NO_BOX; oREPORT_HISTORY.REQ_SEQ = REQ_SEQ; oREPORT_HISTORY.REPORT_TYPE = 4; REPORT_HISTORY DAL_REPORT_HISTORY = new REPORT_HISTORY(con); int HISTORY_SEQ = DAL_REPORT_HISTORY.GetReportHistorySEQ(COMPANY_NO_BOX, oREPORT_HISTORY.REPORT_TYPE, oREPORT_HISTORY.REQ_SEQ, out msg); //rollback if not success if (!String.IsNullOrEmpty(msg)) { dbTxn.Dispose(); return(ResponseUtility.ReturnFailMessage(response, timer, BodyMessage)); } oREPORT_HISTORY.REPORT_HISTORY_SEQ = HISTORY_SEQ; oREPORT_HISTORY.OUTPUT_AT = Utility_Component.dtColumnToDateTime(DateTime.Now.ToString()); oREPORT_HISTORY.OUTPUT_FILE = COMPANY_NO_BOX + "-1-" + REQ_SEQ + "_注文書_" + COMPANY_NAME + "様.pdf"; oREPORT_HISTORY.EMAIL_ADDRESS = null; DAL_REPORT_HISTORY.Insert(oREPORT_HISTORY, CURRENT_DATETIME, CURRENT_USER, out msg); //rollback if not success if (!String.IsNullOrEmpty(msg)) { dbTxn.Dispose(); return(ResponseUtility.MailSendingFail(response, timer, BodyMessage)); } #endregion #region Save File //get destination path form config table BOL_CONFIG config = new BOL_CONFIG("CTS050", con); string destination = config.getStringValue("fileSavePath.purchaseOrder"); SaveFile(file, destination, oREPORT_HISTORY.OUTPUT_FILE, out msg); if (!string.IsNullOrEmpty(msg)) { dbTxn.Dispose(); response.Status = 0; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; response.Message = "File Path Not Found"; //add in body message DataRow row = BodyMessage.NewRow(); row["Error Message"] = "File Path Not Found"; BodyMessage.Rows.Add(row); response.Data = Utility_Component.DtToJSon(BodyMessage, "Message"); return(response); } #endregion #region SendMail bool mailSuccess = PrepareAndSendMail(); if (!mailSuccess) { dbTxn.Dispose(); return(ResponseUtility.MailSendingFail(response, timer, BodyMessage)); } #endregion //all process success dbTxn.Complete(); response.Status = 1; response.Message = string.Format(Utility.Messages.Jimugo.I000ZZ016, "注文登録"); DataRow dr = BodyMessage.NewRow(); dr["Message"] = response.Message; dr["UPDATED_AT"] = UPDATED_AT_DATETIME; dr["UPDATED_AT_RAW"] = CURRENT_DATETIME; BodyMessage.Rows.Add(dr); response.Data = Utility_Component.DtToJSon(BodyMessage, "Message"); timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { dbTxn.Dispose(); ResponseUtility.GetUnexpectedResponse(response, timer, ex); //add in body message DataRow dr = BodyMessage.NewRow(); dr["Error Message"] = "something went wrong."; BodyMessage.Rows.Add(dr); response.Data = Utility_Component.DtToJSon(BodyMessage, "Message"); return(response); } } }
public MetaResponse SendMailCreate(string list) //add more parameter { #region Parameters //message for pop up DataTable messagecode = new DataTable(); messagecode.Columns.Add("Error Message"); DataTable dtParameter = Utility.Utility_Component.JsonToDt(list); COMPANY_NO_BOX = dtParameter.Rows[0]["COMPANY_NO_BOX"].ToString(); REQ_SEQ = Convert.ToInt32(dtParameter.Rows[0]["REQ_SEQ"].ToString()); QUOTATION_DATE = dtParameter.Rows[0]["QUOTATION_DATE"].ToString(); ORDER_DATE = dtParameter.Rows[0]["ORDER_DATE"].ToString(); COMPLETION_NOTIFICATION_DATE = dtParameter.Rows[0]["COMPLETION_NOTIFICATION_DATE"].ToString(); COMPANY_NAME = dtParameter.Rows[0]["COMPANY_NAME"].ToString(); EMAIL_ADDRESS = dtParameter.Rows[0]["EMAIL_ADDRESS"].ToString(); EDI_ACCOUNT = dtParameter.Rows[0]["EDI_ACCOUNT"].ToString(); FILENAME = dtParameter.Rows[0]["FILENAME"].ToString(); #endregion string msg = ""; try { using (TransactionScope dbtnx = new TransactionScope()) { #region Update RequestDetail For CompleteNotificationSending DAL_REQUEST_DETAIL.SendMailUpdate(TEMP.ToString("yyyy/MM/dd"), COMPANY_NO_BOX, REQ_SEQ, CURRENT_DATETIME, CURRENT_USER, out msg); #endregion if (String.IsNullOrEmpty(msg)) { #region InsertReportHistroy DateTime now = DateTime.Now; string outputFile = COMPANY_NO_BOX + "-" + "3" + "-" + REQ_SEQ.ToString().PadLeft(2, '0') + "_完了通知書(" + EDI_ACCOUNT.Replace("@", "") + ")_" + COMPANY_NAME + "様" + ".pdf"; string msgText = outputFile; int REPORTHISTORY_SEQ = DAL_REPORT_HISTORY.GetReportHistorySEQ(COMPANY_NO_BOX, 5, REQ_SEQ, out msg); if (string.IsNullOrEmpty(msg)) { DAL_REPORT_HISTORY.InsertNotiSending(COMPANY_NO_BOX, REQ_SEQ, REPORTHISTORY_SEQ, outputFile, EMAIL_ADDRESS, CURRENT_USER, UPDATED_AT_DATETIME, CURRENT_DATETIME, out msg); if (string.IsNullOrEmpty(msg)) { BOL_CONFIG config = new BOL_CONFIG("CTS060", con); BOL_CONFIG config1 = new BOL_CONFIG("SYSTEM", con); string temPath = config1.getStringValue("temp.dir"); temPath = temPath + "/" + FILENAME; string pdfSavePath = config.getStringValue("fileSavePath.completionNotice"); pdfSavePath = pdfSavePath + "/" + outputFile; //CopyAndMove File int res = MovePdfFile(temPath, pdfSavePath); if (res == 1) { //BOL_CONFIG config1 = new BOL_CONFIG("SYSTEM", con); string zipStorageFolder = config1.getStringValue("temp.dir") + "/" + outputFile.Replace(".pdf", ".zi_"); string PASSWORD = config.getStringValue("password.Attachment"); //Create ZipFile With Password bool zipgenerate = ZipGenerator(temPath, PASSWORD, zipStorageFolder, outputFile); if (zipgenerate) { #region SendMail String emailAddressCC = config.getStringValue("emailAddress.cc"); string tempString = PrepareAndSendMail(COMPANY_NAME, PASSWORD); if (tempString != null) { string subjectString = config.getStringValue("emailSubject.notice"); DataTable result = new DataTable(); result.Clear(); result.Columns.Add("ZipFileName"); result.Columns.Add("EmailAddressCC"); result.Columns.Add("TemplateString"); result.Columns.Add("SubjectString"); result.Columns.Add("COMPLETE_NOTIFICATION_DATE"); result.Columns.Add("UPDATED_AT"); result.Columns.Add("UPDATED_AT_RAW"); DataRow dtRow = result.NewRow(); dtRow["ZipFileName"] = outputFile.Replace(".pdf", ".zi_"); dtRow["EmailAddressCC"] = emailAddressCC; dtRow["TemplateString"] = tempString; dtRow["SubjectString"] = subjectString.Replace("${companyName}", COMPANY_NAME); dtRow["COMPLETE_NOTIFICATION_DATE"] = TEMP.ToString("yyyy/MM/dd"); dtRow["UPDATED_AT"] = UPDATED_AT_DATETIME; dtRow["UPDATED_AT_RAW"] = CURRENT_DATETIME; result.Rows.Add(dtRow); dbtnx.Complete(); response.Data = Utility.Utility_Component.DtToJSon(result, "pdfData"); response.Status = 1; return(response); } else { return(ResponseUtility.ReturnFailMessage(response, timer, messagecode, Utility.Messages.Jimugo.E000WB018)); } #endregion } else { return(ResponseUtility.ReturnFailMessage(response, timer, messagecode, Utility.Messages.Jimugo.E000WB007)); } } else { return(ResponseUtility.ReturnFailMessage(response, timer, messagecode, String.Format(Utility.Messages.Jimugo.E000WB001, msgText))); } } else { return(ResponseUtility.ReturnFailMessage(response, timer, messagecode, Utility.Messages.Jimugo.E000WB003)); } } else { return(ResponseUtility.ReturnFailMessage(response, timer, messagecode, Utility.Messages.Jimugo.E000WB002)); } #endregion } else { return(ResponseUtility.ReturnFailMessage(response, timer, messagecode, Utility.Messages.Jimugo.E000WB002)); } } } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse Disapprove(string COMPANY_NO_BOX, int REQ_TYPE, string CHANGED_ITEMS, string SYSTEM_EFFECTIVE_DATE, string SYSTEM_REGIST_DEADLINE, string List) { try { DataSet ds = new DataSet(); DataTable Listing = Utility_Component.JsonToDt(List); DataRow row; if (Listing.Rows.Count > 1) { row = Listing.Rows[1]; } else { row = Listing.Rows[0]; } string msg = ""; BOL_REQUEST_DETAIL oREQUEST_DETAIL = new BOL_REQUEST_DETAIL(); oREQUEST_DETAIL.REQ_STATUS = 3; if (REQ_TYPE == 1 || REQ_TYPE == 9 || (REQ_TYPE == 2 && !string.IsNullOrEmpty(CHANGED_ITEMS.Trim()))) { oREQUEST_DETAIL.AMIGO_COOPERATION = 1; } else { oREQUEST_DETAIL.AMIGO_COOPERATION = 2; } oREQUEST_DETAIL.AMIGO_COOPERATION_CHENGED_ITEMS = CHANGED_ITEMS.Trim(); try { oREQUEST_DETAIL.SYSTEM_EFFECTIVE_DATE = Convert.ToDateTime(SYSTEM_EFFECTIVE_DATE); } catch (Exception) { } try { oREQUEST_DETAIL.SYSTEM_REGIST_DEADLINE = Convert.ToDateTime(SYSTEM_REGIST_DEADLINE); } catch (Exception) { } oREQUEST_DETAIL.REQ_SEQ = int.Parse(row["REQ_SEQ"].ToString()); oREQUEST_DETAIL.UPDATED_AT = row["UPDATED_AT_RAW"].ToString(); oREQUEST_DETAIL.COMPANY_NO_BOX = COMPANY_NO_BOX; REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); DAL_REQUEST_DETAIL.Disapprove(oREQUEST_DETAIL, CURRENT_USER, CURRENT_DATETIME, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } CUSTOMER_MASTER DAL_CUSTOMER_MASTER = new CUSTOMER_MASTER(con); BOL_CUSTOMER_MASTER oCUSTOMER_MASTER = new BOL_CUSTOMER_MASTER(); oCUSTOMER_MASTER.COMPANY_NO_BOX = COMPANY_NO_BOX; oCUSTOMER_MASTER.REQ_SEQ = oREQUEST_DETAIL.REQ_SEQ; DAL_CUSTOMER_MASTER.Delete(oCUSTOMER_MASTER, out msg); if (string.IsNullOrEmpty(msg)) { DataTable dtMail = new DataTable(); bool success = DisapproveSendMail(row["COMPANY_NAME"].ToString(), row["INPUT_PERSON"].ToString(), row["INPUT_PERSON_EMAIL_ADDRESS"].ToString(), out dtMail); if (success) { response.Status = 1; row["UPDATED_AT"] = UPDATED_AT_DATETIME; row["UPDATED_AT_RAW"] = CURRENT_DATETIME; row["UPDATED_BY"] = CURRENT_USER; row["UPDATE_MESSAGE"] = string.Format(Messages.Jimugo.I000ZZ016, "否認"); Listing.TableName = "LISTING"; ds.Tables.Add(Listing.Copy()); dtMail.TableName = "MAIL"; ds.Tables.Add(dtMail.Copy()); } else { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } } else { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } response.Data = Utility.Utility_Component.DsToJSon(ds, "Approval"); timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse getInitialData(string COMPANY_NO_BOX, string REQ_SEQ, int REQ_STATUS, int REQ_TYPE) { try { DataSet ds = new DataSet(); string strMessage = ""; REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); DataTable dtList = DAL_REQUEST_DETAIL.GetInitialDataForApproval(COMPANY_NO_BOX, REQ_SEQ, REQ_STATUS, REQ_TYPE, out strMessage); dtList.TableName = "LISTING"; ds.Tables.Add(dtList); if (dtList.Rows.Count > 0) { response.Status = 1; //SERVICE DESK POP UP REQ_ADDRESS DAL_REQ_ADDRESS = new REQ_ADDRESS(con); string _REQ_SEQ = dtList.Rows[0]["REQ_SEQ"].ToString().Trim(); if (REQ_TYPE == 2) { DataTable SERVICE_DESK_CURRENT = DAL_REQ_ADDRESS.GetServiceDeskPopUp(COMPANY_NO_BOX, _REQ_SEQ, out strMessage); SERVICE_DESK_CURRENT.TableName = "SERVICE_DESK_CURRENT"; ds.Tables.Add(SERVICE_DESK_CURRENT); } DataTable SERVICE_DESK_NEW = DAL_REQ_ADDRESS.GetServiceDeskPopUp(COMPANY_NO_BOX, REQ_SEQ, out strMessage); SERVICE_DESK_NEW.TableName = "SERVICE_DESK_CHANGE"; ds.Tables.Add(SERVICE_DESK_NEW); //ERROR NOTI POP UP if (REQ_TYPE == 2) { DataTable ERROR_NOTI_CURRENT = DAL_REQ_ADDRESS.GetErrorNotificationPopUp(COMPANY_NO_BOX, _REQ_SEQ, out strMessage); ERROR_NOTI_CURRENT.TableName = "ERROR_NOTI_CURRENT"; ds.Tables.Add(ERROR_NOTI_CURRENT); } DataTable ERROR_NOTI_NEW = DAL_REQ_ADDRESS.GetErrorNotificationPopUp(COMPANY_NO_BOX, REQ_SEQ, out strMessage); ERROR_NOTI_NEW.TableName = "ERROR_NOTI_CHANGE"; ds.Tables.Add(ERROR_NOTI_NEW); //BREAK DOWN if (REQ_TYPE == 2) { DataTable BREAKDOWN_CURRENT = DAL_REQ_ADDRESS.GetUsageChargeBreakDownPopUp(COMPANY_NO_BOX, _REQ_SEQ, out strMessage); BREAKDOWN_CURRENT.TableName = "BREAKDOWN_CURRENT"; ds.Tables.Add(BREAKDOWN_CURRENT); } DataTable BREAKDOWN_NEW = DAL_REQ_ADDRESS.GetUsageChargeBreakDownPopUp(COMPANY_NO_BOX, REQ_SEQ, out strMessage); BREAKDOWN_NEW.TableName = "BREAKDOWN_CHANGE"; ds.Tables.Add(BREAKDOWN_NEW); } else { if (string.IsNullOrEmpty(strMessage)) { response.Status = 1; response.Message = "There is no data to display."; } else { response.Status = 0; response.Message = strMessage; } } response.Data = Utility.Utility_Component.DsToJSon(ds, "INITIAL DATA"); timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse Approve(string COMPANY_NO_BOX, int REQ_TYPE, string REQ_TYPE_RAW, string CHANGED_ITEMS, string SYSTEM_EFFECTIVE_DATE, string SYSTEM_REGIST_DEADLINE, string List) { try { DataSet ds = new DataSet(); DataTable Listing = Utility_Component.JsonToDt(List); DataRow row; if (Listing.Rows.Count > 1) { row = Listing.Rows[1]; } else { row = Listing.Rows[0]; } string EMIAL_SENDING_TARGET_FLG = row["MAIL_SENDING_TARGET_FLG"].ToString().Trim(); string MAIL_DESTINATION = row["MAIL_DESTINATION"].ToString().Trim(); int TRANSACTION_TYPE = getTRANSACTION_TYPE(row["TRANSACTION_TYPE"].ToString().Trim()); DateTime START_USE_DATE = Convert.ToDateTime(row["START_USE_DATE"].ToString().Trim()); using (TransactionScope dbTxn = new TransactionScope()) { #region Approve BOL_REQUEST_DETAIL oREQUEST_DETAIL = new BOL_REQUEST_DETAIL(); oREQUEST_DETAIL.COMPANY_NO_BOX = COMPANY_NO_BOX; oREQUEST_DETAIL.REQ_STATUS = 2; if (REQ_TYPE == 1 || REQ_TYPE == 9 || (REQ_TYPE == 2 && !string.IsNullOrEmpty(CHANGED_ITEMS.Trim()))) { oREQUEST_DETAIL.AMIGO_COOPERATION = 1; } else { oREQUEST_DETAIL.AMIGO_COOPERATION = 2; } oREQUEST_DETAIL.AMIGO_COOPERATION_CHENGED_ITEMS = CHANGED_ITEMS.Trim(); try { oREQUEST_DETAIL.SYSTEM_EFFECTIVE_DATE = Convert.ToDateTime(SYSTEM_EFFECTIVE_DATE); } catch (Exception) { } try { oREQUEST_DETAIL.SYSTEM_REGIST_DEADLINE = Convert.ToDateTime(SYSTEM_REGIST_DEADLINE); } catch (Exception) { } oREQUEST_DETAIL.REQ_SEQ = int.Parse(row["REQ_SEQ"].ToString()); if (MAIL_DESTINATION == "1") { oREQUEST_DETAIL.SYSTEM_SETTING_STATUS = 1; } else { oREQUEST_DETAIL.SYSTEM_SETTING_STATUS = 0; } oREQUEST_DETAIL.UPDATED_AT = row["UPDATED_AT_RAW"].ToString(); string msg = ""; REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); DAL_REQUEST_DETAIL.Approve(oREQUEST_DETAIL, CURRENT_USER, CURRENT_DATETIME, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } #endregion if (EMIAL_SENDING_TARGET_FLG == "*" && TRANSACTION_TYPE == 3) { DataTable LatestCustomer = new DataTable(); CUSTOMER_MASTER DAL_CUSTOMER_MASTER = new CUSTOMER_MASTER(con); if (REQ_TYPE == 2 || REQ_TYPE == 9) { LatestCustomer = DAL_CUSTOMER_MASTER.GetTopCustomerByKeys(oREQUEST_DETAIL.COMPANY_NO_BOX, TRANSACTION_TYPE, START_USE_DATE, out msg); } #region CONDUCT NEW CUSTOMER MASTER BOL_CUSTOMER_MASTER oCUSTOMER_MASTER = new BOL_CUSTOMER_MASTER(); if (LatestCustomer.Rows.Count > 0 && REQ_TYPE != 1) { oCUSTOMER_MASTER = Cast_CUSTOMER_MASTER(LatestCustomer.Rows[0]); } oCUSTOMER_MASTER.COMPANY_NO_BOX = COMPANY_NO_BOX; oCUSTOMER_MASTER.TRANSACTION_TYPE = TRANSACTION_TYPE; oCUSTOMER_MASTER.EFFECTIVE_DATE = START_USE_DATE; oCUSTOMER_MASTER.REQ_SEQ = oREQUEST_DETAIL.REQ_SEQ; oCUSTOMER_MASTER.UPDATE_CONTENT = REQ_TYPE; DAL_CUSTOMER_MASTER.Delete(oCUSTOMER_MASTER, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } DAL_CUSTOMER_MASTER.Insert(oCUSTOMER_MASTER, CURRENT_DATETIME, CURRENT_USER, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } #endregion string CONTRACT_PLAN = row["CONTRACT_PLAN_RAW"].ToString().ToString(); if (CONTRACT_PLAN == "PRODUCT" && REQ_TYPE == 9) { //get latest customer for new applying time DateTime NEW_EFFECTIVE_DATE = Convert.ToDateTime(DAL_CUSTOMER_MASTER.GetEffectiveDateForNewApplyingTime(oREQUEST_DETAIL.COMPANY_NO_BOX, TRANSACTION_TYPE, START_USE_DATE, out msg)); if ((NEW_EFFECTIVE_DATE.Month + NEW_EFFECTIVE_DATE.Day) != (START_USE_DATE.Month + START_USE_DATE.Day)) { #region Insert Browsing CUSTOMER MASTER BOL_CUSTOMER_MASTER oCUSTOMER_MASTER_BROWSING = new BOL_CUSTOMER_MASTER(); oCUSTOMER_MASTER_BROWSING = Cast_CUSTOMER_MASTER(LatestCustomer.Rows[0]); oCUSTOMER_MASTER_BROWSING.COMPANY_NO_BOX = COMPANY_NO_BOX; oCUSTOMER_MASTER_BROWSING.TRANSACTION_TYPE = TRANSACTION_TYPE; oCUSTOMER_MASTER_BROWSING.EFFECTIVE_DATE = Convert.ToDateTime(START_USE_DATE.Year + "/" + NEW_EFFECTIVE_DATE.Month + "/" + NEW_EFFECTIVE_DATE.Day); oCUSTOMER_MASTER_BROWSING.REQ_SEQ = oREQUEST_DETAIL.REQ_SEQ; oCUSTOMER_MASTER_BROWSING.UPDATE_CONTENT = REQ_TYPE; DAL_CUSTOMER_MASTER = new CUSTOMER_MASTER(con); DAL_CUSTOMER_MASTER.Insert(oCUSTOMER_MASTER_BROWSING, CURRENT_DATETIME, CURRENT_USER, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } #endregion } } } DataTable dtMail = new DataTable(); bool mailSuccess = false; if (EMIAL_SENDING_TARGET_FLG == "*" && MAIL_DESTINATION == "1") { mailSuccess = SendMailToMaintenance(COMPANY_NO_BOX, REQ_TYPE_RAW, row["COMPANY_NAME"].ToString(), CHANGED_ITEMS, SYSTEM_REGIST_DEADLINE, out dtMail); if (mailSuccess) { dbTxn.Complete(); return(SetSuccessMessage(row, Listing, dtMail, ds)); } else { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } } else if (EMIAL_SENDING_TARGET_FLG == "*" && MAIL_DESTINATION == "2") { mailSuccess = SendMailToSupplier(row["COMPANY_NAME"].ToString(), row["INPUT_PERSON"].ToString(), row["INPUT_PERSON_EMAIL_ADDRESS"].ToString(), out dtMail); if (mailSuccess) { dbTxn.Complete(); return(SetSuccessMessage(row, Listing, dtMail, ds)); } else { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } } dbTxn.Complete(); return(SetSuccessMessage(row, Listing, dtMail, ds)); } } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse ApproveCancel(string COMPANY_NO_BOX, string REQ_SEQ, string List) { try { string msg = ""; DataSet ds = new DataSet(); DataTable Listing = Utility_Component.JsonToDt(List); DataRow row; if (Listing.Rows.Count > 1) { row = Listing.Rows[1]; } else { row = Listing.Rows[0]; } REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); //serch with COMPANY_NO_BOX AND REQ_SEQ DataTable APPROVAL_CHECK = DAL_REQUEST_DETAIL.GetDataToCheckApproveCancel(COMPANY_NO_BOX, REQ_SEQ, out msg); //IF QUOTATION DATE NOT NULL THEN ERROR if (!string.IsNullOrEmpty(APPROVAL_CHECK.Rows[0]["QUOTATION_DATE"].ToString())) { return(ResponseError(response, Utility.Messages.Jimugo.E000ZZ037, Listing, ds, row)); } //IF SYSTEM_SETTING_STATUS NOT NULL THEN ERROR if (APPROVAL_CHECK.Rows[0]["SYSTEM_SETTING_STATUS"].ToString() != "0") { return(ResponseError(response, Utility.Messages.Jimugo.E000WB015, Listing, ds, row)); } DAL_REQUEST_DETAIL.ApproveCancel(COMPANY_NO_BOX, row["REQ_SEQ"].ToString(), CURRENT_USER, CURRENT_DATETIME, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } CUSTOMER_MASTER DAL_CUSTOMER_MASTER = new CUSTOMER_MASTER(con); BOL_CUSTOMER_MASTER oCUSTOMER_MASTER = new BOL_CUSTOMER_MASTER(); oCUSTOMER_MASTER.COMPANY_NO_BOX = COMPANY_NO_BOX; oCUSTOMER_MASTER.REQ_SEQ = Convert.ToInt32(row["REQ_SEQ"]); DAL_CUSTOMER_MASTER.Delete(oCUSTOMER_MASTER, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } else { response.Status = 1; row["UPDATE_MESSAGE"] = string.Format(Messages.Jimugo.I000ZZ016, "承認解除"); Listing.TableName = "LISTING"; ds.Tables.Add(Listing.Copy()); } response.Data = Utility.Utility_Component.DsToJSon(ds, "Approval"); timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse NotiSendingPreview(string COMPANY_NAME, string COMPANY_NO_BOX, string REQ_SEQ, string EDI_ACCOUNT, string authHeader) { try { //int status; //message for pop up DataTable messagecode = new DataTable(); messagecode.Columns.Add("Message"); DataRow dr = messagecode.NewRow(); string strMessage = ""; //get config object for CTS060 BOL_CONFIG config = new BOL_CONFIG("SYSTEM", con); int FY = config.getIntValue("client.certificate.FY"); status = 1; int clientCertificateDiff = DAL_REQUEST_DETAIL.GetClientCertificateDiff(COMPANY_NO_BOX, REQ_SEQ, FY.ToString(), out strMessage); using (TransactionScope dbTxn = new TransactionScope()) { for (int i = 1; i <= clientCertificateDiff; i++) { #region SearchClientCertificateNo string clientCertificateNo = DAL_CLIENT_CERTIFICATE.GetClientCertificateNo(FY.ToString(), out strMessage); if (!string.IsNullOrEmpty(clientCertificateNo)) { #region UpdateWithClientCertificateNo status = UpdateWithClientCertificateNO(clientCertificateNo, COMPANY_NO_BOX, CURRENT_USER, strMessage); #endregion if (status == 0) { dbTxn.Dispose(); response.Status = 0; response.Message = Utility.Messages.Jimugo.E000WB005; dr["Message"] = Utility.Messages.Jimugo.E000WB005; messagecode.Rows.Add(dr); response.Data = Utility_Component.DtToJSon(messagecode, "Message"); return(response); } } else { response.Status = 0; response.Message = Utility.Messages.Jimugo.E000WB004; dr["Message"] = Utility.Messages.Jimugo.E000WB004; messagecode.Rows.Add(dr); response.Data = Utility_Component.DtToJSon(messagecode, "Message"); return(response); } #endregion } if (status == 2) { dbTxn.Complete(); } } if (status == 1 || status == 2) { #region GetPDFData DataTable dtPDFData = DAL_REQUEST_DETAIL.GetPDFData(COMPANY_NO_BOX, REQ_SEQ, out strMessage); DataTable dtPDFData1 = DAL_REQ_ADDRESS.GetPDFData1(COMPANY_NO_BOX, REQ_SEQ, out strMessage); DataTable dtPDFData2 = DAL_REQ_ADDRESS.GetPDFData2(COMPANY_NO_BOX, REQ_SEQ, out strMessage); string req_seq = REQ_SEQ.Length != 1 ? REQ_SEQ : REQ_SEQ.ToString().PadLeft(2, '0'); string saveFileName = COMPANY_NO_BOX + "-" + "3" + "-" + req_seq + "_完了通知書(" + EDI_ACCOUNT.Replace("@", "") + ")_" + COMPANY_NAME + "様_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf"; response = getPDF(COMPANY_NO_BOX, COMPANY_NAME, dtPDFData, dtPDFData1, dtPDFData2, saveFileName, status); #endregion } else { response.Status = 0; response.Message = Utility.Messages.Jimugo.I000WB001; dr["Message"] = Utility.Messages.Jimugo.I000WB001; messagecode.Rows.Add(dr); response.Data = Utility_Component.DtToJSon(messagecode, "Message"); return(response); } return(response); //process 3 successful } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse getInvoiceList(String BILLING_DATE, int OFFSET, int LIMIT) { try { string strMessage = ""; int TOTAL = 0; string checkGetOrCreate = "GET"; #region Declare decimal Key_source_Monthly_usage_fee_REQ_SEQ = 0; decimal Key_source_Monthly_usage_fee = 0; decimal Key_source_Monthly_usage_fee_DISCOUNTED = 0; decimal Key_source_Monthly_usage_fee_TAX = 0; decimal Key_source_Monthly_usage_fee_INCLUDING_TAX = 0; decimal Supplier_Initial_expense_REQ_SEQ = 0; decimal Supplier_Initial_expense = 0; decimal Supplier_Initial_expense_DISCOUNTED = 0; decimal Supplier_Initial_expense_TAX = 0; decimal Supplier_Initial_expense_INCLUDING_TAX = 0; decimal Supplier_Monthly_usage_fee_REQ_SEQ = 0; decimal supplier_Monthly_usage_fee = 0; decimal Supplier_Monthly_usage_fee_DISCOUNTED = 0; decimal Supplier_Monthly_usage_fee_TAX = 0; decimal Supplier_Monthly_usage_fee_INCLUDING_TAX = 0; decimal Production_information_browsing_Initial_expense_REQ_SEQ = 0; decimal Production_information_browsing_Initial_expense = 0; decimal Production_information_browsing_Initial_expense_DISCOUNTED = 0; decimal Production_information_browsing_Initial_expense_TAX; decimal Production_information_browsing_Initial_expense_INCLUDING_TAX = 0; decimal View_production_information_Annual_usage_fee_REQ_SEQ = 0; decimal Viewing_production_information_Annual_usage_fee = 0; decimal View_production_information_Annual_usage_fee_DISCOUNTED = 0; decimal View_production_information_Annual_usage_fee_TAX = 0; decimal View_production_information_Annual_usage_fee_INCLUDING_TAX = 0; #endregion INVOICE_INFO DAL_INVOICE_INFO = new INVOICE_INFO(con); DataTable dt = DAL_INVOICE_INFO.GetInvoiceList(BILLING_DATE, OFFSET, LIMIT, checkGetOrCreate, out strMessage, out TOTAL); DataTable dtAll = DAL_INVOICE_INFO.GetInvoiceListTotal(BILLING_DATE, out strMessage); #region Create Datatable DataTable dtResult = new DataTable(); dtResult.Columns.Add("No"); dtResult.Columns.Add("COMPANY_NO_BOX"); dtResult.Columns.Add("COMPANY_NAME"); dtResult.Columns.Add("KEY_SOURCE_MONTHLY_USAGE_FEE", typeof(decimal)); dtResult.Columns.Add("SUPPLIER_INITIAL_EXPENSE", typeof(decimal)); dtResult.Columns.Add("SUPPLIER_MONTHLY_USAGE_FEE", typeof(decimal)); dtResult.Columns.Add("BROWSING_INITIAL_EXPENSE", typeof(decimal)); dtResult.Columns.Add("YEARLY_USAGE_FEE", typeof(decimal)); dtResult.Columns.Add("POSTAL_MAIL"); dtResult.Columns.Add("WEB"); dtResult.Columns.Add("Email"); dtResult.Columns.Add("CREDIT_CARD"); dtResult.Columns.Add("OTHER"); dtResult.Columns.Add("Key_source_Monthly_usage_fee_REQ_SEQ"); dtResult.Columns.Add("Supplier_Initial_expense_REQ_SEQ"); dtResult.Columns.Add("Supplier_Monthly_usage_fee_REQ_SEQ"); dtResult.Columns.Add("Production_information_browsing_Initial_expense_REQ_SEQ"); dtResult.Columns.Add("View_production_information_Annual_usage_fee_REQ_SEQ"); #endregion #region Create Datatable ForTotal DataTable dtTotal = new DataTable(); dtTotal.Columns.Add("KEY_SOURCE_MONTHLY_USAGE_FEE", typeof(decimal)); dtTotal.Columns.Add("SUPPLIER_INITIAL_EXPENSE", typeof(decimal)); dtTotal.Columns.Add("SUPPLIER_MONTHLY_USAGE_FEE", typeof(decimal)); dtTotal.Columns.Add("BROWSING_INITIAL_EXPENSE", typeof(decimal)); dtTotal.Columns.Add("YEARLY_USAGE_FEE", typeof(decimal)); dtTotal.Columns.Add("POSTAL_MAIL"); dtTotal.Columns.Add("WEB"); dtTotal.Columns.Add("Email"); dtTotal.Columns.Add("CREDIT_CARD"); dtTotal.Columns.Add("OTHER"); #endregion foreach (DataRow row in dt.Rows) { #region SetValue To DataTable DataRow newRow = dtResult.NewRow(); newRow["No"] = row["No"]; newRow["COMPANY_NO_BOX"] = row["COMPANY_NO_BOX"]; newRow["COMPANY_NAME"] = row["COMPANY_NAME"]; Key_source_Monthly_usage_fee_REQ_SEQ = NullOrEmpty(row["Key_source_Monthly_usage_fee_REQ_SEQ"].ToString()); Key_source_Monthly_usage_fee = NullOrEmpty(row["Key_source_Monthly_usage_fee"].ToString()); Key_source_Monthly_usage_fee_DISCOUNTED = NullOrEmpty(row["Key_source_Monthly_usage_fee_DISCOUNTED"].ToString()); Key_source_Monthly_usage_fee_TAX = NullOrEmpty(row["Key_source_Monthly_usage_fee_TAX"].ToString()); Key_source_Monthly_usage_fee_INCLUDING_TAX = NullOrEmpty(row["Key_source_Monthly_usage_fee_INCLUDING_TAX"].ToString()); Supplier_Initial_expense_REQ_SEQ = NullOrEmpty(row["Supplier_Initial_expense_REQ_SEQ"].ToString()); Supplier_Initial_expense = NullOrEmpty(row["Supplier_Initial_expense"].ToString()); Supplier_Initial_expense_DISCOUNTED = NullOrEmpty(row["Supplier_Initial_expense_DISCOUNTED"].ToString()); Supplier_Initial_expense_TAX = NullOrEmpty(row["Supplier_Initial_expense_TAX"].ToString()); Supplier_Initial_expense_INCLUDING_TAX = NullOrEmpty(row["Supplier_Initial_expense_INCLUDING_TAX"].ToString()); Supplier_Monthly_usage_fee_REQ_SEQ = NullOrEmpty(row["Supplier_Monthly_usage_fee_REQ_SEQ"].ToString()); supplier_Monthly_usage_fee = NullOrEmpty(row["Supplier_Monthly_usage_fee"].ToString()); Supplier_Monthly_usage_fee_DISCOUNTED = NullOrEmpty(row["Supplier_Monthly_usage_fee_DISCOUNTED"].ToString()); Supplier_Monthly_usage_fee_TAX = NullOrEmpty(row["Supplier_Monthly_usage_fee_TAX"].ToString()); Supplier_Monthly_usage_fee_INCLUDING_TAX = NullOrEmpty(row["Supplier_Monthly_usage_fee_INCLUDING_TAX"].ToString()); Production_information_browsing_Initial_expense_REQ_SEQ = NullOrEmpty(row["Production_information_browsing_Initial_expense_REQ_SEQ"].ToString()); Production_information_browsing_Initial_expense = NullOrEmpty(row["Production_information_browsing_Initial_expense"].ToString()); Production_information_browsing_Initial_expense_DISCOUNTED = NullOrEmpty(row["Production_information_browsing_Initial_expense_DISCOUNTED"].ToString()); Production_information_browsing_Initial_expense_TAX = NullOrEmpty(row["Production_information_browsing_Initial_expense_TAX"].ToString()); Production_information_browsing_Initial_expense_INCLUDING_TAX = NullOrEmpty(row["Production_information_browsing_Initial_expense_INCLUDING_TAX"].ToString()); View_production_information_Annual_usage_fee_REQ_SEQ = NullOrEmpty(row["View_production_information_Annual_usage_fee_REQ_SEQ"].ToString()); Viewing_production_information_Annual_usage_fee = NullOrEmpty(row["Viewing_production_information_Annual_usage_fee"].ToString()); View_production_information_Annual_usage_fee_DISCOUNTED = NullOrEmpty(row["View_production_information_Annual_usage_fee_DISCOUNTED"].ToString()); View_production_information_Annual_usage_fee_TAX = NullOrEmpty(row["View_production_information_Annual_usage_fee_TAX"].ToString()); View_production_information_Annual_usage_fee_INCLUDING_TAX = NullOrEmpty(row["View_production_information_Annual_usage_fee_INCLUDING_TAX"].ToString()); decimal usageFee = Key_source_Monthly_usage_fee_REQ_SEQ + Key_source_Monthly_usage_fee + Key_source_Monthly_usage_fee_DISCOUNTED + Key_source_Monthly_usage_fee_TAX + Key_source_Monthly_usage_fee_INCLUDING_TAX; newRow["KEY_SOURCE_MONTHLY_USAGE_FEE"] = usageFee; decimal supplierInitialExpense = Supplier_Initial_expense_REQ_SEQ + Supplier_Initial_expense + Supplier_Initial_expense_DISCOUNTED + Supplier_Initial_expense_TAX + Supplier_Initial_expense_INCLUDING_TAX; newRow["SUPPLIER_INITIAL_EXPENSE"] = supplierInitialExpense; decimal supplierMonthlyUsageFee = Supplier_Monthly_usage_fee_REQ_SEQ + supplier_Monthly_usage_fee + Supplier_Monthly_usage_fee_DISCOUNTED + Supplier_Monthly_usage_fee_TAX + Supplier_Monthly_usage_fee_INCLUDING_TAX; newRow["SUPPLIER_MONTHLY_USAGE_FEE"] = supplierMonthlyUsageFee; decimal browsingInitialExpense = Production_information_browsing_Initial_expense_REQ_SEQ + Production_information_browsing_Initial_expense + Production_information_browsing_Initial_expense_DISCOUNTED + Production_information_browsing_Initial_expense_TAX + Production_information_browsing_Initial_expense_INCLUDING_TAX; newRow["BROWSING_INITIAL_EXPENSE"] = browsingInitialExpense; decimal yearlyUsageFee = View_production_information_Annual_usage_fee_REQ_SEQ + Viewing_production_information_Annual_usage_fee + View_production_information_Annual_usage_fee_DISCOUNTED + View_production_information_Annual_usage_fee_TAX + View_production_information_Annual_usage_fee_INCLUDING_TAX; newRow["YEARLY_USAGE_FEE"] = yearlyUsageFee; //newRow["INVOICE_METHOD"] = row["BILL_METHOD"]; string invoiceMethod = row["BILL_METHOD"].ToString(); if (invoiceMethod.Length == 5) { if (invoiceMethod.Substring(0, 1) == "1") { newRow["POSTAL_MAIL"] = "●"; } if (invoiceMethod.Substring(1, 1) == "1") { newRow["WEB"] = "●"; } if (invoiceMethod.Substring(2, 1) == "1") { newRow["Email"] = "●"; } if (invoiceMethod.Substring(3, 1) == "1") { newRow["CREDIT_CARD"] = "●"; } if (invoiceMethod.Substring(4, 1) == "1") { newRow["OTHER"] = "●"; } } newRow["Key_source_Monthly_usage_fee_REQ_SEQ"] = row["Key_source_Monthly_usage_fee_REQ_SEQ"]; newRow["Supplier_Initial_expense_REQ_SEQ"] = row["Supplier_Initial_expense_REQ_SEQ"]; newRow["Supplier_Monthly_usage_fee_REQ_SEQ"] = row["Supplier_Monthly_usage_fee_REQ_SEQ"]; newRow["Production_information_browsing_Initial_expense_REQ_SEQ"] = row["Production_information_browsing_Initial_expense_REQ_SEQ"]; newRow["View_production_information_Annual_usage_fee_REQ_SEQ"] = row["View_production_information_Annual_usage_fee_REQ_SEQ"]; dtResult.Rows.Add(newRow); #endregion } foreach (DataRow row in dtAll.Rows) { #region Declare Key_source_Monthly_usage_fee_REQ_SEQ = 0; Key_source_Monthly_usage_fee = 0; Key_source_Monthly_usage_fee_DISCOUNTED = 0; Key_source_Monthly_usage_fee_TAX = 0; Key_source_Monthly_usage_fee_INCLUDING_TAX = 0; Supplier_Initial_expense_REQ_SEQ = 0; Supplier_Initial_expense = 0; Supplier_Initial_expense_DISCOUNTED = 0; Supplier_Initial_expense_TAX = 0; Supplier_Initial_expense_INCLUDING_TAX = 0; Supplier_Monthly_usage_fee_REQ_SEQ = 0; supplier_Monthly_usage_fee = 0; Supplier_Monthly_usage_fee_DISCOUNTED = 0; Supplier_Monthly_usage_fee_TAX = 0; Supplier_Monthly_usage_fee_INCLUDING_TAX = 0; Production_information_browsing_Initial_expense_REQ_SEQ = 0; Production_information_browsing_Initial_expense = 0; Production_information_browsing_Initial_expense_DISCOUNTED = 0; Production_information_browsing_Initial_expense_TAX = 0; Production_information_browsing_Initial_expense_INCLUDING_TAX = 0; View_production_information_Annual_usage_fee_REQ_SEQ = 0; Viewing_production_information_Annual_usage_fee = 0; View_production_information_Annual_usage_fee_DISCOUNTED = 0; View_production_information_Annual_usage_fee_TAX = 0; View_production_information_Annual_usage_fee_INCLUDING_TAX = 0; #endregion #region SetValue to DataTable DataRow newRow = dtTotal.NewRow(); Key_source_Monthly_usage_fee_REQ_SEQ = NullOrEmpty(row["Key_source_Monthly_usage_fee_REQ_SEQ"].ToString()); Key_source_Monthly_usage_fee = NullOrEmpty(row["Key_source_Monthly_usage_fee"].ToString()); Key_source_Monthly_usage_fee_DISCOUNTED = NullOrEmpty(row["Key_source_Monthly_usage_fee_DISCOUNTED"].ToString()); Key_source_Monthly_usage_fee_TAX = NullOrEmpty(row["Key_source_Monthly_usage_fee_TAX"].ToString()); Key_source_Monthly_usage_fee_INCLUDING_TAX = NullOrEmpty(row["Key_source_Monthly_usage_fee_INCLUDING_TAX"].ToString()); Supplier_Initial_expense_REQ_SEQ = NullOrEmpty(row["Supplier_Initial_expense_REQ_SEQ"].ToString()); Supplier_Initial_expense = NullOrEmpty(row["Supplier_Initial_expense"].ToString()); Supplier_Initial_expense_DISCOUNTED = NullOrEmpty(row["Supplier_Initial_expense_DISCOUNTED"].ToString()); Supplier_Initial_expense_TAX = NullOrEmpty(row["Supplier_Initial_expense_TAX"].ToString()); Supplier_Initial_expense_INCLUDING_TAX = NullOrEmpty(row["Supplier_Initial_expense_INCLUDING_TAX"].ToString()); Supplier_Monthly_usage_fee_REQ_SEQ = NullOrEmpty(row["Supplier_Monthly_usage_fee_REQ_SEQ"].ToString()); supplier_Monthly_usage_fee = NullOrEmpty(row["Supplier_Monthly_usage_fee"].ToString()); Supplier_Monthly_usage_fee_DISCOUNTED = NullOrEmpty(row["Supplier_Monthly_usage_fee_DISCOUNTED"].ToString()); Supplier_Monthly_usage_fee_TAX = NullOrEmpty(row["Supplier_Monthly_usage_fee_TAX"].ToString()); Supplier_Monthly_usage_fee_INCLUDING_TAX = NullOrEmpty(row["Supplier_Monthly_usage_fee_INCLUDING_TAX"].ToString()); Production_information_browsing_Initial_expense_REQ_SEQ = NullOrEmpty(row["Production_information_browsing_Initial_expense_REQ_SEQ"].ToString()); Production_information_browsing_Initial_expense = NullOrEmpty(row["Production_information_browsing_Initial_expense"].ToString()); Production_information_browsing_Initial_expense_DISCOUNTED = NullOrEmpty(row["Production_information_browsing_Initial_expense_DISCOUNTED"].ToString()); Production_information_browsing_Initial_expense_TAX = NullOrEmpty(row["Production_information_browsing_Initial_expense_TAX"].ToString()); Production_information_browsing_Initial_expense_INCLUDING_TAX = NullOrEmpty(row["Production_information_browsing_Initial_expense_INCLUDING_TAX"].ToString()); View_production_information_Annual_usage_fee_REQ_SEQ = NullOrEmpty(row["View_production_information_Annual_usage_fee_REQ_SEQ"].ToString()); Viewing_production_information_Annual_usage_fee = NullOrEmpty(row["Viewing_production_information_Annual_usage_fee"].ToString()); View_production_information_Annual_usage_fee_DISCOUNTED = NullOrEmpty(row["View_production_information_Annual_usage_fee_DISCOUNTED"].ToString()); View_production_information_Annual_usage_fee_TAX = NullOrEmpty(row["View_production_information_Annual_usage_fee_TAX"].ToString()); View_production_information_Annual_usage_fee_INCLUDING_TAX = NullOrEmpty(row["View_production_information_Annual_usage_fee_INCLUDING_TAX"].ToString()); decimal usageFee = Key_source_Monthly_usage_fee_REQ_SEQ + Key_source_Monthly_usage_fee + Key_source_Monthly_usage_fee_DISCOUNTED + Key_source_Monthly_usage_fee_TAX + Key_source_Monthly_usage_fee_INCLUDING_TAX; newRow["KEY_SOURCE_MONTHLY_USAGE_FEE"] = usageFee; decimal supplierInitialExpense = Supplier_Initial_expense_REQ_SEQ + Supplier_Initial_expense + Supplier_Initial_expense_DISCOUNTED + Supplier_Initial_expense_TAX + Supplier_Initial_expense_INCLUDING_TAX; newRow["SUPPLIER_INITIAL_EXPENSE"] = supplierInitialExpense; decimal supplierMonthlyUsageFee = Supplier_Monthly_usage_fee_REQ_SEQ + supplier_Monthly_usage_fee + Supplier_Monthly_usage_fee_DISCOUNTED + Supplier_Monthly_usage_fee_TAX + Supplier_Monthly_usage_fee_INCLUDING_TAX; newRow["SUPPLIER_MONTHLY_USAGE_FEE"] = supplierMonthlyUsageFee; decimal browsingInitialExpense = Production_information_browsing_Initial_expense_REQ_SEQ + Production_information_browsing_Initial_expense + Production_information_browsing_Initial_expense_DISCOUNTED + Production_information_browsing_Initial_expense_TAX + Production_information_browsing_Initial_expense_INCLUDING_TAX; newRow["BROWSING_INITIAL_EXPENSE"] = browsingInitialExpense; decimal yearlyUsageFee = View_production_information_Annual_usage_fee_REQ_SEQ + Viewing_production_information_Annual_usage_fee + View_production_information_Annual_usage_fee_DISCOUNTED + View_production_information_Annual_usage_fee_TAX + View_production_information_Annual_usage_fee_INCLUDING_TAX; newRow["YEARLY_USAGE_FEE"] = yearlyUsageFee; //newRow["INVOICE_METHOD"] = row["BILL_METHOD"]; string invoiceMethod = row["BILL_METHOD"].ToString(); if (invoiceMethod.Length == 5) { if (invoiceMethod.Substring(0, 1) == "1") { newRow["POSTAL_MAIL"] = "●"; } if (invoiceMethod.Substring(1, 1) == "1") { newRow["WEB"] = "●"; } if (invoiceMethod.Substring(2, 1) == "1") { newRow["Email"] = "●"; } if (invoiceMethod.Substring(3, 1) == "1") { newRow["CREDIT_CARD"] = "●"; } if (invoiceMethod.Substring(4, 1) == "1") { newRow["OTHER"] = "●"; } } dtTotal.Rows.Add(newRow); #endregion } DataSet ds = new DataSet(); ds.Tables.Add(dtResult); ds.Tables.Add(dtTotal); response.Data = Utility.Utility_Component.DsToJSon(ds, "UsageApplicatioList"); if (dtResult.Rows.Count > 0) { response.Status = 1; } else { if (strMessage == "") { response.Status = 1; response.Message = "There is no data to display."; } else { response.Status = 0; response.Message = strMessage; } } response.Meta.Offset = OFFSET; response.Meta.Limit = LIMIT; response.Meta.Total = TOTAL; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse SendMail(string ClientCertificateList) { try { string strMsg = ""; bool mailSuccess = false; ArrayList company_no_boxs = new ArrayList(); DataTable dgvList = Utility.Utility_Component.JsonToDt(ClientCertificateList); List <string> l_SentMail = new List <string>(); for (int i = 0; i < dgvList.Rows.Count; i++) { DataRow dr = dgvList.Rows[i]; string l_COMPANY_NO_BOX = dr["COMPANY_NO_BOX"].ToString(); var certificate_list = dgvList.AsEnumerable().Where(row => row.Field <string>("COMPANY_NO_BOX") == l_COMPANY_NO_BOX).Select(s => s.Field <string>("CLIENT_CERTIFICATE_NO")).ToArray(); BOL_CLIENT_CERTIFICATE oCLIENT_CERTIFICATE = new BOL_CLIENT_CERTIFICATE(); oCLIENT_CERTIFICATE = Cast_CLIENT_CERTIFICATE(dr); //check method BOL_REQUEST_DETAIL oREQUEST_DETAIL = new BOL_REQUEST_DETAIL(); oREQUEST_DETAIL = Cast_REQUEST_DETAIL(dr); CLIENT_CERTIFICATE DAL_CLIENT_CERTIFICATE = new CLIENT_CERTIFICATE(con); if (l_SentMail.Where(x => x == l_COMPANY_NO_BOX).ToList().Count <= 0) { l_SentMail.Add(l_COMPANY_NO_BOX); mailSuccess = PrepareAndSendMail(certificate_list, oREQUEST_DETAIL.COMPANY_NAME, oREQUEST_DETAIL.CLIENT_CERTIFICATE_SEND_EMAIL_ADDRESS, oCLIENT_CERTIFICATE.EXPIRATION_DATE, oCLIENT_CERTIFICATE.PASSWORD, oCLIENT_CERTIFICATE.FY); if (mailSuccess) { //update email sent date DAL_CLIENT_CERTIFICATE.EmailButtonUpdate(oCLIENT_CERTIFICATE, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER, out strMsg); if (String.IsNullOrEmpty(strMsg)) { //success dr["DISTRIBUTION_DATE"] = UPDATED_AT_DATETIME; ResponseUtility.ReturnMailSuccessMessage(dr, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else { //already use in another process ResponseUtility.ReturnFailMessage(dr); } } else { //fail message ResponseUtility.MailSendingFail(dr); } } else { //update email sent date DAL_CLIENT_CERTIFICATE.EmailButtonUpdate(oCLIENT_CERTIFICATE, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER, out strMsg); if (String.IsNullOrEmpty(strMsg)) { //success dr["DISTRIBUTION_DATE"] = UPDATED_AT_DATETIME; ResponseUtility.ReturnMailSuccessMessage(dr, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else { //already use in another process ResponseUtility.ReturnFailMessage(dr); } } } response.Data = Utility.Utility_Component.DtToJSon(dgvList, "Mail status");; timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }