public bool IsAlreadyUpdated(BOL_AUTO_INDEX oAUTO_INDEX, out string strMsg)
{
//handle Null value at where conditions
strSearchWithKeyAndUpdated_at = Utility.StringUtil.handleNullStringDate(strSearchWithKeyAndUpdated_at, "@UPDATED_AT", oAUTO_INDEX.UPDATED_AT);
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strSearchWithKeyAndUpdated_at);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@AUTO_INDEX_ID", oAUTO_INDEX.AUTO_INDEX_ID));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATED_AT", oAUTO_INDEX.UPDATED_AT != null ? oAUTO_INDEX.UPDATED_AT : (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);
}
}
private BOL_AUTO_INDEX Cast_AUTO_INDEX(DataRow row)
{
BOL_AUTO_INDEX oAUTO_INDEX = new BOL_AUTO_INDEX();
oAUTO_INDEX.AUTO_INDEX_ID = row["AUTO_INDEX_ID"].ToString();
oAUTO_INDEX.AUTO_INDEX = int.Parse(row["AUTO_INDEX"].ToString());
oAUTO_INDEX.CREATED_AT = row["CREATED_AT"].ToString();
oAUTO_INDEX.CREATED_BY = row["CREATED_BY"].ToString();
oAUTO_INDEX.UPDATED_AT = row["UPDATED_AT"].ToString() == "" ? null : row["UPDATED_AT"].ToString();
oAUTO_INDEX.UPDATED_BY = row["UPDATED_BY"].ToString();
return(oAUTO_INDEX);
}
public void Update(BOL_AUTO_INDEX oAUTO_INDEX, string CURRENT_DATETIME, string CURRENT_USER, out String strMsg)
{
//handle Null value at where conditions
strUpdateIndex = Utility.StringUtil.handleNullStringDate(strUpdateIndex, "@UPDATED_AT", oAUTO_INDEX.UPDATED_AT);
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strUpdateIndex);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@AUTO_INDEX_ID", oAUTO_INDEX.AUTO_INDEX_ID));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@AUTO_INDEX", oAUTO_INDEX.AUTO_INDEX));
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", oAUTO_INDEX.UPDATED_AT != null ? oAUTO_INDEX.UPDATED_AT : (object)DBNull.Value));
oMaster.ExcuteQuery(2, out strMsg);
}
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
}
}
}
