public Int64 Update(Int64 PBillHead_Idno, Int64 Year_Idno, Int64 Loc_Idno, DateTime?PBillHead_Date, string Prefix_No, Int64 PBillHead_No, int Pur_Type, Int64 Prty_Idno, int Bill_Type, string Remark, Double Tot_Amnt, int Disc_type, Double Disc_Amnt, Double Other_Amnt, Double RndOff_Amnt, Double Net_Amnt, DateTime?Date_Updated, DataTable dtDetail, Int64 LorryIdno, Double Discount) { Int64 BillHead_Idno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { tblPBillHead objBillHead = db.tblPBillHeads.Where(Bh => (Bh.PBillHead_Idno != PBillHead_Idno) && (Bh.PBillHead_No == PBillHead_No) && (Bh.Loc_Idno == Loc_Idno) && (Bh.Year_Idno == Year_Idno)).FirstOrDefault(); if (objBillHead == null) { tblPBillHead objBillHead1 = db.tblPBillHeads.Where(rh => rh.PBillHead_Idno == PBillHead_Idno).FirstOrDefault(); if (objBillHead1 != null) { objBillHead1.Year_Idno = Year_Idno; objBillHead1.Loc_Idno = Loc_Idno; objBillHead1.PBillHead_Date = PBillHead_Date; objBillHead1.Prefix_No = Prefix_No; objBillHead1.PBillHead_No = PBillHead_No; objBillHead1.Pur_Type = Pur_Type; objBillHead1.Prty_Idno = Prty_Idno; objBillHead1.Bill_Type = Bill_Type; objBillHead1.Remark = Remark; objBillHead1.Tot_Amnt = Tot_Amnt; objBillHead1.Disc_type = Disc_type; objBillHead1.Disc_Amnt = Disc_Amnt; objBillHead1.Other_Amnt = Other_Amnt; objBillHead1.RndOff_Amnt = RndOff_Amnt; objBillHead1.Net_Amnt = Net_Amnt; objBillHead1.Discount = Discount; objBillHead1.Date_Modified = Date_Updated; objBillHead1.LorryIdno = LorryIdno; db.SaveChanges(); BillHead_Idno = objBillHead1.PBillHead_Idno; if (BillHead_Idno > 0) { List <tblPBillDetl> lstBillDetl = db.tblPBillDetls.Where(obj => obj.PBillHead_Idno == BillHead_Idno).ToList(); if (lstBillDetl.Count > 0) { foreach (tblPBillDetl obj in lstBillDetl) { db.tblPBillDetls.DeleteObject(obj); } db.SaveChanges(); } foreach (DataRow row in dtDetail.Rows) { tblPBillDetl objBillDetl = new tblPBillDetl(); objBillDetl.PBillHead_Idno = Convert.ToInt64(BillHead_Idno); objBillDetl.Item_Idno = Convert.ToInt32(row["Item_Idno"]); objBillDetl.IGrp_Idno = Convert.ToInt64(row["IGrp_Idno"]); objBillDetl.Qty = Convert.ToDouble(row["Quantity"]); objBillDetl.Unit_Idno = Convert.ToInt32(row["Unit_Idno"]); objBillDetl.Rate_Type = Convert.ToInt32(row["Rate_TypeIdno"]); objBillDetl.Item_Rate = Convert.ToDouble(row["Rate"]); objBillDetl.Amount = Convert.ToDouble(row["Amount"]); objBillDetl.Tot_Weght = Convert.ToDouble(row["Weight"]); objBillDetl.Item_Tax = Convert.ToDouble(row["Vat"]); objBillDetl.Tax_Rate = Convert.ToDouble(row["TaxRate"]); objBillDetl.Disc_Type = Convert.ToDouble(row["DivDiscType"]); objBillDetl.Disc_Value = Convert.ToDouble(row["DivDiscValue"]); objBillDetl.Disc_Amnt = Convert.ToDouble(row["DivDiscAmnt"]); objBillDetl.Other_Amnt = Convert.ToDouble(row["DivDiscOthAmnt"]); objBillDetl.TyresizeIdno = string.IsNullOrEmpty(Convert.ToString(row["Tyresize_Idno"])) ? 0 : Convert.ToInt64(row["Tyresize_Idno"]); objBillDetl.SGST_Per = string.IsNullOrEmpty(Convert.ToString(row["SGST_Per"])) ? 0 : Convert.ToDouble(row["SGST_Per"]); objBillDetl.CGST_Per = string.IsNullOrEmpty(Convert.ToString(row["CGST_Per"])) ? 0 : Convert.ToDouble(row["CGST_Per"]); objBillDetl.IGST_Per = string.IsNullOrEmpty(Convert.ToString(row["IGST_Per"])) ? 0 : Convert.ToDouble(row["IGST_Per"]); objBillDetl.SGST_Amt = string.IsNullOrEmpty(Convert.ToString(row["SGST_Amt"])) ? 0 : Convert.ToDouble(row["SGST_Amt"]); objBillDetl.CGST_Amt = string.IsNullOrEmpty(Convert.ToString(row["CGST_Amt"])) ? 0 : Convert.ToDouble(row["CGST_Amt"]); objBillDetl.IGST_Amt = string.IsNullOrEmpty(Convert.ToString(row["IGST_Amt"])) ? 0 : Convert.ToDouble(row["IGST_Amt"]); db.tblPBillDetls.AddObject(objBillDetl); db.SaveChanges(); } } } } else { BillHead_Idno = -1; } } catch (Exception Ex) { BillHead_Idno = 0; } } return(BillHead_Idno); }
public Int64 Insert(Int64 Year_Idno, Int64 Loc_Idno, DateTime?PBillHead_Date, string Prefix_No, Int64 PBillHead_No, int Pur_Type, Int64 Prty_Idno, int Bill_Type, string Remark, Double Tot_Amnt, int Disc_type, Double Disc_Amnt, Double Other_Amnt, Double RndOff_Amnt, Double Net_Amnt, DateTime?Date_Added, DataTable dtDetail, Int64 LorryIdno, Double Discount) { Int64 PBillHead_Idno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { tblPBillHead objBillHead = db.tblPBillHeads.Where(bill => (bill.PBillHead_No == PBillHead_No) && (bill.Year_Idno == Year_Idno) && (bill.Loc_Idno == Loc_Idno)).FirstOrDefault(); if (objBillHead == null) { objBillHead = new tblPBillHead(); objBillHead.Year_Idno = Year_Idno; objBillHead.Loc_Idno = Loc_Idno; objBillHead.PBillHead_Date = PBillHead_Date; objBillHead.Prefix_No = Prefix_No; objBillHead.PBillHead_No = PBillHead_No; objBillHead.Pur_Type = Pur_Type; objBillHead.Prty_Idno = Prty_Idno; objBillHead.Bill_Type = Bill_Type; objBillHead.Remark = Remark; objBillHead.Tot_Amnt = Tot_Amnt; objBillHead.Disc_type = Disc_type; objBillHead.Disc_Amnt = Disc_Amnt; objBillHead.Other_Amnt = Other_Amnt; objBillHead.RndOff_Amnt = RndOff_Amnt; objBillHead.Net_Amnt = Net_Amnt; objBillHead.Date_Added = Date_Added; objBillHead.LorryIdno = LorryIdno; objBillHead.Discount = Discount; objBillHead.Billed = false; db.tblPBillHeads.AddObject(objBillHead); db.SaveChanges(); PBillHead_Idno = objBillHead.PBillHead_Idno; if (PBillHead_Idno > 0) { foreach (DataRow dr in dtDetail.Rows) { tblPBillDetl objBillDetl = new tblPBillDetl(); objBillDetl.PBillHead_Idno = PBillHead_Idno; objBillDetl.Item_Idno = Convert.ToInt64(dr["Item_Idno"]); objBillDetl.IGrp_Idno = Convert.ToInt64(dr["IGrp_Idno"]); objBillDetl.Qty = Convert.ToDouble(dr["Quantity"]); objBillDetl.Unit_Idno = Convert.ToInt64(dr["Unit_Idno"]); objBillDetl.Rate_Type = Convert.ToInt32(dr["Rate_TypeIdno"]); objBillDetl.Item_Rate = Convert.ToDouble(dr["Rate"]); objBillDetl.Amount = Convert.ToDouble(dr["Amount"]); objBillDetl.Tot_Weght = Convert.ToDouble(dr["Weight"]); objBillDetl.Item_Tax = Convert.ToDouble(dr["Vat"]); objBillDetl.Tax_Rate = Convert.ToDouble(dr["TaxRate"]); objBillDetl.Disc_Type = Convert.ToDouble(dr["DivDiscType"]); objBillDetl.Disc_Value = Convert.ToDouble(dr["DivDiscValue"]); objBillDetl.Disc_Amnt = Convert.ToDouble(dr["DivDiscAmnt"]); objBillDetl.Other_Amnt = Convert.ToDouble(dr["DivDiscOthAmnt"]); objBillDetl.TyresizeIdno = Convert.ToInt64(dr["Tyresize_Idno"]); objBillDetl.SGST_Per = Convert.ToDouble(dr["SGST_Per"]); objBillDetl.CGST_Per = Convert.ToDouble(dr["CGST_Per"]); objBillDetl.IGST_Per = Convert.ToDouble(dr["IGST_Per"]); objBillDetl.SGST_Amt = Convert.ToDouble(dr["SGST_Amt"]); objBillDetl.CGST_Amt = Convert.ToDouble(dr["CGST_Amt"]); objBillDetl.IGST_Amt = Convert.ToDouble(dr["IGST_Amt"]); db.tblPBillDetls.AddObject(objBillDetl); db.SaveChanges(); } } } else { return(PBillHead_Idno); } } catch (Exception ex) { return(-1); } return(PBillHead_Idno); } }