private void HandleModify(BOL_REQUEST_ID oREQUEST_ID, DataRow row) { string strMsg = ""; 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 { //update the record oREQUEST_ID.GD = string.IsNullOrEmpty(oREQUEST_ID.GD_CODE) ? 0 : 2; oREQUEST_ID.PASSWORD_EXPIRATION_DATE = oREQUEST_ID.DISABLED_FLG == "*" ? null : oREQUEST_ID.PASSWORD_EXPIRATION_DATE; oREQUEST_ID.PASSWORD_SET_DATE = oREQUEST_ID.DISABLED_FLG == "*" ? null : oREQUEST_ID.PASSWORD_SET_DATE; DAL_REQUEST_ID.Update(oREQUEST_ID, CURRENT_DATETIME, CURRENT_USER, out strMsg); } else { ResponseUtility.ReturnFailMessage(row); return; } //return message and MK value if (String.IsNullOrEmpty(strMsg)) //success { ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else //failed { ResponseUtility.MailSendingFail(row); } }
private void HandleInsert(BOL_USAGE_CHARGE_MASTER oUSAGE_CHARGE_MASTER, string OPERATION, DataRow row) { string strMsg = ""; USAGE_CHARGE_MASTER DAL_USAGE_CHARGE_MASTER = new USAGE_CHARGE_MASTER(con); using (TransactionScope dbTxn = new TransactionScope()) { if (!DAL_USAGE_CHARGE_MASTER.PKKeyCheck(oUSAGE_CHARGE_MASTER, out strMsg)) // IF updated_at is not already modified { //delete the record DAL_USAGE_CHARGE_MASTER.Insert(oUSAGE_CHARGE_MASTER, CURRENT_DATETIME, CURRENT_USER, out strMsg); } else { ResponseUtility.ReturnFailMessage(row, String.Format(Utility.Messages.Jimugo.E000ZZ028, "契約コードと採用日の組み合わせ")); return; } //return message and MK value if (String.IsNullOrEmpty(strMsg)) //success { dbTxn.Complete(); ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else //failed { ResponseUtility.ReturnFailMessage(row); } } }
private void HandleModify(USAGE_INFO_REGISTRATION oUSAGE_INFO_REG, DataRow row) { string strMsg = ""; //Get EDI_ACCOUNT object BOL_EDI_ACCOUNT oEDI_ACCOUNT = GetEDI_ACCOUNT(oUSAGE_INFO_REG); EDI_ACCOUNT DAL_EDI_ACCOUNT = new EDI_ACCOUNT(con); if (!DAL_EDI_ACCOUNT.IsAlreadyUpdated(oEDI_ACCOUNT, out strMsg)) // If updated_at is not already modified { //insert the record DAL_EDI_ACCOUNT.Update(oEDI_ACCOUNT, CURRENT_DATETIME, CURRENT_USER, out strMsg); } else { //already use in another process ResponseUtility.ReturnFailMessage(row); return; } //return message and MK value if (String.IsNullOrEmpty(strMsg)) //success { ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else //failed { ResponseUtility.ReturnFailMessage(row); } }
private void HandleModify(BOL_CLIENT_CERTIFICATE oCLIENT_CERTIFICATE, string OPERATION, DataRow row) { string strMsg = ""; using (TransactionScope dbTxn = new TransactionScope()) { CLIENT_CERTIFICATE DAL_CLIENT_CERTIFICATE = new CLIENT_CERTIFICATE(con); //check condition if (!DAL_CLIENT_CERTIFICATE.IsAlreadyUpdated(oCLIENT_CERTIFICATE, out strMsg)) // IF updated_at is not already modified { //MODIFY the record DAL_CLIENT_CERTIFICATE.Update(oCLIENT_CERTIFICATE, CURRENT_DATETIME, CURRENT_USER, out strMsg); } else { //already use in another process ResponseUtility.ReturnFailMessage(row); return; } //return message and MK value if (String.IsNullOrEmpty(strMsg)) //success { dbTxn.Complete(); ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else //failed { ResponseUtility.ReturnFailMessage(row); } } }
private void HandleDelete(USAGE_INFO_REGISTRATION oUSAGE_INFO_REG, DataRow row) { string strMsg = ""; using (TransactionScope dbTxn = new TransactionScope()) { //GET EDI ACCOUNT OBJECT BOL_EDI_ACCOUNT oEDI_ACCOUNT = GetEDI_ACCOUNT(oUSAGE_INFO_REG); EDI_ACCOUNT DAL_EDI_ACCOUNT = new EDI_ACCOUNT(con); if (!DAL_EDI_ACCOUNT.IsAlreadyUpdated(oEDI_ACCOUNT, out strMsg)) // IF updated_at is not already modified { //delete the record DAL_EDI_ACCOUNT.Delete(oEDI_ACCOUNT, out strMsg); } else { dbTxn.Dispose(); ResponseUtility.ReturnFailMessage(row); return; } //return message and MK value if (String.IsNullOrEmpty(strMsg)) //success { dbTxn.Complete(); ResponseUtility.ReturnDeleteSuccessMessage(row); } else //failed { ResponseUtility.ReturnFailMessage(row); } } }
private void HandleDelete(BOL_USAGE_CHARGE_MASTER oUSAGE_CHARGE_MASTER, DataRow row) { string strMsg = ""; using (TransactionScope dbTxn = new TransactionScope()) { USAGE_CHARGE_MASTER DAL_USAGE_CHARGE_MASTER = new USAGE_CHARGE_MASTER(con); if (!DAL_USAGE_CHARGE_MASTER.IsAlreadyUpdated(oUSAGE_CHARGE_MASTER, out strMsg)) // IF updated_at is not already modified { //delete the record DAL_USAGE_CHARGE_MASTER.Delete(oUSAGE_CHARGE_MASTER, out strMsg); } else { dbTxn.Dispose(); ResponseUtility.ReturnFailMessage(row); return; } //return message and MK value if (String.IsNullOrEmpty(strMsg)) //success { dbTxn.Complete(); ResponseUtility.ReturnDeleteSuccessMessage(row); } else //failed { ResponseUtility.ReturnFailMessage(row); } } }
private void HandleDelete(BOL_CLIENT_CERTIFICATE oCLIENT_CERTIFICATE, DataRow row) { string strMsg = ""; using (TransactionScope dbTxn = new TransactionScope()) { CLIENT_CERTIFICATE DAL_CLIENT_CERTIFICATE = new CLIENT_CERTIFICATE(con); if (!DAL_CLIENT_CERTIFICATE.IsAlreadyUpdated(oCLIENT_CERTIFICATE, out strMsg)) // IF updated_at is not already modified { //delete the record DAL_CLIENT_CERTIFICATE.Delete(oCLIENT_CERTIFICATE, out strMsg); } else { //already use in another process ResponseUtility.ReturnFailMessage(row); return; } //return message and MK value if (String.IsNullOrEmpty(strMsg)) //success { response.Status = 1; dbTxn.Complete(); ResponseUtility.ReturnDeleteSuccessMessage(row); } else //failed { ResponseUtility.ReturnFailMessage(row); } } }
private void HandleInsert(BOL_CLIENT_CERTIFICATE oCLIENT_CERTIFICATE, string OPERATION, DataRow row) { string strMsg = ""; CLIENT_CERTIFICATE DAL_CLIENT_CERTIFICATE = new CLIENT_CERTIFICATE(con); using (TransactionScope dbTxn = new TransactionScope()) { if (!DAL_CLIENT_CERTIFICATE.PKKeyCheck(oCLIENT_CERTIFICATE, out strMsg)) // IF updated_at is not already modified { //delete the record DAL_CLIENT_CERTIFICATE.Insert(oCLIENT_CERTIFICATE, CURRENT_DATETIME, CURRENT_USER, out strMsg); } else { ResponseUtility.ReturnFailMessage(row, String.Format(Utility.Messages.Jimugo.E000ZZ028, oCLIENT_CERTIFICATE.CLIENT_CERTIFICATE_NO)); return; } //return message and MK value if (String.IsNullOrEmpty(strMsg)) //success { dbTxn.Complete(); ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else //failed { ResponseUtility.ReturnFailMessage(row); } } }
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 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)); } }
private void HandleModify(BOL_REQUEST_DETAIL oREQUEST_DETAIL, BOL_REQUEST_ID oREQUEST_ID, DataRow row) { string msg = ""; using (TransactionScope dbTxn = new TransactionScope()) { #region UPDATE REQUEST_DETSIL REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); if (!DAL_REQUEST_DETAIL.IsAlreadyUpdated(oREQUEST_DETAIL, out msg)) // If updated_at is not already modified { //insert the record DAL_REQUEST_DETAIL.UpdateUsageApplication(oREQUEST_DETAIL, CURRENT_DATETIME, CURRENT_USER, out msg); if (!string.IsNullOrEmpty(msg)) { dbTxn.Dispose(); ResponseUtility.ReturnFailMessage(row); return; } } else { dbTxn.Dispose(); ResponseUtility.ReturnFailMessage(row); return; } #endregion #region UPDATE REQUEST_ID REQUEST_ID DAL_REQUEST_ID = new REQUEST_ID(con); if (!DAL_REQUEST_ID.IsAlreadyUpdated(oREQUEST_ID, out msg)) // If updated_at is not already modified { //insert the record DAL_REQUEST_ID.UpdateUsageApplication(oREQUEST_ID, CURRENT_DATETIME, CURRENT_USER, out msg); } else { dbTxn.Dispose(); ResponseUtility.ReturnFailMessage(row); return; } //return message and MK value if (String.IsNullOrEmpty(msg)) //success { dbTxn.Complete(); ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else //failed { dbTxn.Dispose(); ResponseUtility.ReturnFailMessage(row); } #endregion } }
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)); } }
private void HandleDelete(BOL_REQUEST_ID oREQUEST_ID, DataRow row) { string strMsg = ""; using (TransactionScope dbTxn = new TransactionScope()) { //check if it is already registered in REQUEST_DETAIL REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); 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 { if (!DAL_REQUEST_DETAIL.IsAlreadyUsed(oREQUEST_ID.COMPANY_NO_BOX, out strMsg)) { //delete the record DAL_REQUEST_ID.Delete(oREQUEST_ID, out strMsg); } else //Already used { dbTxn.Dispose(); ResponseUtility.ReturnFailMessage(row, string.Format(Utility.Messages.Jimugo.E000ZZ033, oREQUEST_ID.COMPANY_NO_BOX)); return; } } else { dbTxn.Dispose(); ResponseUtility.ReturnFailMessage(row); return; } //return message and MK value if (String.IsNullOrEmpty(strMsg)) //success { dbTxn.Complete(); ResponseUtility.ReturnDeleteSuccessMessage(row); } else //failed { ResponseUtility.ReturnFailMessage(row); } } }
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)); } }
private void HandleInsert(BOL_REQUEST_ID oREQUEST_ID, string OPERATION, DataRow row) { string strMsg = ""; using (TransactionScope dbTxn = new TransactionScope()) { REQUEST_ID DAL_REQUEST_ID = new REQUEST_ID(con); if (OPERATION == "I") { #region Auto Index //GET records of AUTO_INDEX TABLE AUTO_INDEX DAL_AUTO_INDEX = new AUTO_INDEX(con); DataTable result = DAL_AUTO_INDEX.GetByAutoIndexID(oREQUEST_ID.AUTO_INDEX_ID, out strMsg); //parepare AUTO_INDEX object BOL_AUTO_INDEX oAUTO_INDEX = new BOL_AUTO_INDEX(); oAUTO_INDEX = Cast_AUTO_INDEX(result.Rows[0]); oAUTO_INDEX.AUTO_INDEX++; #endregion #region Insert Record if (!DAL_AUTO_INDEX.IsAlreadyUpdated(oAUTO_INDEX, out strMsg)) // If AUTO INDEX is not already modified { //UPDATE AUTO INDEX DAL_AUTO_INDEX.Update(oAUTO_INDEX, CURRENT_DATETIME, CURRENT_USER, out strMsg); //generate COMPANY NO BOX string COMPANY_NO = "AJ-" + oAUTO_INDEX.AUTO_INDEX.ToString().PadLeft(4, '0'); int COMPANY_BOX = 1; string COMPANY_NO_BOX = COMPANY_NO + "-" + COMPANY_BOX.ToString().PadLeft(2, '0'); //assign COMPANY NO BOX oREQUEST_ID.COMPANY_NO_BOX = COMPANY_NO_BOX; oREQUEST_ID.COMPANY_NO = COMPANY_NO; oREQUEST_ID.COMPANY_BOX = COMPANY_BOX; //Update in datatable row["COMPANY_NO_BOX"] = COMPANY_NO_BOX; row["COMPANY_NO"] = COMPANY_NO; row["COMPANY_BOX"] = COMPANY_BOX; //generate hashed password oREQUEST_ID.PASSWORD_HASHED = Crypto.HashPassword(oREQUEST_ID.PASSWORD); //insert the record oREQUEST_ID.GD = string.IsNullOrEmpty(oREQUEST_ID.GD_CODE) ? 0 : 2; oREQUEST_ID.SOCIOS_USER_FLG = oREQUEST_ID.AUTO_INDEX_ID == "CNSOCIOS" ? "*" : " "; DAL_REQUEST_ID.Insert(oREQUEST_ID, CURRENT_DATETIME, CURRENT_USER, out strMsg); if (String.IsNullOrEmpty(strMsg)) //success { dbTxn.Complete(); ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else //failed { ResponseUtility.ReturnFailMessage(row, String.Format(Utility.Messages.Jimugo.E000ZZ028, COMPANY_NO_BOX)); } } else { ResponseUtility.ReturnFailMessage(row); return; } #endregion } else { #region Copy Record //get max company number from REQUEST_ID oREQUEST_ID.COMPANY_BOX = DAL_REQUEST_ID.GetMaxCompanyBox(oREQUEST_ID.COMPANY_NO, out strMsg); string COMPANY_NO = oREQUEST_ID.COMPANY_NO; int COMPANY_BOX = oREQUEST_ID.COMPANY_BOX; string COMPANY_NO_BOX = COMPANY_NO + "-" + COMPANY_BOX.ToString().PadLeft(2, '0'); //Update in datatable oREQUEST_ID.COMPANY_NO_BOX = COMPANY_NO_BOX; row["COMPANY_NO_BOX"] = COMPANY_NO_BOX; row["COMPANY_NO"] = COMPANY_NO; row["COMPANY_BOX"] = COMPANY_BOX; //generate hashed password oREQUEST_ID.PASSWORD_HASHED = Crypto.HashPassword(oREQUEST_ID.PASSWORD); //insert the record oREQUEST_ID.GD = string.IsNullOrEmpty(oREQUEST_ID.GD_CODE) ? 0 : 2; oREQUEST_ID.SOCIOS_USER_FLG = oREQUEST_ID.AUTO_INDEX_ID == "CNSOCIOS" ? "*" : " "; DAL_REQUEST_ID.Insert(oREQUEST_ID, CURRENT_DATETIME, CURRENT_USER, out strMsg); if (String.IsNullOrEmpty(strMsg)) //success { dbTxn.Complete(); ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else //failed { ResponseUtility.ReturnFailMessage(row, String.Format(Utility.Messages.Jimugo.E000ZZ028, COMPANY_NO_BOX)); } #endregion } } }
private void HandleInsert(USAGE_INFO_REGISTRATION oUSAGE_INFO_REG, string OPERATION, DataRow row) { string strMsg = ""; //Search in EDI_CANDICATE BOL_EDI_CANDIDATE oEDI_CANDIDATE = new BOL_EDI_CANDIDATE(); EDI_CANDIDATE DAL_EDI_CANDICATE = new EDI_CANDIDATE(con); DataTable dtUseFLG = DAL_EDI_CANDICATE.GetUseFLG(oUSAGE_INFO_REG.EDI_ACCOUNT, out strMsg); using (TransactionScope dbTxn = new TransactionScope()) { //Prepare EDI CANDIDATE oEDI_CANDIDATE = GetEDI_CANDIDATE(oUSAGE_INFO_REG); if (dtUseFLG.Rows.Count == 0) { //Insert AS USED DAL_EDI_CANDICATE.Insert(oEDI_CANDIDATE, CURRENT_DATETIME, CURRENT_USER, out strMsg); } else { if (dtUseFLG.Rows[0]["USED_FLG"].ToString() == "*") //if record is already used { ResponseUtility.ReturnFailMessage(row, Utility.Messages.Jimugo.E000WB013); return; } else { //set used flage oEDI_CANDIDATE.USED_FLG = "*"; //Update as USED DAL_EDI_CANDICATE.Update(oEDI_CANDIDATE, CURRENT_DATETIME, CURRENT_USER, out strMsg); } } EDI_ACCOUNT DAL_EDI_ACCOUNT = new EDI_ACCOUNT(con); BOL_EDI_ACCOUNT oEDI_ACCOUNT = GetEDI_ACCOUNT(oUSAGE_INFO_REG); if (DAL_EDI_ACCOUNT.IsCompanyNoBoxAlreadyRegistered(oEDI_ACCOUNT.COMPANY_NO_BOX, out strMsg)) { ResponseUtility.ReturnFailMessage(row, String.Format(Utility.Messages.Jimugo.E000ZZ038, "会社番号+BOX")); return; } if (DAL_EDI_ACCOUNT.IsEDIAccountAlreadyRegistered(oEDI_ACCOUNT.EDI_ACCOUNT, out strMsg)) { ResponseUtility.ReturnFailMessage(row, String.Format(Utility.Messages.Jimugo.E000ZZ038, "EDIアカウント")); return; } DAL_EDI_ACCOUNT.Insert(oEDI_ACCOUNT, CURRENT_DATETIME, CURRENT_USER, out strMsg); #region ASSIGN_MK_VALUE_AND_MESSAGES if (String.IsNullOrEmpty(strMsg)) //success { dbTxn.Complete(); ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else //failed { ResponseUtility.ReturnFailMessage(row); } } #endregion }
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)); } }