public void Update(List <EntityinsuranceClaimDetails> lst)
{
try
{
foreach (EntityinsuranceClaimDetails item in lst)
{
tblCompanyClaimDetail objsal = new tblCompanyClaimDetail();
objsal = (from tbl in objData.tblCompanyClaimDetails
where tbl.ComClaimDetailId == item.ComClaimDetailId &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
if (objsal != null)
{
objsal.BillNo = item.BillNo;
objsal.BillType = item.BillType;
objsal.BillDate = item.BillDate;
objsal.BillAmount = item.BillAmount;
objsal.IsDelete = item.IsDelete;
}
else
{
objsal = new tblCompanyClaimDetail()
{
BillNo = item.BillNo, BillAmount = item.BillAmount, BillType = item.BillType, BillDate = item.BillDate, IsOtherBill = item.IsOtherBill, ComClaimId = Convert.ToInt32(item.ComClaimId)
};
objData.tblCompanyClaimDetails.InsertOnSubmit(objsal);
}
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public int?Save(tblCompanyClaim tblins, List <EntityinsuranceClaimDetails> lst)
{
int?ComClaimId = 0;
try
{
objData.STP_Insert_tblCompanyClaim(Convert.ToInt32(tblins.AdmitId), Convert.ToInt32(tblins.CompanyId), Convert.ToDateTime(tblins.ClaimDate), Convert.ToDecimal(tblins.Total), tblins.IsApproved, ref ComClaimId);
foreach (EntityinsuranceClaimDetails item in lst)
{
tblCompanyClaimDetail tbl = new tblCompanyClaimDetail()
{
BillNo = item.BillNo, BillAmount = item.BillAmount, BillType = item.BillType, BillDate = item.BillDate, IsOtherBill = item.IsOtherBill, ComClaimId = Convert.ToInt32(ComClaimId)
};
objData.tblCompanyClaimDetails.InsertOnSubmit(tbl);
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
return(ComClaimId);
}
