// ##################### Search END ############## public ActionResult GetLcDetailsInfoByInsuranceID(string InsuranceID) { int id = Convert.ToInt32(InsuranceID); LCM_Insurence dataSet = repo.LcmInsuranceRpository.GetByID(id); Lcm_Insurence obInsurance = new Lcm_Insurence(); obInsurance.InsuranceID = dataSet.InsuranceID; obInsurance.InsuranceChallanNo = dataSet.InsuranceChallanNo; obInsurance.InsuranceCompany = dataSet.InsuranceCompany; obInsurance.InsuranceCompanyName = repo.BranchRepository.GetByID(dataSet.InsuranceCompany).BranchName; if (!string.IsNullOrEmpty(dataSet.LCNo)) { obInsurance.LCNumber = dataSet.LCNo; obInsurance.LCNo = Convert.ToString((from t in repo.LCOpeningRepository.Get(ob => ob.LCNo == dataSet.LCNo) select t.LCID).FirstOrDefault()); } obInsurance.InsuranceNo = dataSet.InsuranceNo; obInsurance.CoverNoteDate = dataSet.CoverNoteDate; obInsurance.MoneyReceiptNo = dataSet.MoneyReceiptNo; if (dataSet.MoneyReceiptDate.ToString() != "01/01/0001 12:00:00 AM") { obInsurance.MoneyReceiptDate = Convert.ToDateTime(dataSet.MoneyReceiptDate).ToString("dd/MM/yyyy"); } obInsurance.ClauseEndorsement = dataSet.ClauseEndorsement; obInsurance.InsuranceChallanNo = dataSet.InsuranceChallanNo; if (dataSet.InsurancChallanDate.ToString() != "01/01/0001 12:00:00 AM") { obInsurance.InsurancChallanDate = Convert.ToDateTime(dataSet.InsurancChallanDate).ToString("dd/MM/yyyy"); } obInsurance.PolicyNo = dataSet.PolicyNo; if (dataSet.PolicyDate.ToString() != "01/01/0001 12:00:00 AM") { obInsurance.PolicyDate = Convert.ToDateTime(dataSet.PolicyDate).ToString("dd/MM/yyyy"); } obInsurance.InvoiceAmount = dataSet.InvoiceAmount; obInsurance.InvouceCurrency = dataSet.InvouceCurrency; obInsurance.IncreasePercent = (decimal)dataSet.IncreasePercent; obInsurance.IncreaseAmount = (decimal)dataSet.IncreaseAmount; obInsurance.SumInsured = (decimal)dataSet.SumInsured; obInsurance.ExchangeRate = (decimal)dataSet.ExchangeRate; obInsurance.ExchangeRateCurrency = (byte)dataSet.ExchangeRateCurrency; obInsurance.ExchangedSumInsured = (decimal)dataSet.ExchangedSumInsured; obInsurance.MarinePremiumPercent = (decimal)dataSet.MarinePremiumPercent; obInsurance.MarinePremiumAmount = (decimal)dataSet.MarinePremiumAmount; obInsurance.DiscountPercent = (decimal)dataSet.DiscountPercent; obInsurance.DiscountAmount = (decimal)dataSet.DiscountAmount; obInsurance.WarSRCCPercent = (decimal)dataSet.WarSRCCPercent; obInsurance.WarSRCCPercentAmount = (decimal)dataSet.WarSRCCPercentAmount; obInsurance.NetPremium = (decimal)dataSet.NetPremium; obInsurance.VatPercent = (decimal)dataSet.VatPercent; obInsurance.VatAmount = (decimal)dataSet.VatAmount; //obInsurance.StampDutyRetio = (decimal)dataSet.StampDutyRetio; obInsurance.StampDutyAmount = (decimal)dataSet.StampDutyAmount; obInsurance.GrandPremium = (decimal)dataSet.GrandPremium; obInsurance.RefundPercent = (decimal)dataSet.RefundPercent; obInsurance.RefundAmount = (decimal)dataSet.RefundAmount; obInsurance.PaidAmount = (decimal)dataSet.PaidAmount; obInsurance.RevisionNo = dataSet.RevisionNo; if (dataSet.RevisionDate.ToString() != "01/01/0001 12:00:00 AM") { obInsurance.RevisionDate = Convert.ToDateTime(dataSet.RevisionDate).ToString("dd/MM/yyyy"); } obInsurance.RecordStatus = dataSet.RecordStatus; obInsurance.ApprovalAdvice = dataSet.ApprovalAdvice; obInsurance.CIID = Convert.ToInt32(dataSet.CIID); obInsurance.CINo = dataSet.CINo; if (dataSet.PIID != null) { obInsurance.PIID = dataSet.PIID.ToString(); } else { obInsurance.PIID = ""; } return(Json(obInsurance, JsonRequestBehavior.AllowGet)); }
public ActionResult Update(Lcm_Insurence dataSet) { try { LCM_Insurence obInsurance = repo.LcmInsuranceRpository.GetByID(Convert.ToInt32(dataSet.InsuranceID)); if (!obInsurance.RecordStatus.Equals("CNF")) { obInsurance.InsuranceChallanNo = dataSet.InsuranceChallanNo; obInsurance.InsuranceCompany = dataSet.InsuranceCompany; obInsurance.LCID = dataSet.LCID; obInsurance.LCNo = dataSet.LCNo; obInsurance.InsuranceNo = dataSet.InsuranceNo; obInsurance.CoverNoteDate = dataSet.CoverNoteDate == null?"": dataSet.CoverNoteDate.ToString(); obInsurance.MoneyReceiptNo = dataSet.MoneyReceiptNo; obInsurance.MoneyReceiptDate = DalCommon.SetDate(dataSet.MoneyReceiptDate == null?"":dataSet.MoneyReceiptDate.ToString()); obInsurance.ClauseEndorsement = dataSet.ClauseEndorsement; obInsurance.InsuranceChallanNo = dataSet.InsuranceChallanNo; obInsurance.InsurancChallanDate = DalCommon.SetDate(dataSet.InsurancChallanDate == null?"": dataSet.InsurancChallanDate.ToString()); obInsurance.PolicyNo = dataSet.PolicyNo; obInsurance.PolicyDate = DalCommon.SetDate(dataSet.PolicyDate == null?"": dataSet.PolicyDate.ToString()); obInsurance.InvoiceAmount = dataSet.InvoiceAmount; if (dataSet.InvouceCurrency != 0) { obInsurance.InvouceCurrency = dataSet.InvouceCurrency; } obInsurance.IncreasePercent = (decimal)dataSet.IncreasePercent; obInsurance.IncreaseAmount = (decimal)dataSet.IncreaseAmount; obInsurance.SumInsured = (decimal)dataSet.SumInsured; obInsurance.ExchangeRate = (decimal)dataSet.ExchangeRate; obInsurance.ExchangeRateCurrency = (byte)dataSet.ExchangeRateCurrency; obInsurance.ExchangedSumInsured = (decimal)dataSet.ExchangedSumInsured; obInsurance.MarinePremiumPercent = (decimal)dataSet.MarinePremiumPercent; obInsurance.MarinePremiumAmount = (decimal)dataSet.MarinePremiumAmount; obInsurance.DiscountPercent = (decimal)dataSet.DiscountPercent; obInsurance.DiscountAmount = (decimal)dataSet.DiscountAmount; obInsurance.WarSRCCPercent = (decimal)dataSet.WarSRCCPercent; obInsurance.WarSRCCPercentAmount = (decimal)dataSet.WarSRCCPercentAmount; obInsurance.NetPremium = (decimal)dataSet.NetPremium; obInsurance.VatPercent = (decimal)dataSet.VatPercent; obInsurance.VatAmount = (decimal)dataSet.VatAmount; obInsurance.StampDutyAmount = (decimal)dataSet.StampDutyAmount; obInsurance.GrandPremium = (decimal)dataSet.GrandPremium; obInsurance.RefundPercent = (decimal)dataSet.RefundPercent; obInsurance.RefundAmount = (decimal)dataSet.RefundAmount; obInsurance.PaidAmount = (decimal)dataSet.PaidAmount; obInsurance.RevisionNo = dataSet.RevisionNo; obInsurance.RevisionDate = DalCommon.SetDate(dataSet.RevisionDate == null?"": dataSet.RevisionDate.ToString()); obInsurance.ModifiedBy = Convert.ToInt32(Session["UserID"]); obInsurance.ApprovalAdvice = dataSet.ApprovalAdvice; if (dataSet.CIID != 0) { obInsurance.CIID = Convert.ToInt32(dataSet.CIID); } obInsurance.CINo = dataSet.CINo; if (!string.IsNullOrEmpty(dataSet.PIID)) { obInsurance.PIID = Convert.ToInt32(dataSet.PIID); } repo.LcmInsuranceRpository.Update(obInsurance); int flag = repo.Save(); if (flag == 1) { _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Updated Successfully."; } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Updated Faild."; } } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Data already confirmed. You can't update this."; } } catch (DbEntityValidationException e) { StringBuilder sb = new StringBuilder(); foreach (var eve in e.EntityValidationErrors) { sb.AppendLine(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State)); foreach (var ve in eve.ValidationErrors) { sb.AppendLine(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage)); } } throw new DbEntityValidationException(sb.ToString(), e); } return(Json(new { msg = _vmMsg })); }
// ##################### Search Start ############## public ActionResult GetLcmInsuranceInfo() { List <Lcm_Insurence> lst = new List <Lcm_Insurence>(); var lstLcmInsurance = repo.LcmInsuranceRpository.Get(); foreach (var item in lstLcmInsurance) { Lcm_Insurence obIns = new Lcm_Insurence(); obIns.InsuranceID = item.InsuranceID; obIns.InsuranceNo = item.InsuranceNo; var exist = (repo.LCOpeningRepository.Get(ob => ob.LCNo == item.LCNo)).ToList(); if (exist.Count() > 0) { obIns.LCNo = item.LCNo; obIns.LCDate = Convert.ToDateTime((from t in repo.LCOpeningRepository.Get(ob => ob.LCNo == item.LCNo) select t.LCDate).FirstOrDefault()).ToString("dd/MM/yyyy"); } else { obIns.LCNo = ""; obIns.LCDate = ""; } obIns.CoverNoteDate = item.CoverNoteDate; if (string.IsNullOrEmpty(item.CINo)) { obIns.CIDate = ""; obIns.CINo = ""; } else { obIns.CINo = item.CINo; obIns.CIDate = Convert.ToDateTime((from t in repo.CommercialInvoiceRepository.Get(ob => ob.CINo == (item.CINo == null ? "" : item.CINo)) select t.CIDate).FirstOrDefault()).ToString("dd/MM/yyyy"); } if (item.PIID != null) { obIns.PINo = repo.PRQ_ChemicalPIRepository.GetByID(Convert.ToInt32(item.PIID)).PINo; obIns.PIDate = Convert.ToDateTime(repo.PRQ_ChemicalPIRepository.GetByID(Convert.ToInt32(item.PIID)).PIDate).ToString("dd/MM/yyyy"); } else { obIns.PINo = ""; obIns.PIDate = ""; } obIns.PaidAmount = Convert.ToDecimal(item.PaidAmount) + Convert.ToDecimal(item.StampDutyAmount); obIns.RecordStatus = DalCommon.ReturnRecordStatus(item.RecordStatus); obIns.SupplierName = (from t in repo.PRQ_ChemicalPIRepository.Get() join t2 in repo.SysSupplierRepository.Get() on t.SupplierID equals t2.SupplierID where t.PIID == item.PIID select t2.SupplierName).FirstOrDefault(); lst.Add(obIns); } var lstData = from temp in lst select new { InsuranceID = temp.InsuranceID, InsuranceNo = temp.InsuranceNo, LCNo = temp.LCNo, LCDate = temp.LCDate, CoverNoteDate = temp.CoverNoteDate, CINo = temp.CINo, CIDate = temp.CIDate, PINo = temp.PINo, PIDate = temp.PIDate, SupplierName = temp.SupplierName, TotalPaidAmount = temp.PaidAmount, RecordStatus = temp.RecordStatus }; //obLCOpeningDAL.GetLCOpeningInfo(); return(Json(lstData.OrderByDescending(o => o.InsuranceID), JsonRequestBehavior.AllowGet)); }