public ActionResult Insert(ValuatorTwoViewModel objViewModel) { try { ModelState.Remove("Id"); if (objViewModel.ID == 0) { if (InsertData(objViewModel)) { return(Json(1, JsonRequestBehavior.AllowGet)); } else { return(Json(3, JsonRequestBehavior.AllowGet)); } } else { if (InsertData(objViewModel)) { return(Json(2, JsonRequestBehavior.AllowGet)); } } objViewModel.ValuatorTwoDetailsList = new List <ValuatorTwoDetailsViewModel>(); ViewBag.PurityList = new SelectList(_valuatorTwoService.GetAllPurityMaster(), "Id", "PurityName"); ViewBag.OrnamentList = new SelectList(_valuatorTwoService.GetOrnamentList(), "ItemId", "ItemName"); return(View("ValuatoTwo", objViewModel)); } catch (Exception ex) { throw ex; } }
/// <summary> /// /// </summary> /// <returns></returns> public ActionResult ValuatorTwo() { ButtonVisiblity("Index"); var model = new ValuatorTwoViewModel(); model.TransactionId = _valuatorTwoService.GetMaxTransactionId(); model.ValuatorTwoDetailsList = new List <ValuatorTwoDetailsViewModel>(); ViewBag.PurityList = new SelectList(_valuatorTwoService.GetAllPurityMaster(), "Id", "PurityName"); ViewBag.OrnamentList = new SelectList(_valuatorTwoService.GetOrnamentList(), "ItemId", "ItemName"); Session["ValuationImageTwoList"] = null; Session["ConsolidatedImageTwo"] = null; Session["ConsolidatedImageNameTwo"] = null; Session["ConsolidatedImageContentTypeTwo"] = null; return(View(model)); }
public ValuatorTwoViewModel GetValuatorOneDetailsById(int Id) { var model = new ValuatorTwoViewModel(); model = (from a in _context.tbl_ValuatorOne join b in _context.TGLPreSanctions on a.PreSanctionId equals b.PreSanctionID join c in _context.TSchemeMaster_BasicDetails on b.SchemeID equals c.SID where a.Id == Id select new ValuatorTwoViewModel() { ValuatorOneId = a.Id, KycId = (int)a.KYCId, CustomerId = a.CustomerID, ApplicationNo = a.ApplicationNo, Comments = a.Comments, ImageName = a.ImageName, MaxLtv = (decimal)c.MaxLtv, ProductId = b.ProductID }).FirstOrDefault(); var valuatoronedetails = (from a in _context.tbl_ValuatorOne join b in _context.tbl_ValuatorOneDetails on a.Id equals b.ValuationOneID join c in _context.tblItemMasters on b.OrnamentId equals c.ItemID join d in _context.Mst_PurityMaster on b.PurityId equals d.id where a.Id == Id select new ValuatorTwoDetailsViewModel() { ID = b.Id, OrnamentId = b.OrnamentId, OrnamentName = c.ItemName, ImageName = b.ImageName, Qty = (int)b.Qty, PurityId = b.PurityId, PurityName = d.PurityName, GrossWeight = (decimal)b.GrossWt, Deductions = (decimal)b.Deduction, NetWeight = (decimal)b.NtWt, Rate = (decimal)b.Rate, ValOneTotal = (decimal)b.Total }).ToList(); model.ValuatorTwoDetailsList = valuatoronedetails; return(model); }
public bool InsertData(ValuatorTwoViewModel model) { bool retVal = false; model.CreatedBy = Convert.ToInt32(Session["UserLoginId"]); model.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]); try { if (Session["ConsolidatedImageTwo"] != null) { model.ConsolidatedImageFile = (byte[])Session["ConsolidatedImageTwo"]; model.ImageName = Session["ConsolidatedImageNameTwo"].ToString(); model.ContentType = Session["ConsolidatedImageContentTypeTwo"].ToString(); } if (Session["ValuationImageTwoList"] != null) { var list = (List <ValuatorOneDetailsViewModel>)Session["ValuationImageTwoList"]; if (list != null) { for (int i = 0; i <= list.Count - 1; i++) { // for valuator two model.ValuatorTwoDetailsList[i].ValuationImageFile = list[i].ValuationImageFile; model.ValuatorTwoDetailsList[i].ImageName = list[i].ImageName; model.ValuatorTwoDetailsList[i].ContentType = list[i].ContentType; // for valuation table model.ValuationDetailsList[i].ValuationImageFile = list[i].ValuationImageFile; model.ValuationDetailsList[i].ImageName = list[i].ImageName; model.ValuationDetailsList[i].ContentType = list[i].ContentType; } } } _valuatorTwoService.SaveRecord(model); retVal = true; } catch (Exception ex) { throw ex; } return(retVal); }
public void SaveUpdateRecord(ValuatorTwoViewModel model) { tbl_ValuatorTwo tblValtwo = new tbl_ValuatorTwo(); try { if (model.ID <= 0) { tblValtwo.TransactionId = model.TransactionId; tblValtwo.ValuatorOneId = model.ValuatorOneId; tblValtwo.KYCID = model.KycId; tblValtwo.CustomerID = model.CustomerId; tblValtwo.ApplicationNo = model.ApplicationNo; tblValtwo.Comments = model.Comments; tblValtwo.BranchId = Convert.ToInt32(HttpContext.Current.Session["BranchId"]); tblValtwo.CompId = Convert.ToInt32(HttpContext.Current.Session["CompanyId"]); tblValtwo.FinancialYearId = Convert.ToInt32(HttpContext.Current.Session["FinancialYearId"]); tblValtwo.ConsolidatedImage = model.ConsolidatedImageFile; tblValtwo.ImageName = model.ImageName; tblValtwo.ContentType = model.ContentType; tblValtwo.LTVPerc = model.LTVPerc; tblValtwo.EligibleLoanAmount = model.EligibleLoanAmount; tblValtwo.SanctionLoanAmount = model.SanctionLoanAmount; tblValtwo.Comments = model.Comments; tblValtwo.CreatedBy = model.CreatedBy; tblValtwo.CreatedDate = DateTime.Now; tblValtwo.UpdatedBy = model.UpdatedBy; tblValtwo.UpdatedDate = DateTime.Now; _context.tbl_ValuatorTwo.Add(tblValtwo); _context.SaveChanges(); int maxid = _context.tbl_ValuatorTwo.Any() ? _context.tbl_ValuatorTwo.Max(x => x.Id) : 1; foreach (var p in model.ValuatorTwoDetailsList) { var trn = new tbl_ValuatorTwoDetails { ValuationTwoID = maxid, ValOneId = p.ValOneDetailsId, OrnamentId = p.OrnamentId, OrnamentImage = p.ValuationImageFile, ImageName = p.ImageName, ContentType = p.ContentType, Qty = p.Qty, PurityId = p.PurityId, GrossWt = p.GrossWeight, Deduction = p.Deductions, NtWt = p.NetWeight, Rate = p.Rate, ValOneTotal = p.ValOneTotal, ValTwoTotal = p.ValTwoTotal }; _context.tbl_ValuatorTwoDetails.Add(trn); _context.SaveChanges(); } foreach (var p in model.ValuationDetailsList) { var val = new tbl_OrnamentEvaluationDetails { ValTwoId = maxid, SDID = 0, OrnamentId = p.OrnamentId, OrnamentImage = p.ValuationImageFile, ImageName = p.ImageName, ContentType = p.ContentType, Qty = p.Qty, PurityId = p.PurityId, GrossWt = p.GrossWeight, Deduction = p.Deductions, NtWt = p.NetWeight, Rate = p.Rate, Total = p.ValTwoTotal, KycId = model.KycId }; _context.tbl_OrnamentEvaluationDetails.Add(val); _context.SaveChanges(); } } else { //update the data in Charge Details table var tblObj = _context.tbl_ValuatorTwo.Where(x => x.Id == model.ID).FirstOrDefault(); tblObj.CustomerID = model.CustomerId; tblObj.ValuatorOneId = model.ValuatorOneId; tblObj.TransactionId = model.TransactionId; tblObj.KYCID = model.KycId; tblObj.ApplicationNo = model.ApplicationNo; tblObj.Comments = model.Comments; tblObj.UpdatedBy = model.UpdatedBy; tblObj.CreatedDate = DateTime.Now; tblObj.BranchId = Convert.ToInt32(HttpContext.Current.Session["BranchId"]); tblObj.CompId = Convert.ToInt32(HttpContext.Current.Session["CompanyId"]); tblObj.FinancialYearId = Convert.ToInt32(HttpContext.Current.Session["FinancialYearId"]); tblObj.ConsolidatedImage = model.ConsolidatedImageFile; tblObj.ImageName = model.ImageName; tblObj.ContentType = model.ContentType; tblObj.LTVPerc = model.LTVPerc; tblObj.EligibleLoanAmount = model.EligibleLoanAmount; tblObj.SanctionLoanAmount = model.SanctionLoanAmount; tblObj.Comments = model.Comments; _context.SaveChanges(); foreach (var p in model.ValuatorTwoDetailsList) { var Findobject = _context.tbl_ValuatorTwoDetails.Where(x => x.ValuationTwoID == model.ID && x.Id == p.ID).FirstOrDefault(); if (Findobject != null) { Findobject.ValOneId = p.ValOneDetailsId; Findobject.ValuationTwoID = tblObj.Id; Findobject.OrnamentId = p.OrnamentId; Findobject.OrnamentImage = p.ValuationImageFile; Findobject.ContentType = p.ContentType; Findobject.ImageName = p.ImageName; Findobject.Qty = p.Qty; Findobject.PurityId = p.PurityId; Findobject.GrossWt = p.GrossWeight; Findobject.Deduction = p.Deductions; Findobject.NtWt = p.NetWeight; Findobject.Rate = p.Rate; Findobject.ValOneTotal = p.ValOneTotal; Findobject.ValTwoTotal = p.ValTwoTotal; _context.SaveChanges(); } } foreach (var p in model.ValuationDetailsList) { var Findobject = _context.tbl_OrnamentEvaluationDetails.Where(x => x.ValTwoId == model.ID && x.Id == p.ID).FirstOrDefault(); if (Findobject != null) { Findobject.ValTwoId = tblObj.Id; Findobject.SDID = 0; Findobject.KycId = model.KycId; Findobject.OrnamentId = p.OrnamentId; Findobject.OrnamentImage = p.ValuationImageFile; Findobject.ContentType = p.ContentType; Findobject.ImageName = p.ImageName; Findobject.Qty = p.Qty; Findobject.PurityId = p.PurityId; Findobject.GrossWt = p.GrossWeight; Findobject.Deduction = p.Deductions; Findobject.NtWt = p.NetWeight; Findobject.Rate = p.Rate; Findobject.Total = p.ValTwoTotal; _context.SaveChanges(); } } } } catch (Exception ex) { throw ex; } }
public ValuatorTwoViewModel GetValuatorTwoDetailsById(int Id) { var model = new ValuatorTwoViewModel(); model = (from a in _context.tbl_ValuatorTwo join b in _context.tbl_ValuatorTwoDetails on a.Id equals b.ValuationTwoID join c in _context.tbl_ValuatorOne on a.ValuatorOneId equals c.Id join d in _context.TGLPreSanctions on c.PreSanctionId equals d.PreSanctionID where a.Id == Id select new ValuatorTwoViewModel() { ID = a.Id, KycId = (int)a.KYCID, ValuatorOneId = a.ValuatorOneId, TransactionId = a.TransactionId, CustomerId = a.CustomerID, ApplicationNo = a.ApplicationNo, Comments = a.Comments, ImageName = a.ImageName, LTVPerc = (decimal)a.LTVPerc, MaxLtv = (decimal)a.LTVPerc, EligibleLoanAmount = (decimal)a.EligibleLoanAmount, SanctionLoanAmount = (decimal)a.SanctionLoanAmount, ProductId = d.ProductID }).FirstOrDefault(); var valuatortwodetails = (from a in _context.tbl_ValuatorTwo join b in _context.tbl_ValuatorTwoDetails on a.Id equals b.ValuationTwoID into ps from b in ps.DefaultIfEmpty() join c in _context.tblItemMasters on b.OrnamentId equals c.ItemID join d in _context.Mst_PurityMaster on b.PurityId equals d.id where a.Id == Id select new ValuatorTwoDetailsViewModel() { ID = b.Id, ValOneDetailsId = b.ValOneId, OrnamentId = b.OrnamentId, OrnamentName = c.ItemName, ImageName = b.ImageName, Qty = (int)b.Qty, PurityId = b.PurityId, PurityName = d.PurityName, GrossWeight = (decimal)b.GrossWt, Deductions = (decimal)b.Deduction, NetWeight = (decimal)b.NtWt, Rate = (decimal)b.Rate, ValOneTotal = (decimal)b.ValOneTotal, ValTwoTotal = (decimal)b.ValTwoTotal }).ToList(); model.ValuatorTwoDetailsList = valuatortwodetails; var valuatordetails = (from a in _context.tbl_ValuatorTwo join b in _context.tbl_OrnamentEvaluationDetails on a.Id equals b.ValTwoId join c in _context.tblItemMasters on b.OrnamentId equals c.ItemID join d in _context.Mst_PurityMaster on b.PurityId equals d.id where a.Id == Id select new ValuatorTwoDetailsViewModel() { ID = b.Id, ValuatorTwoId = b.ValTwoId, OrnamentId = b.OrnamentId, OrnamentName = c.ItemName, ImageName = b.ImageName, Qty = (int)b.Qty, PurityId = b.PurityId, PurityName = d.PurityName, GrossWeight = (decimal)b.GrossWt, Deductions = (decimal)b.Deduction, NetWeight = (decimal)b.NtWt, Rate = (decimal)b.Rate, ValTwoTotal = (decimal)b.Total }).ToList(); model.ValuationDetailsList = valuatordetails; return(model); }
public void SaveRecord(ValuatorTwoViewModel model) { _valuatorTwoRepository.SaveUpdateRecord(model); }