private void HandleModify(BOL_USAGE_CHARGE_MASTER oUSAGE_CHARGE_MASTER, string OPERATION, DataRow row)
{
string strMsg = "";
using (TransactionScope dbTxn = new TransactionScope())
{
USAGE_CHARGE_MASTER DAL_USAGE_CHARGE_MASTER = new USAGE_CHARGE_MASTER(con);
//check condition
if (!DAL_USAGE_CHARGE_MASTER.IsAlreadyUpdated(oUSAGE_CHARGE_MASTER, out strMsg)) // IF updated_at is not already modified
{
DAL_USAGE_CHARGE_MASTER.Update(oUSAGE_CHARGE_MASTER, 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 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 getUsageFeeMasterList(string CONSTRACT_CODE, string CONSTRACT_NAME, int OFFSET, int LIMIT)
{
try
{
string strMessage = "";
int TOTAL = 0;
USAGE_CHARGE_MASTER DAL_USAGE_CHARGE_MASTER = new USAGE_CHARGE_MASTER(con);
DataTable dt = DAL_USAGE_CHARGE_MASTER.GetUsageFeeMasterList(CONSTRACT_CODE, CONSTRACT_NAME, OFFSET, LIMIT, out strMessage, out TOTAL);
response.Data = Utility.Utility_Component.DtToJSon(dt, "UsageFeeMaster");
if (dt.Rows.Count > 0)
{
response.Status = 1;
}
else
{
if (strMessage == "")
{
response.Status = 1;
response.Message = "There is no data to display.";
}
else
{
response.Status = 0;
response.Message = strMessage;
}
}
response.Meta.Offset = OFFSET;
response.Meta.Limit = LIMIT;
response.Meta.Total = TOTAL;
timer.Stop();
response.Meta.Duration = timer.Elapsed.TotalMilliseconds;
return(response);
}
catch (Exception)
{
response.Status = 0;
response.Message = " Unexpected error occour.";
return(response);
}
}
