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