public TblBdStatus GetBankDepositStatusByTransNo(string tranno)
{
TblBdStatus objTblBdStatus = new TblBdStatus();
try
{
using (var connection = this.GetConnection())
{
objTblBdStatus = connection.QueryFirstOrDefault <TblBdStatus>("Select * from " + mainDbUser.DbUser + "TBL_BD_STATUS where Tranno ='" + tranno + "'");
connection.Close();
return(objTblBdStatus);
}
}
catch (Exception ex)
{
throw;
}
}
public object approveOrRejectBankDepositStatus(string roleName, string userName, string evnt, [FromBody] List <TblBdStatus> objTblBdStatusList)
{
try
{
string result = null;
result = transMastService.approveOrRejectBankDepositStatus(roleName, userName, evnt, objTblBdStatusList).ToString();
foreach (var item in objTblBdStatusList)
{
if (item.MakeStatus)
{
string response = null;
//if (roleName == "SOM")
if (roleName == "Distribution Leader")
{
item.SomId = userName;
if (evnt == "reject")
{
item.Status = "R";
response = result != "1" ? result : "Rejected Successfully!";
}
else
{
item.Status = "M";
response = result != "1" ? result : "Pass to Maker Successfully!";
}
TblBdStatus prevModel = transMastService.GetBankDepositStatusByTransNo(item.Tranno);
prevModel.Status = "N";
_auditTrailService.InsertUpdatedModelToAuditTrail(item, prevModel, item.SomId, 9, 4, "Bank Deposit Status", item.Tranno, response);
}
//else if (roleName == "Financial Maker" || roleName == "Sales Executive")
else if (roleName == "Financial Maker" || roleName == "SOM and FM")
{
item.MakerId = userName;
if (evnt == "reject")
{
item.Status = "R";
response = result != "1" ? result : "Rejected Successfully!";
}
else
{
item.Status = "C";
response = result != "1" ? result : "Pass to Checker Successfully!";
}
TblBdStatus prevModel = transMastService.GetBankDepositStatusByTransNo(item.Tranno);
prevModel.Status = "M";
_auditTrailService.InsertUpdatedModelToAuditTrail(item, prevModel, item.MakerId, 9, 4, "Bank Deposit Status", item.Tranno, response);
}
else
{
item.CheckId = userName;
if (evnt == "reject")
{
item.Status = "R";
response = result != "1" ? result : "Rejected Successfully!";
}
else
{
item.Status = "Y";
response = result != "1" ? result : "Approved Successfully!";
}
TblBdStatus prevModel = transMastService.GetBankDepositStatusByTransNo(item.Tranno);
prevModel.Status = "C";
_auditTrailService.InsertUpdatedModelToAuditTrail(item, prevModel, item.CheckId, 9, 4, "Bank Deposit Status", item.Tranno, response);
}
}
}
return(result);
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
}
