private void HandleDelete(BOL_USAGE_CHARGE_MASTER oUSAGE_CHARGE_MASTER, DataRow row)
{
string strMsg = "";
using (TransactionScope dbTxn = new TransactionScope())
{
USAGE_CHARGE_MASTER DAL_USAGE_CHARGE_MASTER = new USAGE_CHARGE_MASTER(con);
if (!DAL_USAGE_CHARGE_MASTER.IsAlreadyUpdated(oUSAGE_CHARGE_MASTER, out strMsg)) // IF updated_at is not already modified
{
//delete the record
DAL_USAGE_CHARGE_MASTER.Delete(oUSAGE_CHARGE_MASTER, 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);
}
}
}
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);
}
}
}
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));
}
}
