public void Update(BOL_EDI_ACCOUNT oEDI_ACCOUNT, string CURRENT_DATETIME, string CURRENT_USER, out String strMsg)
{
//handle Null value at where conditions
strUpdate = Utility.StringUtil.handleNullStringDate(strUpdate, "@UPDATED_AT", oEDI_ACCOUNT.UPDATED_AT_RAW);
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strUpdate);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CONSIGN_FLG", oEDI_ACCOUNT.CONSIGN_FLG));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@LOGIN_TYPE", oEDI_ACCOUNT.LOGIN_TYPE));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER1", oEDI_ACCOUNT.MAKER1));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER2", oEDI_ACCOUNT.MAKER2));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER3", oEDI_ACCOUNT.MAKER3));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER4", oEDI_ACCOUNT.MAKER4));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER5", oEDI_ACCOUNT.MAKER5));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER6", oEDI_ACCOUNT.MAKER6));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER7", oEDI_ACCOUNT.MAKER7));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER8", oEDI_ACCOUNT.MAKER8));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER9", oEDI_ACCOUNT.MAKER9));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER10", oEDI_ACCOUNT.MAKER10));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ADM_USER_ID", oEDI_ACCOUNT.ADM_USER_ID));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ADM_PASSWORD", oEDI_ACCOUNT.ADM_PASSWORD));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ADM_PASSWORD_HASHED", oEDI_ACCOUNT.ADM_PASSWORD_HASHED));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ATDL_USER_ID", oEDI_ACCOUNT.ATDL_USER_ID));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ATDL_PASSWORD", oEDI_ACCOUNT.ATDL_PASSWORD));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ATDL_PASSWORD_HASHED", oEDI_ACCOUNT.ATDL_PASSWORD_HASHED));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@SSHGW_USER_ID", oEDI_ACCOUNT.SSHGW_USER_ID));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@SSHGW_PUBLIC_KEY", oEDI_ACCOUNT.SSHGW_PUBLIC_KEY));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_DATETIME", CURRENT_DATETIME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATED_AT", oEDI_ACCOUNT.UPDATED_AT_RAW != null ? oEDI_ACCOUNT.UPDATED_AT_RAW : (object)DBNull.Value));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_USER", CURRENT_USER));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@EDI_ACCOUNT", oEDI_ACCOUNT.EDI_ACCOUNT));
oMaster.ExcuteQuery(2, out strMsg);
}
public void Insert(BOL_EDI_ACCOUNT oEDI_ACCOUNT, string CURRENT_TIME, string CURRENT_USER, out String strMsg)
{
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strInsert);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@EDI_ACCOUNT", oEDI_ACCOUNT.EDI_ACCOUNT));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", oEDI_ACCOUNT.COMPANY_NO_BOX));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CONSIGN_FLG", oEDI_ACCOUNT.CONSIGN_FLG));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@LOGIN_TYPE", oEDI_ACCOUNT.LOGIN_TYPE));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER1", oEDI_ACCOUNT.MAKER1));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER2", oEDI_ACCOUNT.MAKER2));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER3", oEDI_ACCOUNT.MAKER3));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER4", oEDI_ACCOUNT.MAKER4));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER5", oEDI_ACCOUNT.MAKER5));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER6", oEDI_ACCOUNT.MAKER6));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER7", oEDI_ACCOUNT.MAKER7));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER8", oEDI_ACCOUNT.MAKER8));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER9", oEDI_ACCOUNT.MAKER9));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@MAKER10", oEDI_ACCOUNT.MAKER10));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ADM_USER_ID", oEDI_ACCOUNT.ADM_USER_ID));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ADM_PASSWORD", oEDI_ACCOUNT.ADM_PASSWORD));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ADM_PASSWORD_HASHED", oEDI_ACCOUNT.ADM_PASSWORD_HASHED));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ATDL_USER_ID", oEDI_ACCOUNT.ATDL_USER_ID));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ATDL_PASSWORD", oEDI_ACCOUNT.ATDL_PASSWORD));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@ATDL_PASSWORD_HASHED", oEDI_ACCOUNT.ATDL_PASSWORD_HASHED));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@SSHGW_USER_ID", oEDI_ACCOUNT.SSHGW_USER_ID));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@SSHGW_PUBLIC_KEY", oEDI_ACCOUNT.SSHGW_PUBLIC_KEY));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_TIME", CURRENT_TIME));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_USER", CURRENT_USER));
oMaster.ExcuteQuery(6, out strMsg);
}
public bool IsAlreadyUpdated(BOL_EDI_ACCOUNT oEDI_ACCOUNT, out string strMsg)
{
//handle Null value at where conditions
strSearchWithKeyAndUpdated_at = Utility.StringUtil.handleNullStringDate(strSearchWithKeyAndUpdated_at, "@UPDATED_AT", oEDI_ACCOUNT.UPDATED_AT_RAW);
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strSearchWithKeyAndUpdated_at);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@EDI_ACCOUNT", oEDI_ACCOUNT.EDI_ACCOUNT));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATED_AT", oEDI_ACCOUNT.UPDATED_AT_RAW));
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);
}
}
private BOL_EDI_ACCOUNT GetEDI_ACCOUNT(USAGE_INFO_REGISTRATION oUSAGE_INFO_REG)
{
BOL_EDI_ACCOUNT oEDI_ACCOUNT = new BOL_EDI_ACCOUNT();
oEDI_ACCOUNT.EDI_ACCOUNT = oUSAGE_INFO_REG.EDI_ACCOUNT;
oEDI_ACCOUNT.COMPANY_NO_BOX = oUSAGE_INFO_REG.COMPNAY_NO_BOX;
oEDI_ACCOUNT.CONSIGN_FLG = oUSAGE_INFO_REG.CONSIGN_FLG;
oEDI_ACCOUNT.LOGIN_TYPE = oUSAGE_INFO_REG.LOGIN_TYPE;
oEDI_ACCOUNT.MAKER1 = oUSAGE_INFO_REG.MAKER1;
oEDI_ACCOUNT.MAKER2 = oUSAGE_INFO_REG.MAKER2;
oEDI_ACCOUNT.MAKER3 = oUSAGE_INFO_REG.MAKER3;
oEDI_ACCOUNT.MAKER4 = oUSAGE_INFO_REG.MAKER4;
oEDI_ACCOUNT.MAKER5 = oUSAGE_INFO_REG.MAKER5;
oEDI_ACCOUNT.MAKER6 = oUSAGE_INFO_REG.MAKER6;
oEDI_ACCOUNT.MAKER7 = oUSAGE_INFO_REG.MAKER7;
oEDI_ACCOUNT.MAKER8 = oUSAGE_INFO_REG.MAKER8;
oEDI_ACCOUNT.MAKER9 = oUSAGE_INFO_REG.MAKER9;
oEDI_ACCOUNT.MAKER10 = oUSAGE_INFO_REG.MAKER10;
oEDI_ACCOUNT.ADM_USER_ID = oUSAGE_INFO_REG.ADM_USER_ID;
oEDI_ACCOUNT.ADM_PASSWORD = oUSAGE_INFO_REG.ADM_PASSWORD;
oEDI_ACCOUNT.ADM_PASSWORD_HASHED = Crypto.HashPassword(oEDI_ACCOUNT.ADM_PASSWORD);
oEDI_ACCOUNT.ATDL_USER_ID = oUSAGE_INFO_REG.ATDL_USER_ID;
oEDI_ACCOUNT.ATDL_PASSWORD = oUSAGE_INFO_REG.ATDL_PASSWORD;
oEDI_ACCOUNT.ATDL_PASSWORD_HASHED = Crypto.HashPassword(oEDI_ACCOUNT.ATDL_PASSWORD);
oEDI_ACCOUNT.SSHGW_USER_ID = oUSAGE_INFO_REG.SSHGW_USER_ID;
oEDI_ACCOUNT.SSHGW_PUBLIC_KEY = oUSAGE_INFO_REG.SSHGW_PUBLIC_KEY;
oEDI_ACCOUNT.CREATED_AT = oUSAGE_INFO_REG.UPDATED_BY;
oEDI_ACCOUNT.UPDATED_AT = oUSAGE_INFO_REG.UPDATED_AT;
oEDI_ACCOUNT.UPDATED_AT_RAW = oUSAGE_INFO_REG.UPDATED_AT_RAW;
oEDI_ACCOUNT.UPDATED_BY = oUSAGE_INFO_REG.UPDATED_BY;
return(oEDI_ACCOUNT);
}
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 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);
}
}
}
public void Delete(BOL_EDI_ACCOUNT oEDI_ACCOUNT, out String strMsg)
{
//handle Null value at where conditions
strDelete = Utility.StringUtil.handleNullStringDate(strDelete, "@UPDATED_AT", oEDI_ACCOUNT.UPDATED_AT);
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strDelete);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@EDI_ACCOUNT", oEDI_ACCOUNT.EDI_ACCOUNT));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATED_AT", oEDI_ACCOUNT.UPDATED_AT_RAW));
oMaster.ExcuteQuery(3, out strMsg);
}
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
}
