//public IList FillPartyDetail(Int64 PartyIdno) //{ // using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) // { // var lst = (from Acnt in db.AcntMasts // join ADetl in db.AcntDetls on Acnt.Acnt_Idno equals ADetl.Acnt_Idno into AD // from ACD in AD.DefaultIfEmpty() // join CM in db.tblCityMasters on ACD.CityId equals CM.City_Idno into CM // from CMD in CM.DefaultIfEmpty() // join StM in db.tblStateMasters on ACD.StateId equals StM.State_Idno into StM // from SMD in StM.DefaultIfEmpty() // where Acnt.Acnt_Idno == PartyIdno // select // new // { // Acnt.Acnt_Name, // ACD.Temp_Adrs, // ACD.Temp_Adrs2, // CityName = CMD.Name, // ACD.Prty_Pin, // StateName = SMD.Name // } // ).ToList(); // return lst; // } //} public tblChlnBookHead SelectChallanType(Int64 ChlnID) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblChlnBookHead obj = (from t in db.tblChlnBookHeads where t.Chln_Idno == ChlnID select t).FirstOrDefault(); return(obj); } }
private void PostIntoAccount(long chlnidno, string GrType) { ChlnBookingDAL objChln = new ChlnBookingDAL(); tblChlnBookHead chlnBookhead = objChln.selectHead(chlnidno, GrType); if (this.RecPostIntoAccounts(Convert.ToDouble(chlnBookhead.Adv_Amnt), Convert.ToInt32(chlnidno), "CBU", 0, 0, 0, 0, 0, Convert.ToInt32(chlnBookhead.Year_Idno), Convert.ToInt32(chlnBookhead.Truck_Idno), Convert.ToString(chlnBookhead.Inst_Dt), (string.IsNullOrEmpty(chlnBookhead.Inst_No.ToString()) ? "0" : Convert.ToString(chlnBookhead.Inst_No)), (string.IsNullOrEmpty(chlnBookhead.Driver_Idno.ToString()) ? 0 : Convert.ToInt32(chlnBookhead.Driver_Idno)), Convert.ToDateTime(chlnBookhead.Chln_Date).ToString("dd-MM-yyyy"), Convert.ToInt32(chlnBookhead.Chln_No), (string.IsNullOrEmpty(chlnBookhead.RcptType_Idno.ToString()) ? 0 : Convert.ToInt32(chlnBookhead.RcptType_Idno)), (string.IsNullOrEmpty(chlnBookhead.Bank_Idno.ToString()) ? 0 : Convert.ToInt32(chlnBookhead.Bank_Idno)), Convert.ToDouble(chlnBookhead.Gross_Amnt), Convert.ToDouble(chlnBookhead.Commsn_Amnt), Convert.ToDouble(chlnBookhead.TDSTax_Amnt), (string.IsNullOrEmpty(chlnBookhead.Diesel_Amnt.ToString()) ? 0.00 : Convert.ToDouble(chlnBookhead.Diesel_Amnt))) == true) { // tScope.Complete(); tScope.Dispose(); objChln.UpdateIsPosting(chlnidno); } }
public int Delete(Int64 HeadId) { int value = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { clsAccountPosting objclsAccountPosting = new clsAccountPosting(); tblChlnBookHead CH = db.tblChlnBookHeads.Where(h => h.Chln_Idno == HeadId).FirstOrDefault(); List <tblChlnBookDetl> CD = db.tblChlnBookDetls.Where(d => d.ChlnBookHead_Idno == HeadId).ToList(); if (CH != null) { foreach (var d in CD) { TblGrHead objTblGrHead = (from obj in db.TblGrHeads where obj.GR_Idno == d.GR_Idno select obj).FirstOrDefault(); objTblGrHead.Chln_Idno = 0; db.SaveChanges(); } foreach (var d in CD) { db.tblChlnBookDetls.DeleteObject(d); db.SaveChanges(); } db.tblChlnBookHeads.DeleteObject(CH); TblGrHead GrHEad = db.TblGrHeads.Where(rd => rd.Chln_Idno == Convert.ToInt32(HeadId)).FirstOrDefault(); List <TblGrDetl> GrDetl = db.TblGrDetls.Where(rd => rd.GrHead_Idno == GrHEad.GR_Idno).ToList(); foreach (TblGrDetl rgd in GrDetl) { db.TblGrDetls.DeleteObject(rgd); db.SaveChanges(); } db.TblGrHeads.DeleteObject(GrHEad); db.SaveChanges(); Int64 intValue = objclsAccountPosting.DeleteAccountPosting(HeadId, "CB"); db.SaveChanges(); if (intValue > 0) { value = 1; } } } return(value); }
public Int64 Insert(tblChlnBookHead obj, DataTable Dttemp, string GrHeadsIdno) { Int64 chlnBookId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblChlnBookHead CHead = new tblChlnBookHead(); tblChlnBookHead RH = db.tblChlnBookHeads.Where(rh => (rh.Chln_No == obj.Chln_No) && (rh.Year_Idno == obj.Year_Idno) && (rh.BaseCity_Idno == obj.BaseCity_Idno) && rh.Chln_type == 2).FirstOrDefault(); if (RH != null) { chlnBookId = -1; } else { db.tblChlnBookHeads.AddObject(obj); db.SaveChanges(); chlnBookId = obj.Chln_Idno; string[] GrIdnos = GrHeadsIdno.Split(new string[] { "," }, StringSplitOptions.None); if (Dttemp.Rows.Count > 0) { for (int i = 0; i < Dttemp.Rows.Count; i++) { tblChlnBookDetl objtblChlnBookDetl = new tblChlnBookDetl(); objtblChlnBookDetl.GR_Idno = Convert.ToInt32(GrIdnos[i + 1]); objtblChlnBookDetl.DelvryPlce_Idno = Convert.ToInt32(Dttemp.Rows[i]["ToCityIdno"]); objtblChlnBookDetl.ChlnBookHead_Idno = chlnBookId; db.tblChlnBookDetls.AddObject(objtblChlnBookDetl); db.SaveChanges(); } } if (Dttemp.Rows.Count > 0) { for (int i = 0; i < Dttemp.Rows.Count; i++) { Int32 GrIdno = 0; GrIdno = Convert.ToInt32(GrIdnos[i + 1]); TblGrHead objTblGrHead = (from obj1 in db.TblGrHeads where obj1.GR_Idno == GrIdno select obj1).FirstOrDefault(); objTblGrHead.Chln_Idno = chlnBookId; db.SaveChanges(); } } } } return(chlnBookId); }
public Int64 Insert(tblChlnBookHead ChallanBookHead, List <tblChlnBookDetl> ChallanBookDetl) { Int64 ChallanBookHeadId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); using (DbTransaction dbTran = db.Connection.BeginTransaction()) { try { tblChlnBookHead RH = db.tblChlnBookHeads.Where(rh => rh.Chln_No == ChallanBookHead.Chln_No).FirstOrDefault(); if (RH != null) { ChallanBookHeadId = -1; } else { db.tblChlnBookHeads.AddObject(ChallanBookHead); db.SaveChanges(); ChallanBookHeadId = ChallanBookHead.Chln_Idno; if (ChallanBookDetl.Count > 0) { foreach (tblChlnBookDetl rgd in ChallanBookDetl) { rgd.ChlnBookHead_Idno = ChallanBookHeadId; db.tblChlnBookDetls.AddObject(rgd); db.SaveChanges(); } dbTran.Commit(); } } } catch { dbTran.Rollback(); } } } return(ChallanBookHeadId); }
public int DeleteChallanDetail(Int64 HeadId) { int value = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblChlnBookHead rgh = db.tblChlnBookHeads.Where(h => h.Chln_Idno == HeadId).FirstOrDefault(); List <tblChlnBookDetl> rgd = db.tblChlnBookDetls.Where(d => d.ChlnBookHead_Idno == HeadId).ToList(); if (rgh != null) { foreach (var d in rgd) { db.tblChlnBookDetls.DeleteObject(d); db.SaveChanges(); } db.tblChlnBookHeads.DeleteObject(rgh); db.SaveChanges(); value = 1; } } return(value); }
private void Populate(Int64 HeadId) { ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL(); tblChlnBookHead chlnBookhead = obj.selectHead(HeadId); ddldateRange.SelectedValue = Convert.ToString(chlnBookhead.Year_Idno); ddldateRange_SelectedIndexChanged(null, null); ddldateRange.Enabled = false; txtchallanNo.Text = chlnBookhead.Chln_No; txtDate.Text = Convert.ToDateTime(chlnBookhead.Chln_Date).ToString("dd-MM-yyyy"); ddlTranspoter.SelectedValue = Convert.ToString(chlnBookhead.Transprtr_Idno); txtchlnRef.Text = Convert.ToString(chlnBookhead.Ref_No); ddlTruckNo.SelectedValue = Convert.ToString(chlnBookhead.Truck_Idno); ddlTruckNo_SelectedIndexChanged(null, null); txtgrossAmnt.Text = Convert.ToDouble(chlnBookhead.Gross_Amnt).ToString("N2"); txtKattAmnt.Text = Convert.ToDouble(chlnBookhead.Other_Amnt).ToString("N2"); txtNetAmnt.Text = Convert.ToDouble(chlnBookhead.Net_Amnt).ToString("N2"); hidWorkType.Value = Convert.ToString(chlnBookhead.Work_type); DdlfromcityHead.SelectedValue = Convert.ToString(chlnBookhead.BaseCity_Idno); dtTemp = obj.selectDetl(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddldateRange.SelectedValue), HeadId); ViewState["dt"] = dtTemp; this.BindGridT(); // imgSearch.Enabled = false; Int64 value = 0; value = obj.CheckBilled(HeadId, ApplicationFunction.ConnectionString()); if (value > 0) { lnkbtnSave.Enabled = false; } else { lnkbtnSave.Enabled = true; } obj = null; }
public int Delete(Int64 HeadId) { int value = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblTripHead CH = db.tblTripHeads.Where(h => h.Trip_Idno == HeadId).FirstOrDefault(); List <tblChlnBookDetl> CD = db.tblChlnBookDetls.Where(d => d.ChlnBookHead_Idno == HeadId).ToList(); List <tblTripChlnDetl> TD = db.tblTripChlnDetls.Where(d => d.TripHead_Idno == HeadId).ToList(); if (CH != null) { List <tblTripChlnDetl> ChlnDetl = db.tblTripChlnDetls.Where(rd => rd.TripHead_Idno == HeadId).ToList(); foreach (var d in ChlnDetl) { db.tblTripChlnDetls.DeleteObject(d); db.SaveChanges(); } List <tblTripFuelDetl> FuelDetl = db.tblTripFuelDetls.Where(rd => rd.TripHead_Idno == HeadId).ToList(); foreach (var d in FuelDetl) { db.tblTripFuelDetls.DeleteObject(d); db.SaveChanges(); } List <tblTripExpDetl> ExpDetl = db.tblTripExpDetls.Where(rd => rd.TripHead_Idno == HeadId).ToList(); foreach (var d in ExpDetl) { db.tblTripExpDetls.DeleteObject(d); db.SaveChanges(); } List <tblTripTollDetl> TollDetl = db.tblTripTollDetls.Where(rd => rd.TripHead_Idno == HeadId).ToList(); foreach (var d in TollDetl) { db.tblTripTollDetls.DeleteObject(d); db.SaveChanges(); } foreach (var d in TD) { tblChlnBookHead objChlnHead = (from obj in db.tblChlnBookHeads where obj.Chln_Idno == d.Chln_Idno select obj).FirstOrDefault(); objChlnHead.Trip_Billed = false; db.SaveChanges(); } db.tblTripHeads.DeleteObject(CH); db.SaveChanges(); int intValue = 1; if (intValue > 0) { value = 1; } } } } catch (Exception ex) { value = -1; } return(value); }
protected void lnkbtnSave_OnClick(object sender, EventArgs e) { #region Validation Messages for Challan Details if (ddlTranspoter.SelectedIndex == 0) { this.ShowMessage("Please select Transporter."); ddlTranspoter.Focus(); return; } if (ddlTruckNo.SelectedIndex == 0) { this.ShowMessage("Please select Truck No."); ddlTruckNo.Focus(); return; } if (txtchlnRef.Text == "") { this.ShowMessage("Please Enter Challan Ref.No ."); ddlTruckNo.Focus(); return; } string msg = ""; dtTemp = (DataTable)ViewState["dt"]; if (dtTemp != null) { if (dtTemp.Rows.Count <= 0) { ShowMessage("Please enter details"); return; } } if (grdMain.Rows.Count <= 0) { ShowMessage("Please enter details"); return; } #endregion #region Declare Input Variables for Challan Details //string strMsg = string.Empty; //Int64 intGrPrepIdno = 0; //Int32 YearIdno = Convert.ToInt32(ddldateRange.SelectedValue) == -1 ? 0 : Convert.ToInt32(ddldateRange.SelectedValue); //DateTime strChallanDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text.Trim().ToString())); //Int64 intChallanNo = string.IsNullOrEmpty(txtchallanNo.Text.Trim()) ? 0 : Convert.ToInt64(txtchallanNo.Text.Trim()); //Int32 intTranspoter = string.IsNullOrEmpty(ddlTranspoter.SelectedValue) ? 0 : Convert.ToInt32(ddlTranspoter.SelectedValue); //Int32 TruckNoIdno = string.IsNullOrEmpty(ddlTruckNo.SelectedValue) ? 0 : Convert.ToInt32(ddlTruckNo.SelectedValue); //Int32 strChlnRefno = string.IsNullOrEmpty(txtchlnRef.Text) ? 0 : Convert.ToInt32(txtchlnRef.Text); //DateTime? dtInstDate; //if (txtInstDate.Text == "") //{ // dtInstDate = null; //} //else //{ // dtInstDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInstDate.Text)); //} #endregion #region Insert/Update with Transaction using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) { string intGrPrepIdno = ""; string ChlnNo = txtchallanNo.Text; Int32 TrunckIdno = Convert.ToInt32(ddlTruckNo.SelectedValue); Int32 YearIdno = Convert.ToInt32((ddldateRange.SelectedIndex < 0) ? "0" : ddldateRange.SelectedValue); GRPrepDAL objDAL = new GRPrepDAL(); isTBBRate = objDAL.SelectTBBRate(); tblUserPref userpref = objDAL.selectuserpref(); itruckcitywise = Convert.ToInt32(userpref.Work_Type); DataTable dtDetail = (DataTable)ViewState["dt"]; try { ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL(); tblChlnBookHead objtblChlnBookHead = new tblChlnBookHead(); objtblChlnBookHead.Chln_No = txtchallanNo.Text; objtblChlnBookHead.Chln_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text)); objtblChlnBookHead.BaseCity_Idno = Convert.ToInt32((DdlfromcityHead.SelectedIndex <= 0) ? "0" : DdlfromcityHead.SelectedValue); objtblChlnBookHead.DelvryPlc_Idno = Convert.ToInt32(0); objtblChlnBookHead.Truck_Idno = Convert.ToInt32((ddlTruckNo.SelectedIndex <= 0) ? "0" : ddlTruckNo.SelectedValue); objtblChlnBookHead.Year_Idno = Convert.ToInt32((ddldateRange.SelectedIndex < 0) ? "0" : ddldateRange.SelectedValue); objtblChlnBookHead.Driver_Idno = Convert.ToInt32(1); objtblChlnBookHead.Delvry_Instrc = ""; objtblChlnBookHead.Inv_Idno = 0; objtblChlnBookHead.Gross_Amnt = Convert.ToDouble(txtgrossAmnt.Text); objtblChlnBookHead.Commsn_Amnt = Convert.ToDouble(0.00); objtblChlnBookHead.Transprtr_Idno = Convert.ToInt32(ddlTranspoter.SelectedValue); objtblChlnBookHead.Chln_type = 2; objtblChlnBookHead.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text); objtblChlnBookHead.Other_Amnt = Convert.ToDouble(txtKattAmnt.Text); objtblChlnBookHead.Work_type = Convert.ToInt32(hidWorkType.Value); objtblChlnBookHead.Ref_No = Convert.ToString(txtchlnRef.Text); objtblChlnBookHead.Adv_Amnt = Convert.ToDouble(0.00); objtblChlnBookHead.RcptType_Idno = Convert.ToInt32(1); objtblChlnBookHead.Bank_Idno = Convert.ToInt32(0); objtblChlnBookHead.Inst_No = Convert.ToInt32(0); objtblChlnBookHead.Inst_Dt = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text)); objtblChlnBookHead.Date_Added = Convert.ToDateTime(DateTime.Now); Int64 value = 0; if (string.IsNullOrEmpty(hidid.Value) == true) { if (grdMain.Rows.Count > 0 && dtTemp != null && dtTemp.Rows.Count > 0) { ChlnBookingCrsngDAL obj1 = new ChlnBookingCrsngDAL(); intGrPrepIdno = obj1.InsertGR(ChlnNo, TrunckIdno, YearIdno, isTBBRate, itruckcitywise, dtDetail); obj1 = null; } value = obj.Insert(objtblChlnBookHead, dtTemp, intGrPrepIdno); // obj = null; } else { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); Int32 ChlnIdno = Convert.ToInt32(hidid.Value); TblGrHead GrHEad = db.TblGrHeads.Where(rd => rd.Chln_Idno == ChlnIdno).FirstOrDefault(); List <TblGrDetl> GrDetl = db.TblGrDetls.Where(rd => rd.GrHead_Idno == GrHEad.GR_Idno).ToList(); foreach (TblGrDetl rgd in GrDetl) { db.TblGrDetls.DeleteObject(rgd); db.SaveChanges(); } db.TblGrHeads.DeleteObject(GrHEad); db.SaveChanges(); db.Connection.Close(); } if (grdMain.Rows.Count > 0 && dtTemp != null && dtTemp.Rows.Count > 0) { ChlnBookingCrsngDAL obj1 = new ChlnBookingCrsngDAL(); intGrPrepIdno = obj1.InsertGR(ChlnNo, TrunckIdno, YearIdno, isTBBRate, itruckcitywise, dtDetail); obj1 = null; } value = obj.Update(objtblChlnBookHead, Convert.ToInt32(hidid.Value), dtTemp, intGrPrepIdno); } if (value > 0) { tScope.Complete(); } if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false)) { ShowMessage("Record Update successfully"); Response.Redirect("ChlnBookingCrsng.aspx", false); } else if (value == -1) { ShowMessage("Challan No Already Exist"); } else { ShowMessage("Record Not Update"); } if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == true)) { ShowMessage("Record saved Successfully "); Response.Redirect("ChlnBookingCrsng.aspx", false); } else if (value == -1) { tScope.Dispose(); ShowMessage("Challan No Already Exist"); } else { ShowMessage("Record Not saved Successfully "); } } catch (Exception Ex) { tScope.Dispose(); } #endregion } }
public Int64 Update(tblChlnBookHead obj, Int32 ChlnIdno, DataTable Dttemp, string GrHeadsIdno) { Int64 chlnBoookId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); using (DbTransaction dbTran = db.Connection.BeginTransaction()) { try { tblChlnBookHead CH = db.tblChlnBookHeads.Where(rh => rh.Chln_No == obj.Chln_No && (rh.Chln_Idno != ChlnIdno) && (rh.Year_Idno == obj.Year_Idno) && (rh.BaseCity_Idno == obj.BaseCity_Idno) && (rh.Chln_type == 2)).FirstOrDefault(); if (CH != null) { chlnBoookId = -1; } else { tblChlnBookHead TBH = db.tblChlnBookHeads.Where(rh => rh.Chln_Idno == ChlnIdno).FirstOrDefault(); if (TBH != null) { TBH.Chln_No = obj.Chln_No; TBH.Chln_Date = obj.Chln_Date; TBH.BaseCity_Idno = obj.BaseCity_Idno; TBH.DelvryPlc_Idno = obj.DelvryPlc_Idno; TBH.Truck_Idno = obj.Truck_Idno; TBH.Year_Idno = obj.Year_Idno; TBH.Chln_type = obj.Chln_type; TBH.Driver_Idno = obj.Driver_Idno; TBH.Delvry_Instrc = obj.Delvry_Instrc; TBH.Inv_Idno = obj.Inv_Idno; TBH.Gross_Amnt = obj.Gross_Amnt; TBH.Commsn_Amnt = obj.Commsn_Amnt; TBH.Other_Amnt = obj.Other_Amnt; TBH.Net_Amnt = obj.Net_Amnt; TBH.Work_type = obj.Work_type; TBH.Adv_Amnt = obj.Adv_Amnt; TBH.RcptType_Idno = obj.RcptType_Idno; TBH.Inst_No = obj.Inst_No; TBH.Inst_Dt = obj.Inst_Dt; TBH.Bank_Idno = obj.Bank_Idno; db.SaveChanges(); chlnBoookId = TBH.Chln_Idno; List <tblChlnBookDetl> ChlnDetl = db.tblChlnBookDetls.Where(rd => rd.ChlnBookHead_Idno == ChlnIdno).ToList(); foreach (tblChlnBookDetl rgd in ChlnDetl) { db.tblChlnBookDetls.DeleteObject(rgd); db.SaveChanges(); } //foreach (tblChlnBookDetl rgd in ChlnDetl) //{ // rgd.ChlnBookHead_Idno = chlnBoookId; // db.tblChlnBookDetls.AddObject(rgd); // db.SaveChanges(); //} string[] GrIdnos = GrHeadsIdno.Split(new string[] { "," }, StringSplitOptions.None); if (Dttemp.Rows.Count > 0) { for (int i = 0; i < Dttemp.Rows.Count; i++) { tblChlnBookDetl objtblChlnBookDetl = new tblChlnBookDetl(); objtblChlnBookDetl.GR_Idno = Convert.ToInt32(GrIdnos[i + 1]); objtblChlnBookDetl.DelvryPlce_Idno = Convert.ToInt32(Dttemp.Rows[i]["ToCityIdno"]); objtblChlnBookDetl.ChlnBookHead_Idno = ChlnIdno; db.tblChlnBookDetls.AddObject(objtblChlnBookDetl); db.SaveChanges(); } } if (Dttemp.Rows.Count > 0) { for (int i = 0; i < Dttemp.Rows.Count; i++) { Int32 GrIdno = 0; GrIdno = Convert.ToInt32(GrIdnos[i + 1]); TblGrHead objTblGrHead = (from obj1 in db.TblGrHeads where obj1.GR_Idno == GrIdno select obj1).FirstOrDefault(); objTblGrHead.Chln_Idno = ChlnIdno; db.SaveChanges(); } } dbTran.Commit(); } } } catch { dbTran.Rollback(); } } } return(chlnBoookId); }
public Int64 Insert(tblInvGenHead obj, DataTable DtTemp, string GrType) { Int64 InvIdno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblChlnBookHead CHead = new tblChlnBookHead(); db.Connection.Open(); using (DbTransaction dbTran = db.Connection.BeginTransaction()) { try { tblInvGenHead RH = db.tblInvGenHeads.Where(rh => rh.Inv_No == obj.Inv_No && rh.Inv_prefix == obj.Inv_prefix && rh.BaseCity_Idno == obj.BaseCity_Idno && rh.Year_Idno == obj.Year_Idno).FirstOrDefault(); if (RH != null) { InvIdno = -1; } else { obj.Date_Added = DateTime.Now; obj.Date_Modified = DateTime.Now; db.tblInvGenHeads.AddObject(obj); db.SaveChanges(); InvIdno = obj.Inv_Idno; if (DtTemp.Rows.Count > 0) { foreach (DataRow Dr in DtTemp.Rows) { tblInvGenDetl objtblInvGenDetl = new tblInvGenDetl(); objtblInvGenDetl.InvGenHead_Idno = InvIdno; objtblInvGenDetl.GR_Idno = Convert.ToInt64(Dr["GR_Idno"]); objtblInvGenDetl.Item_Idno = Convert.ToInt64(Dr["Item_Idno"]); objtblInvGenDetl.Item_Rate = Convert.ToDouble(Dr["Item_Rate"]); objtblInvGenDetl.Unit_Idno = Convert.ToInt64(Dr["Unit_Idno"]); objtblInvGenDetl.Amount = Convert.ToDouble(Dr["Amount"]); objtblInvGenDetl.Wayges = Convert.ToDouble(Dr["Wayges"]); objtblInvGenDetl.Net_Amnt = Convert.ToDouble(Dr["Net_Amnt"]); objtblInvGenDetl.Other_Amnt = Convert.ToDouble(Dr["Other_Amnt"]); objtblInvGenDetl.ServTax_Amnt = Convert.ToDouble(Dr["ServTax_Amnt"]); objtblInvGenDetl.ServTax_Perc = Convert.ToDouble(Dr["ServTax_Perc"]); objtblInvGenDetl.ServTax_Valid = Convert.ToDouble(Dr["ServTax_Valid"]); objtblInvGenDetl.SwchBrtTax_Amnt = Convert.ToDouble(Dr["SwchBrtTax_Amnt"]); objtblInvGenDetl.KisanTax_Amnt = Convert.ToDouble(Dr["KisanKalyan_Amnt"]); //#GST objtblInvGenDetl.SGST_Amt = Convert.ToDouble(Dr["SGST_Amt"]); objtblInvGenDetl.CGST_Amt = Convert.ToDouble(Dr["CGST_Amt"]); objtblInvGenDetl.IGST_Amt = Convert.ToDouble(Dr["IGST_Amt"]); objtblInvGenDetl.Annexure_No = Convert.ToString(Dr["Annexure_No"]); db.tblInvGenDetls.AddObject(objtblInvGenDetl); db.SaveChanges(); } } if (DtTemp.Rows.Count > 0) { if (GrType == "GR") { foreach (DataRow Dr in DtTemp.Rows) { Int32 GrIdno = Convert.ToInt32(Dr["GR_Idno"]); TblGrHead objTblGrHead = (from obj1 in db.TblGrHeads where obj1.GR_Idno == GrIdno select obj1).FirstOrDefault(); objTblGrHead.Billed = true; db.SaveChanges(); } } else { foreach (DataRow Dr in DtTemp.Rows) { Int32 GrIdno = Convert.ToInt32(Dr["GR_Idno"]); tblGrRetailerHead objTblGrHead = (from obj1 in db.tblGrRetailerHeads where obj1.GRRetHead_Idno == GrIdno select obj1).FirstOrDefault(); objTblGrHead.Billed = true; db.SaveChanges(); } } } dbTran.Commit(); } } catch { dbTran.Rollback(); } } return(InvIdno); } }