public Int64 Update(Int64 SBillHead_Idno, DateTime?SBillHead_Date, string Prefix_No, Int64 SBill_No, int SBill_Type, Int64 Against, int Tax_Type, Int64 Prty_Idno, Int64 FromLoc_Idno, string Remark, Double Tot_Tax, Double Other_Amnt, Double RndOff_Amnt, Double Net_Amnt, int Disc_type, Double Disc_Amnt, Double Other_Charges, Double Tot_Amnt, Int64 Year_Idno, DateTime?Date_Updated, DataTable dtDetail) { Int64 BillHead_Idno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { tblSBillHead objBillHead = db.tblSBillHeads.Where(Bh => (Bh.SBillHead_Idno != SBillHead_Idno) && (Bh.SBill_No == SBill_No) && (Bh.Prefix_No == Prefix_No) && (Bh.SBill_Type == SBill_Type) && (Bh.FromLoc_Idno == FromLoc_Idno) && (Bh.Year_Idno == Year_Idno)).FirstOrDefault(); if (objBillHead == null) { tblSBillHead objBillHead1 = db.tblSBillHeads.Where(rh => rh.SBillHead_Idno == SBillHead_Idno).FirstOrDefault(); if (objBillHead1 != null) { objBillHead1.SBillHead_Date = SBillHead_Date; objBillHead1.Prefix_No = Prefix_No; objBillHead1.SBill_No = SBill_No; objBillHead1.SBill_Type = SBill_Type; objBillHead1.Bill_Against = Against; objBillHead1.Tax_Type = Tax_Type; objBillHead1.Prty_Idno = Prty_Idno; objBillHead1.FromLoc_Idno = FromLoc_Idno; objBillHead1.Remark = Remark; objBillHead1.Tot_Tax = Tot_Tax; objBillHead1.Disc_type = Disc_type; objBillHead1.Disc_Amnt = Disc_Amnt; objBillHead1.Tot_Amnt = Tot_Amnt; objBillHead1.Other_Amnt = Other_Amnt; objBillHead1.RndOff_Amnt = RndOff_Amnt; objBillHead1.Net_Amnt = Net_Amnt; objBillHead1.Date_Modified = Date_Updated; objBillHead1.Year_Idno = Year_Idno; db.SaveChanges(); BillHead_Idno = objBillHead1.SBillHead_Idno; if (BillHead_Idno > 0) { List <tblSBillDetl> lstBillDetl = db.tblSBillDetls.Where(obj => obj.SBillHead_Idno == BillHead_Idno).ToList(); if (lstBillDetl.Count > 0) { foreach (tblSBillDetl obj in lstBillDetl) { db.tblSBillDetls.DeleteObject(obj); } db.SaveChanges(); } foreach (DataRow row in dtDetail.Rows) { tblSBillDetl objBillDetl = new tblSBillDetl(); objBillDetl.SBillHead_Idno = SBillHead_Idno; objBillDetl.Item_Idno = Convert.ToInt64(row["SerialNoIdno"]); objBillDetl.Model_Idno = Convert.ToInt64(row["ModelIdNo"]); objBillDetl.Tyre_Category = Convert.ToInt64(row["TyreTypeIdNo"]); objBillDetl.Rate_Type = Convert.ToInt32(row["RateTypeIdno"]); objBillDetl.Qty = Convert.ToDouble(row["Quantity"]); objBillDetl.Item_Rate = Convert.ToDouble(row["Rate"]); objBillDetl.Item_Weigt = Convert.ToDouble(row["Weight"]); objBillDetl.Dis_Type = Convert.ToInt64(row["DiscountType"]); objBillDetl.Dis_Amnt = string.IsNullOrEmpty(row["Discount"].ToString()) ? 0 : Convert.ToDouble(row["Discount"]); objBillDetl.Amount = string.IsNullOrEmpty(row["Amount"].ToString()) ? 0 : Convert.ToDouble(row["Amount"]); objBillDetl.Item_Tax = string.IsNullOrEmpty(row["TaxAmnt"].ToString()) ? 0 : Convert.ToDouble(row["TaxAmnt"]); objBillDetl.Tax_Rate = string.IsNullOrEmpty(row["TaxRate"].ToString()) ? 0 : Convert.ToDouble(row["TaxRate"]); objBillDetl.Dis_Value = string.IsNullOrEmpty(row["DiscountValue"].ToString()) ? 0 : Convert.ToDouble(row["DiscountValue"]); objBillDetl.Item_Type = string.IsNullOrEmpty(row["ItemType"].ToString()) ? 0 : Convert.ToInt32(row["ItemType"]); objBillDetl.MatIss_Idno = string.IsNullOrEmpty(row["MatIss_Idno"].ToString()) ? 0 : Convert.ToInt32(row["MatIss_Idno"]); db.tblSBillDetls.AddObject(objBillDetl); db.SaveChanges(); } } } } else { BillHead_Idno = -1; } } catch (Exception Ex) { BillHead_Idno = 0; } } return(BillHead_Idno); }
public Int64 Insert(DateTime?SBillHead_Date, string Prefix_No, Int64 SBill_No, int SBill_Type, Int64 Against, int Tax_Type, Int64 Prty_Idno, Int64 FromLoc_Idno, string Remark, Double Tot_Tax, Double Other_Amnt, Double RndOff_Amnt, Double Net_Amnt, int Disc_type, Double Disc_Amnt, Double Other_Charges, Double Tot_Amnt, Int64 Year_Idno, DateTime?Date_Added, DataTable dtDetail) { Int64 SBillHead_Idno = 0; Int64 SBillDetailIdNo = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { tblSBillHead objBillHead = db.tblSBillHeads.Where(bill => (bill.SBill_No == SBill_No) && (bill.Year_Idno == Year_Idno) && (bill.Prefix_No == Prefix_No) && (bill.SBill_Type == SBill_Type) && (bill.FromLoc_Idno == FromLoc_Idno)).FirstOrDefault(); if (objBillHead == null) { objBillHead = new tblSBillHead(); objBillHead.SBillHead_Date = SBillHead_Date; objBillHead.Prefix_No = Prefix_No; objBillHead.SBill_No = SBill_No; objBillHead.SBill_Type = SBill_Type; objBillHead.Bill_Against = Against; objBillHead.Tax_Type = Tax_Type; objBillHead.Prty_Idno = Prty_Idno; objBillHead.FromLoc_Idno = FromLoc_Idno; objBillHead.Remark = Remark; objBillHead.Tot_Tax = Tot_Tax; objBillHead.Disc_type = Disc_type; objBillHead.Disc_Amnt = Disc_Amnt; objBillHead.Tot_Amnt = Tot_Amnt; objBillHead.Other_Amnt = Other_Amnt; objBillHead.RndOff_Amnt = RndOff_Amnt; objBillHead.Net_Amnt = Net_Amnt; objBillHead.Date_Added = Date_Added; objBillHead.Billed = false; objBillHead.Year_Idno = Year_Idno; db.tblSBillHeads.AddObject(objBillHead); db.SaveChanges(); SBillHead_Idno = objBillHead.SBillHead_Idno; if (SBillHead_Idno > 0) { foreach (DataRow dr in dtDetail.Rows) { tblSBillDetl objBillDetl = new tblSBillDetl(); objBillDetl.SBillHead_Idno = SBillHead_Idno; objBillDetl.Item_Idno = Convert.ToInt64(dr["SerialNoIdno"]); objBillDetl.Model_Idno = Convert.ToInt64(dr["ModelIdNo"]); objBillDetl.Tyre_Category = string.IsNullOrEmpty(Convert.ToString(dr["TyreTypeIdNo"])) ? 0 : Convert.ToInt64(dr["TyreTypeIdNo"]); objBillDetl.Rate_Type = Convert.ToInt32(dr["RateTypeIdno"]); objBillDetl.Qty = Convert.ToDouble(dr["Quantity"]); objBillDetl.Item_Rate = Convert.ToDouble(dr["Rate"]); objBillDetl.Item_Weigt = Convert.ToDouble(dr["Weight"]); objBillDetl.Dis_Type = Convert.ToInt64(dr["DiscountType"]); objBillDetl.Dis_Amnt = Convert.ToDouble(dr["Discount"]); objBillDetl.Amount = Convert.ToDouble(dr["Amount"]); objBillDetl.Item_Tax = Convert.ToDouble(dr["TaxAmnt"]); objBillDetl.Tax_Rate = Convert.ToDouble(dr["TaxRate"]); objBillDetl.Dis_Value = Convert.ToDouble(dr["DiscountValue"]); objBillDetl.Item_Type = Convert.ToInt32(dr["ItemType"]); objBillDetl.MatIss_Idno = Convert.ToInt32(dr["MatIss_Idno"]); objBillDetl.Claim_Idno = 0; db.tblSBillDetls.AddObject(objBillDetl); db.SaveChanges(); } } } else { return(SBillHead_Idno); } } catch (Exception ex) { return(-1); } return(SBillHead_Idno); } }