public Boolean UpdateGrHeadForKm(string ConString, Int64 GrId, double Frmkm, double Tokm, double Totkm) { try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { TblGrHead objtblGrhead = (from obj in db.TblGrHeads where obj.GR_Idno == GrId select obj).FirstOrDefault(); if (objtblGrhead != null) { objtblGrhead.From_KM = Frmkm; objtblGrhead.To_KM = Tokm; objtblGrhead.Tot_KM = Totkm; db.SaveChanges(); return(true); } else { return(false); } } } catch (Exception EX) { return(false); } }
public Int64 Updatebilled(Int64 GrIdno) { Int64 GrHeadId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); using (DbTransaction dbTran = db.Connection.BeginTransaction()) { try { TblGrHead TBH = db.TblGrHeads.Where(rh => rh.GR_Idno == GrIdno).FirstOrDefault(); if (TBH != null) { TBH.Billed = false; db.SaveChanges(); //GrHeadId = TBH.GR_Idno; //List<tblInvGenDetl> InvDetl = db.tblInvGenDetls.Where(rd => rd.GR_Idno == GrIdno).ToList(); //foreach (tblInvGenDetl rgd in InvDetl) //{ // db.tblInvGenDetls.DeleteObject(rgd); // db.SaveChanges(); //} dbTran.Commit(); } } // } catch { dbTran.Rollback(); } } } return(GrHeadId); }
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 int DeleteGR(Int64 HeadId) { clsAccountPosting objclsAccountPosting = new clsAccountPosting(); int value = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { TblGrHead qth = db.TblGrHeads.Where(h => h.GR_Idno == HeadId).FirstOrDefault(); List <TblGrDetl> qtd = db.TblGrDetls.Where(d => d.GrHead_Idno == HeadId).ToList(); if (qth != null) { foreach (var d in qtd) { db.TblGrDetls.DeleteObject(d); db.SaveChanges(); } db.TblGrHeads.DeleteObject(qth); Int64 intValue = objclsAccountPosting.DeleteAccountPosting(HeadId, "GR"); db.SaveChanges(); value = 1; } } return(value); }
public Int64 UpdateMtrlRcptHOHead(tblChlnDelvHead objMtrlRcptHOHead, DataTable DtTemp, Int32 HeadIdno) { Int64 RcptHeadIdno = HeadIdno; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblChlnDelvHead RH = db.tblChlnDelvHeads.Where(rh => (rh.ChlnTransf_Idno == objMtrlRcptHOHead.ChlnTransf_Idno) && (rh.ToCity_Idno == objMtrlRcptHOHead.ToCity_Idno) && (rh.Year_Idno == objMtrlRcptHOHead.Year_Idno) && (rh.ChlnDelvHead_Idno != HeadIdno)).FirstOrDefault(); if (RH != null) { RcptHeadIdno = -1; } else { tblChlnDelvHead objRcptHOHead = (from obj in db.tblChlnDelvHeads where obj.ChlnDelvHead_Idno == RcptHeadIdno select obj).SingleOrDefault(); if (objRcptHOHead != null) { objRcptHOHead.ChlnDelv_Date = objMtrlRcptHOHead.ChlnDelv_Date; objRcptHOHead.ToCity_Idno = objMtrlRcptHOHead.ToCity_Idno; objRcptHOHead.ChlnTransf_Idno = objMtrlRcptHOHead.ChlnTransf_Idno; objRcptHOHead.LocGR_Amnt = objMtrlRcptHOHead.LocGR_Amnt; objRcptHOHead.CrsngGR_Amnt = objMtrlRcptHOHead.CrsngGR_Amnt; objRcptHOHead.Net_Amnt = objMtrlRcptHOHead.Net_Amnt; objRcptHOHead.Date_Modified = MultipleDBDAL.GetIndianDateTime().Date; // DateTime.Now.Date; objRcptHOHead.Year_Idno = objMtrlRcptHOHead.Year_Idno; db.SaveChanges(); } List <tblChlnDelvDetl> ChlnDetl = db.tblChlnDelvDetls.Where(rd => rd.ChlnDelvHead_Idno == RcptHeadIdno).ToList(); foreach (tblChlnDelvDetl rgd in ChlnDetl) { db.tblChlnDelvDetls.DeleteObject(rgd); db.SaveChanges(); } if (DtTemp.Rows.Count > 0) { foreach (DataRow Dr in DtTemp.Rows) { tblChlnDelvDetl objtblChlnDelvDetl = new tblChlnDelvDetl(); objtblChlnDelvDetl.Gr_Idno = Convert.ToInt32(Dr["Gr_Idno"]); objtblChlnDelvDetl.Item_Idno = Convert.ToInt32(Dr["Item_Idno"]); objtblChlnDelvDetl.Unit_Idno = Convert.ToInt32(Dr["Unit_Idno"]); objtblChlnDelvDetl.Rate_Type = Convert.ToInt32(Dr["Rate_Type"]); objtblChlnDelvDetl.Qty = Convert.ToInt32(Dr["Qty"]); objtblChlnDelvDetl.Weight = Convert.ToDouble(Dr["Weight"]); objtblChlnDelvDetl.Amount = Convert.ToDouble(Dr["Amount"]); objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]); objtblChlnDelvDetl.Delv_Qty = Convert.ToDouble(Dr["Delv_Qty"]); objtblChlnDelvDetl.Delv_Weight = Convert.ToDouble(Dr["Delv_Wt"]); objtblChlnDelvDetl.Delv_Amount = Convert.ToDouble(Dr["Delv_Amount"]); objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]); objtblChlnDelvDetl.ChlnDelvHead_Idno = RcptHeadIdno; db.tblChlnDelvDetls.AddObject(objtblChlnDelvDetl); db.SaveChanges(); } } if (DtTemp.Rows.Count > 0) { foreach (DataRow Dr in DtTemp.Rows) { Int32 GrIdno = 0; GrIdno = Convert.ToInt32(Dr["Gr_Idno"]); TblGrHead objTblGrHead = (from obj in db.TblGrHeads where obj.GR_Idno == GrIdno select obj).FirstOrDefault(); if (objTblGrHead != null) { objTblGrHead.Gr_Delv = true; objTblGrHead.ChlnDelv_Idno = RcptHeadIdno; db.SaveChanges(); } } } } } } catch (Exception ex) { } return(RcptHeadIdno); }
public Int64 InsertMtrlRcptHOHead(tblChlnDelvHead objMtrlRcptHOHead, DataTable DtTemp) { Int64 RcptHeadIdno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { tblChlnDelvHead RH = db.tblChlnDelvHeads.Where(rh => (rh.ChlnTransf_Idno == objMtrlRcptHOHead.ChlnTransf_Idno) && (rh.ToCity_Idno == objMtrlRcptHOHead.ToCity_Idno)).FirstOrDefault(); if (RH != null) { RcptHeadIdno = -1; } else { db.tblChlnDelvHeads.AddObject(objMtrlRcptHOHead); db.SaveChanges(); RcptHeadIdno = objMtrlRcptHOHead.ChlnDelvHead_Idno; if (DtTemp.Rows.Count > 0) { foreach (DataRow Dr in DtTemp.Rows) { // ApplicationFunction.CreateTable("tbl", "Gr_Idno", "String", "Item_Idno", "String", "Unit_Idno", "String", "Rate_Type", "String", "Qty", "Weight", "", "String", "Amount", "String", "Delv_Qty", "String", "Reamrk", "String"); tblChlnDelvDetl objtblChlnDelvDetl = new tblChlnDelvDetl(); objtblChlnDelvDetl.Gr_Idno = Convert.ToInt32(Dr["Gr_Idno"]); objtblChlnDelvDetl.Item_Idno = Convert.ToInt32(Dr["Item_Idno"]); objtblChlnDelvDetl.Unit_Idno = Convert.ToInt32(Dr["Unit_Idno"]); objtblChlnDelvDetl.Rate_Type = Convert.ToInt32(Dr["Rate_Type"]); objtblChlnDelvDetl.Qty = Convert.ToInt32(Dr["Qty"]); objtblChlnDelvDetl.Weight = Convert.ToDouble(Dr["Weight"]); objtblChlnDelvDetl.Amount = Convert.ToDouble(Dr["Amount"]); objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]); objtblChlnDelvDetl.Delv_Qty = Convert.ToDouble(Dr["Delv_Qty"]); objtblChlnDelvDetl.Delv_Weight = Convert.ToDouble(Dr["Delv_Wt"]); objtblChlnDelvDetl.Delv_Amount = Convert.ToDouble(Dr["Delv_Amount"]); objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]); objtblChlnDelvDetl.ChlnDelvHead_Idno = RcptHeadIdno; db.tblChlnDelvDetls.AddObject(objtblChlnDelvDetl); db.SaveChanges(); } } if (DtTemp.Rows.Count > 0) { foreach (DataRow Dr in DtTemp.Rows) { Int32 GrIdno = 0; GrIdno = Convert.ToInt32(Dr["Gr_Idno"]); TblGrHead objTblGrHead = (from obj in db.TblGrHeads where obj.GR_Idno == GrIdno select obj).FirstOrDefault(); if (objTblGrHead != null) { objTblGrHead.Gr_Delv = true; objTblGrHead.ChlnDelv_Idno = RcptHeadIdno; db.SaveChanges(); } } } } } catch { return(0); } return(RcptHeadIdno); } }
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 string InsertGR(string ChlnNo, Int32 TruckNoIdno, Int32 YearIdno, Boolean isTBBRate, Int32 itruckcitywise, DataTable dtDetail) { Int64 intGrIdno = 0; string GrIdnos = ""; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { //using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) //{ try { TblGrHead objGRHead = null; if (objGRHead == null) { foreach (DataRow row in dtDetail.Rows) { objGRHead = new TblGrHead(); objGRHead.Gr_Date = Convert.ToDateTime(row["GR_Date"]); objGRHead.GR_Agnst = 1; objGRHead.GR_Typ = Convert.ToInt32(row["Gr_TypeIdno"]); objGRHead.DI_NO = ""; objGRHead.EGP_NO = ""; objGRHead.Gr_No = Convert.ToInt32(row["GR_No"]); objGRHead.Lorry_Idno = TruckNoIdno; objGRHead.Sender_Idno = Convert.ToInt64(row["SenderNameIdno"]); objGRHead.Recivr_Idno = Convert.ToInt64(row["ReciverNameIdno"]); objGRHead.From_City = Convert.ToInt64(row["FromCityIdno"]); objGRHead.To_City = Convert.ToInt64(row["ToCityIdno"]); objGRHead.DelvryPlce_Idno = 1; objGRHead.Agnt_Idno = 0; objGRHead.Remark = "Against Challan Crossing [ No." + ChlnNo + "]"; objGRHead.STax_Typ = 1; objGRHead.RcptType_Idno = 1; objGRHead.Inst_No = ""; objGRHead.Inst_Dt = Convert.ToDateTime(row["GR_Date"]); objGRHead.Bank_Idno = 0; objGRHead.Gross_Amnt = Convert.ToDouble(row["Amount"]); objGRHead.AgntComisn_Amnt = 0.00; objGRHead.TollTax_Amnt = 0.00; objGRHead.Cartg_Amnt = 0.00; objGRHead.Bilty_Amnt = 0.00; objGRHead.SubTot_Amnt = 0.00; objGRHead.Total_Amnt = Convert.ToDouble(row["Amount"]); objGRHead.Wages_Amnt = 0.00; objGRHead.ServTax_Amnt = 0.00; objGRHead.Surcrg_Amnt = 0.00; objGRHead.PF_Amnt = 0.00; objGRHead.Net_Amnt = Convert.ToDouble(row["Amount"]); objGRHead.RndOff_Amnt = 0.00; objGRHead.Year_Idno = YearIdno; objGRHead.TBB_Rate = isTBBRate; objGRHead.cmb_type = itruckcitywise; objGRHead.GR_Frm = "CC"; objGRHead.AgnstRcpt_No = ""; objGRHead.Chln_Idno = 0; objGRHead.ChlnCrsng_Idno = 0; objGRHead.Billed = false; db.TblGrHeads.AddObject(objGRHead); db.SaveChanges(); intGrIdno = objGRHead.GR_Idno; if (intGrIdno > 0) { GrIdnos += "," + intGrIdno; TblGrDetl objGRDetl = new TblGrDetl(); objGRDetl.GrHead_Idno = Convert.ToInt64(intGrIdno); objGRDetl.Item_Idno = Convert.ToInt32(0); objGRDetl.Unit_Idno = Convert.ToInt32(0); objGRDetl.Rate_Type = Convert.ToInt32(1); objGRDetl.Qty = Convert.ToInt64(row["Qty"]); objGRDetl.Tot_Weght = Convert.ToDouble(row["Weight"]); objGRDetl.Item_Rate = 0.00; objGRDetl.Amount = Convert.ToDouble(row["Amount"]); objGRDetl.Detail = Convert.ToString(row["Detail"]); objGRDetl.Shrtg_Limit = Convert.ToDouble(0); objGRDetl.Shrtg_Rate = Convert.ToDouble(0); db.TblGrDetls.AddObject(objGRDetl); db.SaveChanges(); } } // tScope.Complete(); } else { GrIdnos = ""; } } catch (Exception Ex) { // tScope.Dispose(); GrIdnos = ""; } } //} return(GrIdnos); }
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 int Delete(Int64 HeadId, Int64 UserIdno, string con, string Grtype) { int value = 0; clsAccountPosting objclsAccountPosting = new clsAccountPosting(); using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblInvGenHead CH = db.tblInvGenHeads.Where(h => h.Inv_Idno == HeadId).FirstOrDefault(); List <tblInvGenDetl> CD = db.tblInvGenDetls.Where(d => d.InvGenHead_Idno == HeadId).ToList(); if (CD != null && CH != null) { var lst = (from AI in db.tblAmntRecvInv_Detl where AI.Inv_Idno == HeadId select AI).ToList(); if (lst != null && lst.Count > 0) { return(-1); } else { if (CH != null) { SqlParameter[] objSqlPara = new SqlParameter[3]; objSqlPara[0] = new SqlParameter("@Action", "DeleteInvoiceDetails"); objSqlPara[1] = new SqlParameter("@Idno", HeadId); objSqlPara[2] = new SqlParameter("@UserIdno", UserIdno); Int32 del = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spDeleteFunctionality", objSqlPara); if (Grtype == "GR") { foreach (var d in CD) { TblGrHead objTblGrHead = (from obj in db.TblGrHeads where obj.GR_Idno == d.GR_Idno select obj).FirstOrDefault(); objTblGrHead.Billed = false; db.SaveChanges(); } } else { foreach (var d in CD) { tblGrRetailerHead objtblGrRetailerHead = (from obj in db.tblGrRetailerHeads where obj.GRRetHead_Idno == d.GR_Idno select obj).FirstOrDefault(); objtblGrRetailerHead.Billed = false; db.SaveChanges(); } } foreach (var d in CD) { db.tblInvGenDetls.DeleteObject(d); db.SaveChanges(); } db.tblInvGenHeads.DeleteObject(CH); db.SaveChanges(); Int64 intValue = objclsAccountPosting.DeleteAccountPosting(HeadId, "IB"); db.SaveChanges(); if (intValue > 0) { value = 1; } } } } } return(value); }
public Int64 Update(tblInvGenHead obj, Int32 InvIdno, DataTable DtTemp, string Grtype) { Int64 InvHeadId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); using (DbTransaction dbTran = db.Connection.BeginTransaction()) { try { //tblInvGenHead CH = db.tblInvGenHeads.Where(rh => rh.Inv_No == obj.Inv_No && rh.Inv_Idno != InvIdno && rh.Inv_prefix == obj.Inv_prefix && rh.BaseCity_Idno == obj.BaseCity_Idno).FirstOrDefault(); //if (CH != null) //{ // InvHeadId = -1; //} //else //{ tblInvGenHead TBH = db.tblInvGenHeads.Where(rh => rh.Inv_Idno == InvIdno).FirstOrDefault(); if (TBH != null) { TBH.Inv_No = obj.Inv_No; TBH.Inv_prefix = obj.Inv_prefix; TBH.Inv_Date = obj.Inv_Date; TBH.Sendr_Idno = obj.Sendr_Idno; TBH.BaseCity_Idno = obj.BaseCity_Idno; TBH.Year_Idno = obj.Year_Idno; TBH.GrossTot_Amnt = obj.GrossTot_Amnt; TBH.ServTax_Amnt = obj.ServTax_Amnt; TBH.Short_Amnt = obj.Short_Amnt; TBH.Net_Amnt = obj.Net_Amnt; TBH.Bilty_Chrgs = obj.Bilty_Chrgs; TBH.TBB_Rate = obj.TBB_Rate; TBH.TrServTax_Amnt = obj.TrServTax_Amnt; TBH.TrSwchBrtTax_Amnt = obj.TrSwchBrtTax_Amnt; TBH.ConsignrServTax = obj.ConsignrServTax; TBH.TrKisanKalyanTax_Amnt = obj.TrKisanKalyanTax_Amnt; TBH.ConsignrKisanTax_Amnt = obj.ConsignrKisanTax_Amnt; TBH.RoundOff_Amnt = obj.RoundOff_Amnt; TBH.Admin_Approval = obj.Admin_Approval; TBH.Print_Format = obj.Print_Format; TBH.Plant_InDate = obj.Plant_InDate; TBH.Plant_OutDate = obj.Plant_OutDate; TBH.Port_InDate = obj.Port_InDate; TBH.Port_OutDate = obj.Port_OutDate; TBH.PlantAmount = obj.PlantAmount; TBH.PortAmount = obj.PortAmount; TBH.PortDays = obj.PortDays; TBH.PlantDays = obj.PlantDays; TBH.HQCharges_Amnt = obj.HQCharges_Amnt; TBH.AddCharges_Amnt = obj.AddCharges_Amnt; TBH.Charges1_Name = obj.Charges1_Name; TBH.Charges1_Amnt = obj.Charges1_Amnt; TBH.Charges2_Name = obj.Charges2_Name; TBH.Charges2_Amnt = obj.Charges2_Amnt; TBH.Date_Modified = DateTime.Now; TBH.ShtgGST_Amt = obj.ShtgGST_Amt; TBH.User_ModifiedBy = obj.User_ModifiedBy; TBH.Delivery_Add = obj.Delivery_Add; db.SaveChanges(); InvHeadId = TBH.Inv_Idno; List <tblInvGenDetl> InvDetl = db.tblInvGenDetls.Where(rd => rd.InvGenHead_Idno == InvIdno).ToList(); foreach (tblInvGenDetl rgd in InvDetl) { db.tblInvGenDetls.DeleteObject(rgd); db.SaveChanges(); } 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"]); 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(InvHeadId); }
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); } }