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