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())); } }