public bool IsAlreadyUpdatedConfirmationRequest(BOL_REQUEST_ID oREQUEST_ID, out string strMsg) { ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strSearchWithKeyForConfirmationRequest); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", oREQUEST_ID.COMPANY_NO_BOX)); oMaster.ExcuteQuery(4, out strMsg); int count; try { count = int.Parse(oMaster.dtExcuted.Rows[0][0].ToString()); } catch (Exception) { count = 0; } if (count <= 0) { return(true); } else { return(false); } }
public void Insert(BOL_REQUEST_ID oREQUEST_ID, string CURRENT_DATETIME, string CURRENT_USER, out String strMsg) { ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strInsert); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", oREQUEST_ID.COMPANY_NO_BOX)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@AUTO_INDEX_ID", oREQUEST_ID.AUTO_INDEX_ID)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NAME", oREQUEST_ID.COMPANY_NAME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PASSWORD", oREQUEST_ID.PASSWORD != null ? oREQUEST_ID.PASSWORD : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PASSWORD_HASHED", oREQUEST_ID.PASSWORD_HASHED != null ? oREQUEST_ID.PASSWORD_HASHED : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PASSWORD_SET_DATE", oREQUEST_ID.PASSWORD_SET_DATE != null ? Convert.ToDateTime(oREQUEST_ID.PASSWORD_SET_DATE): (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PASSWORD_EXPIRATION_DATE", oREQUEST_ID.PASSWORD_EXPIRATION_DATE != null ? Convert.ToDateTime(oREQUEST_ID.PASSWORD_EXPIRATION_DATE) : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@EMAIL_ADDRESS", oREQUEST_ID.EMAIL_ADDRESS != null ? oREQUEST_ID.EMAIL_ADDRESS : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@EMAIL_SEND_DATE", oREQUEST_ID.EMAIL_SEND_DATE != null ? Convert.ToDateTime(oREQUEST_ID.EMAIL_SEND_DATE) : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@LOGIN_FAIL_COUNT", oREQUEST_ID.LOGIN_FAIL_COUNT)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@SESSION_ID", oREQUEST_ID.SESSION_ID != null ? oREQUEST_ID.SESSION_ID : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@LAST_ACCESS_DATE", oREQUEST_ID.LAST_ACCESS_DATE != null ? oREQUEST_ID.LAST_ACCESS_DATE : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@LAST_FAIL_DATE", oREQUEST_ID.LAST_FAIL_DATE != null ? oREQUEST_ID.LAST_FAIL_DATE : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@GD", oREQUEST_ID.GD)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@GD_CODE", oREQUEST_ID.GD_CODE != null ? oREQUEST_ID.GD_CODE : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@DISABLED_FLG", oREQUEST_ID.DISABLED_FLG)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@MEMO", oREQUEST_ID.MEMO != null ? oREQUEST_ID.MEMO : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@SOCIOS_USER_FLG", oREQUEST_ID.SOCIOS_USER_FLG)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO", oREQUEST_ID.COMPANY_NO)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_BOX", oREQUEST_ID.COMPANY_BOX)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_DATETIME", CURRENT_DATETIME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_USER", CURRENT_USER)); oMaster.ExcuteQuery(6, out strMsg); }
public void Update(BOL_REQUEST_ID oREQUEST_ID, string CURRENT_DATETIME, string CURRENT_USER, out String strMsg) { //handle Null value at where conditions strUpdate = Utility.StringUtil.handleNullStringDate(strUpdate, "@UPDATED_AT", oREQUEST_ID.UPDATED_AT_RAW); //updated at ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strUpdate); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", oREQUEST_ID.COMPANY_NO_BOX)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NAME", oREQUEST_ID.COMPANY_NAME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PASSWORD", oREQUEST_ID.PASSWORD != null ? oREQUEST_ID.PASSWORD : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PASSWORD_SET_DATE", oREQUEST_ID.PASSWORD_SET_DATE != null ? Convert.ToDateTime(oREQUEST_ID.PASSWORD_SET_DATE) : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PASSWORD_EXPIRATION_DATE", oREQUEST_ID.PASSWORD_EXPIRATION_DATE != null ? Convert.ToDateTime(oREQUEST_ID.PASSWORD_EXPIRATION_DATE) : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@EMAIL_ADDRESS", oREQUEST_ID.EMAIL_ADDRESS != null ? oREQUEST_ID.EMAIL_ADDRESS : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@LOGIN_FAIL_COUNT", oREQUEST_ID.LOGIN_FAIL_COUNT)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@GD", oREQUEST_ID.GD)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@GD_CODE", oREQUEST_ID.GD_CODE != null ? oREQUEST_ID.GD_CODE : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@DISABLED_FLG", oREQUEST_ID.DISABLED_FLG)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@MEMO", oREQUEST_ID.MEMO != null ? oREQUEST_ID.MEMO : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATED_AT", oREQUEST_ID.UPDATED_AT_RAW != null ? oREQUEST_ID.UPDATED_AT_RAW : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_DATETIME", CURRENT_DATETIME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_USER", CURRENT_USER)); oMaster.ExcuteQuery(2, out strMsg); }
public bool IsAlreadyUpdated(BOL_REQUEST_ID oREQUEST_ID, out string strMsg) { //handle Null value at where conditions strSearchWithKeyAndUpdated_at = Utility.StringUtil.handleNullStringDate(strSearchWithKeyAndUpdated_at, "@UPDATED_AT", oREQUEST_ID.UPDATED_AT_RAW); ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strSearchWithKeyAndUpdated_at); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", oREQUEST_ID.COMPANY_NO_BOX)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATED_AT", oREQUEST_ID.UPDATED_AT_RAW != null ? oREQUEST_ID.UPDATED_AT_RAW : (object)DBNull.Value)); oMaster.ExcuteQuery(4, out strMsg); int count; try { count = int.Parse(oMaster.dtExcuted.Rows[0][0].ToString()); } catch (Exception) { count = 0; } if (count <= 0) { return(true); } else { return(false); } }
public void Delete(BOL_REQUEST_ID oREQUEST_ID, out String strMsg) { ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strDelete); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", oREQUEST_ID.COMPANY_NO_BOX)); oMaster.ExcuteQuery(3, out strMsg); }
private BOL_REQUEST_ID Cast_REQUEST_ID(DataRow row) { BOL_REQUEST_ID oREQUEST_ID = new BOL_REQUEST_ID(); oREQUEST_ID.COMPANY_NO_BOX = row["COMPANY_NO_BOX"].ToString(); string gd = row["GD"].ToString(); switch (gd) { case "未確認": oREQUEST_ID.GD = 0; break; case "確認依頼中": oREQUEST_ID.GD = 1; break; case "確認済み": oREQUEST_ID.GD = 2; break; case "無し": oREQUEST_ID.GD = 9; break; } oREQUEST_ID.DISABLED_FLG = row["DISABLED_FLG"].ToString(); oREQUEST_ID.UPDATED_AT = row["REQUEST_ID_UPDATED_AT"].ToString(); oREQUEST_ID.UPDATED_AT_RAW = row["REQUEST_ID_UPDATED_AT"].ToString(); return(oREQUEST_ID); }
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); } }
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 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)); } }
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 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 void GDConfirmationRequestUpdate(BOL_REQUEST_ID oREQUEST_ID, string CURRENT_DATETIME, string CURRENT_USER, out String strMsg) { ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strUpdateForConfirmationRequest); oMaster.crudCommand.Parameters.Add(new SqlParameter("@GD", oREQUEST_ID.GD)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_DATETIME", CURRENT_DATETIME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_USER", CURRENT_USER)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", oREQUEST_ID.COMPANY_NO_BOX)); oMaster.ExcuteQuery(2, out strMsg); }
public void UpdateMailDate(BOL_REQUEST_ID oREQUEST_ID, string CURRENT_DATETIME, string CURRENT_USER, out String strMsg) { //handle Null value at where conditions strUpdateMailDate = Utility.StringUtil.handleNullStringDate(strUpdateMailDate, "@UPDATED_AT", oREQUEST_ID.UPDATED_AT); ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strUpdateMailDate); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", oREQUEST_ID.COMPANY_NO_BOX)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@EMAIL_SEND_DATE", oREQUEST_ID.EMAIL_SEND_DATE != null ? Convert.ToDateTime(oREQUEST_ID.EMAIL_SEND_DATE).ToString("yyyy-MM-dd HH:mm:ss") : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATED_AT", oREQUEST_ID.UPDATED_AT_RAW != null ? oREQUEST_ID.UPDATED_AT_RAW : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_DATETIME", CURRENT_DATETIME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_USER", CURRENT_USER)); oMaster.ExcuteQuery(2, out strMsg); }
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 void UpdateUsageApplication(BOL_REQUEST_ID oREQUEST_ID, string CURRENT_DATETIME, string CURRENT_USER, out String strMsg) { ////handle Null value at where conditions //strUpdateForUsageApplication = Utility.StringUtil.handleNullStringDate(strUpdateForUsageApplication, "@UPDATED_AT", oREQUEST_ID.UPDATED_AT_RAW); ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strUpdateForUsageApplication); oMaster.crudCommand.Parameters.Add(new SqlParameter("@GD", oREQUEST_ID.GD)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", oREQUEST_ID.COMPANY_NO_BOX)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_DATETIME", CURRENT_DATETIME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_USER", CURRENT_USER)); //oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATED_AT", oREQUEST_ID.UPDATED_AT_RAW != null ? oREQUEST_ID.UPDATED_AT_RAW : (object)DBNull.Value)); oMaster.ExcuteQuery(2, out strMsg); }
private BOL_REQUEST_ID Cast_REQUEST_ID(DataRow row) { BOL_REQUEST_ID oREQUEST_ID = new BOL_REQUEST_ID(); oREQUEST_ID.COMPANY_NO_BOX = row["COMPANY_NO_BOX"].ToString(); oREQUEST_ID.COMPANY_NAME = row["COMPANY_NAME"].ToString(); oREQUEST_ID.PASSWORD = row["PASSWORD"].ToString(); oREQUEST_ID.PASSWORD_SET_DATE = Utility_Component.dtColumnToDateTime(row["PASSWORD_SET_DATE"].ToString()); oREQUEST_ID.PASSWORD_EXPIRATION_DATE = Utility_Component.dtColumnToDateTime(row["PASSWORD_EXPIRATION_DATE"].ToString()); oREQUEST_ID.EMAIL_ADDRESS = row["EMAIL_ADDRESS"].ToString(); oREQUEST_ID.EMAIL_SEND_DATE = Utility_Component.dtColumnToDateTime(row["EMAIL_SEND_DATE"].ToString()); oREQUEST_ID.LOGIN_FAIL_COUNT = Utility_Component.dtColumnToInt(row["LOGIN_FAIL_COUNT"].ToString()); oREQUEST_ID.SESSION_ID = row["SESSION_ID"].ToString(); oREQUEST_ID.LAST_ACCESS_DATE = Utility_Component.dtColumnToDateTime(row["LAST_ACCESS_DATE"].ToString()); oREQUEST_ID.LAST_FAIL_DATE = Utility_Component.dtColumnToDateTime(row["LAST_FAIL_DATE"].ToString()); oREQUEST_ID.GD_CODE = row["GD_CODE"].ToString(); oREQUEST_ID.DISABLED_FLG = row["DISABLED_FLG"].ToString(); oREQUEST_ID.MEMO = row["MEMO"].ToString(); oREQUEST_ID.UPDATED_AT = row["UPDATED_AT"].ToString() == "" ? null : row["UPDATED_AT"].ToString(); oREQUEST_ID.UPDATED_AT_RAW = row["UPDATED_AT_RAW"].ToString() == "" ? null : row["UPDATED_AT_RAW"].ToString(); oREQUEST_ID.UPDATED_BY = row["UPDATED_BY"].ToString(); oREQUEST_ID.SOCIOS_USER_FLG = row["SOCIOS_USER_FLG"].ToString(); oREQUEST_ID.COMPANY_BOX = Utility_Component.dtColumnToInt(row["COMPANY_BOX"].ToString()); oREQUEST_ID.COMPANY_NO = row["COMPANY_NO"].ToString(); string auto_index = row["AUTO_INDEX_ID"].ToString(); switch (auto_index) { case "サプライヤ": oREQUEST_ID.AUTO_INDEX_ID = "CNSUP"; break; case "要元": oREQUEST_ID.AUTO_INDEX_ID = "CNMAKER"; break; case "socios": oREQUEST_ID.AUTO_INDEX_ID = "CNSOCIOS"; break; default: oREQUEST_ID.AUTO_INDEX_ID = null; break; } return(oREQUEST_ID); }
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)); } }
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); } } }
private bool PrepareAndSendMail(BOL_REQUEST_ID oREQUEST_ID) { //get config object for CTS010 BOL_CONFIG config = new BOL_CONFIG("CTS010", con); //prepare for mail mapping string expire_date = oREQUEST_ID.PASSWORD_EXPIRATION_DATE == null ? "" : ((DateTime)oREQUEST_ID.PASSWORD_EXPIRATION_DATE).ToString("yyyy/MM/dd HH:mm"); Dictionary <string, string> map = new Dictionary <string, string>() { { "${companyName}", oREQUEST_ID.COMPANY_NAME }, { "${aventailUserName}", config.getStringValue("email.aventail.user.name") }, // come from config table { "${aventailPassword}", config.getStringValue("email.aventail.user.password") }, // come from config table { "${companyNoBox}", oREQUEST_ID.COMPANY_NO_BOX }, { "${password}", oREQUEST_ID.PASSWORD }, { "${limitDate}", expire_date }, { "${updUserId}", CURRENT_USER } }; //prepare for mail header string template_base_name = "CTS010_CompanyCode"; string subject = config.getStringValue("emailSubject.login.info"); string cc = config.getStringValue("emailAddress.cc"); //read email template string body = ""; try { string file_path = HttpContext.Current.Server.MapPath("~/Templates/Mail/" + template_base_name + ".txt"); body = System.IO.File.ReadAllText(file_path); } catch (Exception) { return(false); } //send mail return(Utility.Mail.sendMail(oREQUEST_ID.EMAIL_ADDRESS, cc, subject, body, map)); }
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 } } }