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