public JsonResult AddNewAccount(AddAccountModel accountmodel) { string errMessage = string.Empty; if (ModelState.IsValid) { var validation = SecurityController.ValidateToken(accountmodel.TokenCode); try { if (validation.Validated == true) { var AccListResult = _db.Query <AccountResultModel>(";Exec Supreme_AddNewAccount @ClientID,@AccountName,@ProductID,@Address,@CityID,@CountryID,@Mobile,@OperatingModeID,@OperatorID", new { ClientID = accountmodel.ClientID, AccountName = accountmodel.AccountName, ProductID = accountmodel.ProductID, Address = accountmodel.Address, CityID = accountmodel.CityID, CountryID = accountmodel.CountryID, Mobile = accountmodel.Mobile, OperatingModeID = accountmodel.OperatingModeID, OperatorID = SecurityController.GetValidOperator(accountmodel.TokenCode).ToString() }).SingleOrDefault(); logger.LogWrite(JsonConvert.SerializeObject(accountmodel).ToString() + ":-" + JsonConvert.SerializeObject(AccListResult).ToString()); return(Json(AccListResult, JsonRequestBehavior.AllowGet)); } else { GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = validation.Errors[0].ToString(); logger.LogWrite(JsonConvert.SerializeObject(validation).ToString()); return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } } catch (Exception ee) { GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = ee.Message; GeneralService.WriteErrorLog(ref ee); return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } } else { var message = string.Join(" | ", ModelState.Values .SelectMany(v => v.Errors) .Select(e => e.ErrorMessage)); GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = message; return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } }
public JsonResult LoanProcessing(ProcessLoanModel loanmodel) { string errMessage = string.Empty; if (ModelState.IsValid) { var validation = SecurityController.ValidateToken(loanmodel.TokenCode); try { if (validation.Validated == true) { var AccListResult = _db.Query <LoanProcessResultModel>(";Exec Supreme_ProcessNewLoan @ClientID,@ProductID,@LoanAmount,@LoanTerm,@InterestRate,@LoanPeriodID,@PurposeCodeID,@CreditOfficerID,@Remarks,@OperatorID", new { ClientID = loanmodel.ClientID, ProductID = loanmodel.ProductID, LoanAmount = loanmodel.LoanAmount, LoanTerm = loanmodel.LoanTerm, InterestRate = loanmodel.InterestRate, LoanPeriodID = loanmodel.LoanPeriodID, PurposeCodeID = loanmodel.PurposeCodeID, CreditOfficerID = loanmodel.CreditOfficerID, Remarks = loanmodel.Remarks, OperatorID = SecurityController.GetValidOperator(loanmodel.TokenCode).ToString()//loanmodel.OperatorID }).SingleOrDefault(); logger.LogWrite(JsonConvert.SerializeObject(loanmodel).ToString()); return(Json(AccListResult, JsonRequestBehavior.AllowGet)); } else { GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = validation.Errors[0].ToString(); logger.LogWrite(JsonConvert.SerializeObject(validation).ToString()); return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } } catch (Exception ee) { GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = ee.Message; GeneralService.WriteErrorLog(ref ee); return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } } else { var message = string.Join(" | ", ModelState.Values .SelectMany(v => v.Errors) .Select(e => e.ErrorMessage)); GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = message; return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } }
public JsonResult AddCashTrx(CashTrxAddModel addcashTrxmodel) { string errMessage = string.Empty; if (ModelState.IsValid) { var validation = SecurityController.ValidateToken(addcashTrxmodel.TokenCode); try { if (validation.Validated == true) { var AccListResult = _db.Query <TrfResultModel>(";Exec Supreme_AddCashTrx @AccountTypeID, @AccountID, @TrxAmount, @Narration, @RefNumber,@OperatorID,@TrxTypeID", new { AccountTypeID = addcashTrxmodel.AccountTypeID, AccountID = addcashTrxmodel.AccountID, TrxAmount = addcashTrxmodel.TrxAmount, Narration = addcashTrxmodel.Narration, RefNumber = addcashTrxmodel.RefNumber, OperatorID = SecurityController.GetValidOperator(addcashTrxmodel.TokenCode).ToString(), TrxTypeID = addcashTrxmodel.TrxTypeID }).SingleOrDefault(); logger.LogWrite(JsonConvert.SerializeObject(addcashTrxmodel).ToString()); return(Json(AccListResult, JsonRequestBehavior.AllowGet)); } else { GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = validation.Errors[0].ToString(); logger.LogWrite(JsonConvert.SerializeObject(validation).ToString()); return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } } catch (Exception ee) { GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = ee.Message; GeneralService.WriteErrorLog(ref ee); return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } } else { var message = string.Join(" | ", ModelState.Values .SelectMany(v => v.Errors) .Select(e => e.ErrorMessage)); GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = message; return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } //return Json(UserListResult, JsonRequestBehavior.AllowGet); }
public JsonResult FetchAccountStatement(AccountStmParamsModel Accmodel) { string errMessage = string.Empty; if (ModelState.IsValid) { var validation = SecurityController.ValidateToken(Accmodel.TokenCode); try { if (validation.Validated == true) { var AccListResult = _db.Query <AccountStatementModel>(";Exec Supreme_GetAccountTransactions @OurBranchID,@AccountID,@FromDate,@ToDate,@OperatorID", new { OurBranchID = Accmodel.OurBranchID, AccountID = Accmodel.AccountID, FromDate = Accmodel.FromDate, ToDate = Accmodel.ToDate, OperatorID = SecurityController.GetValidOperator(Accmodel.TokenCode).ToString() }).ToList(); logger.LogWrite(JsonConvert.SerializeObject(Accmodel).ToString() + ":-" + JsonConvert.SerializeObject(AccListResult).ToString()); return(Json(AccListResult, JsonRequestBehavior.AllowGet)); } else { GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = validation.Errors[0].ToString(); logger.LogWrite(JsonConvert.SerializeObject(validation).ToString()); return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } } catch (Exception ee) { GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = ee.Message; GeneralService.WriteErrorLog(ref ee); return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } } else { var message = string.Join(" | ", ModelState.Values .SelectMany(v => v.Errors) .Select(e => e.ErrorMessage)); GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = message; return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } }
public JsonResult LoanSanction(SanctionLoanModel loanmodel) { string errMessage = string.Empty; if (ModelState.IsValid) { var validation = SecurityController.ValidateToken(loanmodel.TokenCode); try { if (validation.Validated == true) { var AccListResult = _db.Query <LoanAppResultModel>(";Exec Supreme_LoanSanction @ApplicationID,@ApprovedBy,@Remarks,@OperatorID", new { ApplicationID = loanmodel.ApplicationID, ApprovedBy = loanmodel.ApprovedBy, Remarks = loanmodel.Remarks, OperatorID = SecurityController.GetValidOperator(loanmodel.TokenCode).ToString() }).SingleOrDefault(); logger.LogWrite(JsonConvert.SerializeObject(loanmodel).ToString()); return(Json(AccListResult, JsonRequestBehavior.AllowGet)); } else { GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = validation.Errors[0].ToString(); logger.LogWrite(JsonConvert.SerializeObject(validation).ToString()); return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } } catch (Exception ee) { GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = ee.Message; GeneralService.WriteErrorLog(ref ee); return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } } else { var message = string.Join(" | ", ModelState.Values .SelectMany(v => v.Errors) .Select(e => e.ErrorMessage)); GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = message; return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } }
public JsonResult AddNewClient(AddClientModel clientmodel) { string errMessage = string.Empty; if (ModelState.IsValid) { var validation = SecurityController.ValidateToken(clientmodel.TokenCode); try { if (validation.Validated == true) { var AccListResult = _db.Query <ClientResultModel>(";Exec Supreme_AddNewClient @ClientTypeID,@TitleID,@FirstName,@MiddleName,@LastName,@GenderID,@DateOfBirth,@IDTypeID,@IDNumber, @CountryID, @CityID, @Address, @ZipCodeID, @Mobile, @EmailAddress, @Phone1,@OperatorID", new { ClientTypeID = clientmodel.ClientTypeID, TitleID = clientmodel.TitleID, FirstName = clientmodel.FirstName, MiddleName = clientmodel.MiddleName, LastName = clientmodel.LastName, GenderID = clientmodel.GenderID, DateOfBirth = clientmodel.DateOfBirth, IDTypeID = clientmodel.IDTypeID, IDNumber = clientmodel.IDNumber, CountryID = clientmodel.CountryID, CityID = clientmodel.CityID, Address = clientmodel.Address, ZipCodeID = clientmodel.ZipCodeID, Mobile = clientmodel.Mobile, EmailAddress = clientmodel.EmailAddress, Phone1 = clientmodel.Phone1, OperatorID = SecurityController.GetValidOperator(clientmodel.TokenCode).ToString() }).SingleOrDefault(); logger.LogWrite(JsonConvert.SerializeObject(clientmodel).ToString() + ":-" + JsonConvert.SerializeObject(AccListResult).ToString()); return(Json(AccListResult, JsonRequestBehavior.AllowGet)); } else { GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = validation.Errors[0].ToString(); logger.LogWrite(JsonConvert.SerializeObject(validation).ToString()); return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } } catch (Exception ee) { GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = ee.Message; GeneralService.WriteErrorLog(ref ee); return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } } else { var message = string.Join(" | ", ModelState.Values .SelectMany(v => v.Errors) .Select(e => e.ErrorMessage)); GenericResultModel AccListResult2 = new GenericResultModel(); AccListResult2.Status = "Fail"; AccListResult2.Remarks = message; return(Json(AccListResult2, JsonRequestBehavior.AllowGet)); } }