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