public List <TyreSizeMaster> Bindtyresize() { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { List <TyreSizeMaster> obj1 = new List <TyreSizeMaster>(); obj1 = (from obj in db.TyreSizeMasters orderby obj.TyreSize select obj).ToList(); return(obj1); } }
public List <tblItemMastPur> BindItemName() { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { List <tblItemMastPur> objItemMast = new List <tblItemMastPur>(); objItemMast = (from obj in db.tblItemMastPurs where obj.ItemType == 1 && obj.ItemType != null orderby obj.Item_Name select obj).ToList(); return(objItemMast); } }
public Int64 CheckInvoiceDetails(Int64 GRHeadIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { Int64 InvoiceNo = 0; InvoiceNo = Convert.ToInt64((from a in db.TblGrHeads join b in db.tblInvGenDetls on a.GR_Idno equals b.GR_Idno join c in db.tblInvGenHeads on b.InvGenHead_Idno equals c.Inv_Idno where a.GR_Idno == GRHeadIdno && a.Chln_Idno > 0 && a.Billed == true select c.Inv_No).FirstOrDefault()); return(InvoiceNo); } }
public IList CheckDuplicateGrNo(Int64 intGrNo, Int32 FromCityIdno, Int32 intYearIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from m in db.TblGrHeads where m.Gr_No == intGrNo && m.Year_Idno == intYearIdno && m.GR_Frm == "BK" && m.From_City == FromCityIdno select new { m.Gr_No, }).ToList(); return(lst); } }
public IList <tblFrmCityDetl> SelectFromCityIdno(int UserId) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from obj in db.tblFrmCityDetls join CM in db.tblCityMasters on obj.FrmCity_Idno equals CM.City_Idno where obj.User_Idno == UserId select obj ).ToList(); return(lst); } }
public IList CheckItemExistInOtherMaster(string RcptGoodId) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { return((from obj in db.TblGrHeads where obj.AgnstRcpt_No == RcptGoodId select new { GoodId = obj.AgnstRcpt_No } ).ToList()); } }
public Int64 SelectTotal() { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from mast in db.tblGradeMasters orderby mast.Grade_Name ascending select new { mast }).Count(); return(lst); } }
public List <tblUserMast> Select() { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from u in db.tblUserMasts //where u.Status == true && u.DOJ != null && u.Admin_Idno == 0 where u.Status == true && u.DOJ != null && u.User_Idno == 0 orderby u.User_Name select u).ToList(); return(lst); } }
public IList CheckTyreExistInOtherMaster(Int32 tyreid) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { return((from obj in db.tblItemMastPurs where obj.Tyre_Type == tyreid select new { tyrIDNO = obj.Item_Idno } ).ToList()); } }
public IList CheckItemExistInOtherMaster(Int32 MiscIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { return((from obj in db.tblGrRetailerHeads where obj.Misc_Idno == MiscIdno select new { MiscGrp = obj.Misc_Idno } ).ToList()); } }
//public List<LocAreaMast> SelectLocArea() //{ // using (TransportMandiEntities db = new TransportMandiEntities()) // { // return (from LA in db.LocAreaMasts select LA).ToList(); // } //} public IList SelectLocation(Int32 intLocAreaIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { return((from LM in db.tblLocMasts where LM.Status == true select new { LM.Loc_Idno, LM.Loc_Name }).ToList()); } }
public IList SelectPartyName() { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { return((from LM in db.LorryMasts join AM in db.AcntMasts on LM.Prty_Idno equals AM.Acnt_Idno select new { AM.Acnt_Idno, AM.Acnt_Name }).OrderBy(a => a.Acnt_Idno).GroupBy(x => x.Acnt_Idno).Select(x => x.FirstOrDefault()).ToList()); } }
/// <summary> /// Insert records in tblItemMastPur /// </summary> /// <param name="strUOMName"></param> /// <param name="strItemDesc"></param> /// <param name="bStatus"></param> /// <returns></returns> public Int64 Insert(string strItemName, string strItemNameHindi, string strItemDesc, Int64 GrpType, Int64 ItemUnit, Double PurRate, Double VATTaxPer, Double CSTTaxPer, bool bStatus, Int64 ItemType, Int64 TyreIdno, string Companyname, string ModelName, Int32 empIdno, double sgst, double cgst, double igst, double itemmrp) { Int64 intValue = 0; Int32 intCompIdno = 1; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblItemMastPur objItemMast = new tblItemMastPur(); objItemMast.Item_Name = strItemName; objItemMast.ItemNamel_Hindi = strItemNameHindi; objItemMast.Item_Desc = strItemDesc; objItemMast.Status = bStatus; objItemMast.IGrp_Idno = GrpType; objItemMast.Unit_Idno = ItemUnit; objItemMast.Pur_Rate = PurRate; objItemMast.VATTax_Per = VATTaxPer; objItemMast.CSTTax_Per = CSTTaxPer; objItemMast.Comp_Idno = intCompIdno; objItemMast.Emp_Idno = empIdno; objItemMast.ItemType = ItemType; objItemMast.Tyre_Type = TyreIdno; objItemMast.Comp_Name = Companyname; objItemMast.Model_Name = ModelName; objItemMast.SGST = sgst; objItemMast.CGST = cgst; objItemMast.IGST = igst; objItemMast.Item_MRP = itemmrp; objItemMast.Date_Added = System.DateTime.Now; if (IsExists(strItemName, 0) == true) { intValue = -1; } else { db.tblItemMastPurs.AddObject(objItemMast); db.SaveChanges(); intValue = objItemMast.Item_Idno; } } } catch (Exception ex) { //ApplicationFunction.ErrorLog(ex.ToString()); } return(intValue); }
public IList SelectForSearch(DateTime?DateFrom, DateTime?DateTo, string strSBillNo, Int64 intPrtyIdno, Int64 intFromLocation, Int64 intYearIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var lst = (from SBH in db.tblSBillHeads join SBD in db.tblSBillDetls on SBH.SBillHead_Idno equals SBD.SBillHead_Idno join acnts in db.AcntMasts on SBH.Prty_Idno equals acnts.Acnt_Idno join cifrom in db.tblCityMasters on SBH.FromLoc_Idno equals cifrom.City_Idno join stck in db.Stckdetls on SBD.Item_Idno equals stck.SerlDetl_id where (SBD.Claim_Idno == 0 || SBD.Claim_Idno == null) select new { SbillHeadIdno = SBH.SBillHead_Idno, SerialNo = stck.SerialNo, SerialIdno = stck.SerlDetl_id, PrefNo = SBH.Prefix_No, SbillNo = SBH.SBill_No, SBillDate = SBH.SBillHead_Date, Location = SBH.FromLoc_Idno, CityName = cifrom.City_Name, PartyName = acnts.Acnt_Name, PartyIdno = acnts.Acnt_Idno, YearIdno = SBH.Year_Idno }).ToList(); if (intYearIdno > 0) { lst = (from l in lst where l.YearIdno == intYearIdno select l).ToList(); } if (intFromLocation > 0) { lst = (from l in lst where l.Location == intFromLocation select l).ToList(); } if (DateFrom != null) { lst = lst.Where(l => Convert.ToDateTime(l.SBillDate).Date >= Convert.ToDateTime(DateFrom).Date).ToList(); } if (DateTo != null) { lst = lst.Where(l => Convert.ToDateTime(l.SBillDate).Date <= Convert.ToDateTime(DateTo).Date).ToList(); } if (intPrtyIdno > 0) { lst = (from l in lst where l.PartyIdno == intPrtyIdno select l).ToList(); } if (strSBillNo != "") { lst = (from l in lst where ((l.PrefNo) + "" + (l.SbillNo)) == strSBillNo select l).ToList(); } return(lst); } }
/// <summary> /// Insert records in VchrHead table /// </summary> public Int64 InsertInVchrHead(DateTime VchrDate, byte VchrType, Int64 VchrMode, string VchrNarr, bool VchrHidn, byte VchrSusp, string VchrFrm, Int64 AcntIdno, Int16 Printed, Int64 SbillNo, DateTime?SbillDate, Int64 VchrNo, double DcnNo, int YearIdno, int CompIdno, int UserIdno ) { Int64 intValue = 0; VchrHead objVchrHead = new VchrHead(); objVchrHead.Vchr_Date = VchrDate; objVchrHead.Vchr_Type = VchrType; objVchrHead.Vchr_Mode = VchrMode; objVchrHead.Vchr_Narr = VchrNarr; objVchrHead.Vchr_Hidn = VchrHidn; objVchrHead.Vchr_Susp = VchrSusp; objVchrHead.Vchr_Frm = VchrFrm; objVchrHead.Acnt_Idno = AcntIdno; objVchrHead.Printed = Printed; objVchrHead.Sbill_No = 0; objVchrHead.Sbill_Date = null; if (VchrNo > 0) { objVchrHead.Vchr_No = VchrNo; } else { objVchrHead.Vchr_No = this.GetMaxVchrNo(VchrType, CompIdno, YearIdno); } objVchrHead.Dcn_No = DcnNo; objVchrHead.Year_Idno = YearIdno; objVchrHead.Comp_Idno = CompIdno; objVchrHead.User_Idno = UserIdno; objVchrHead.User_Type = 0; objVchrHead.VchrFor_Idno = 0; objVchrHead.VchrManual_No = ""; objVchrHead.Date_Modified = SbillDate; objVchrHead.Date_Added = VchrDate;// ApplicationFunction.GetIndianDateTime().Date; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { db.VchrHeads.AddObject(objVchrHead); db.SaveChanges(); intValue = objVchrHead.Vchr_Idno; } catch (Exception ex) { intValue = 0; // ApplicationFunction.ErrorLog(ex.ToString()); } } return(intValue); }
public IList SelectTrip(int TripNo, DateTime?dtfrom, DateTime?dtto, int cityfrom, int sender, Int32 yearidno, Int64 LorryIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { //var lst = db.tblManualTripHeads.Where(x=> x.Trip_No == TripNo && x.Trip_Date >= dtfrom && x.Trip_Date <= dtto && x.BaseCity_Idno == cityfrom && x.Party_Idno == sender && x.Year_Idno == yearidno).ToList(); var lst = (from mt in db.tblManualTripHeads join am in db.AcntMasts on mt.Party_Idno equals am.Acnt_Idno join cm in db.tblCityMasters on mt.BaseCity_Idno equals cm.City_Idno join lm in db.LorryMasts on mt.Truck_Idno equals lm.Lorry_Idno where mt.Trip_Date >= dtfrom && mt.Year_Idno == yearidno select new{ mt.Party_Idno, mt.BaseCity_Idno, mt.Trip_Idno, mt.Trip_No, mt.Trip_Date, mt.TotalParty_Adv, mt.TotalParty_Bal, mt.TotalVeh_Amnt, mt.Driver_Name, mt.EndKms, mt.StartKms, mt.Freight_Amnt, mt.Gross_Weight, mt.Item_Name, mt.NetTrip_Profit, mt.Quantity, lm.Lorry_No, am.Acnt_Name, cm.City_Name, mt.Truck_Idno }).ToList(); if (cityfrom != 0) { lst = lst.Where(x => x.BaseCity_Idno == cityfrom).ToList(); } if (sender != 0) { lst = lst.Where(x => x.Party_Idno == sender).ToList(); } if (TripNo != 0) { lst = lst.Where(x => x.Trip_No == TripNo).ToList(); } if (LorryIdno != 0) { lst = lst.Where(x => x.Truck_Idno == LorryIdno).ToList(); } return(lst); } }
public IList CheckCategoryExistInLedgerMaster(Int32 categoryId) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { return((from obj in db.AcntMasts where obj.Category_Idno == categoryId select new { obj.Category_Idno } ).ToList() ); } }
public List <AcntMast> BindBank() { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { List <AcntMast> objacntmast = new List <AcntMast>(); objacntmast = (from obj in db.AcntMasts where obj.Acnt_Type == 4 orderby obj.Acnt_Name select obj).ToList(); return(objacntmast); } }
public double FetchLedgerOpCl(string ConString, string Action, int opentype, string acnt_idno, int yearid) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { SqlParameter[] objSqlPara = new SqlParameter[4]; objSqlPara[0] = new SqlParameter("@Action", Action); objSqlPara[1] = new SqlParameter("@OpenType", opentype); objSqlPara[2] = new SqlParameter("@AcntIdno", acnt_idno); objSqlPara[3] = new SqlParameter("@YearIdno", yearid); var Temp = SqlHelper.ExecuteScalar(ConString, CommandType.StoredProcedure, "spAcntOpen", objSqlPara); return(Convert.ToDouble(Temp)); } }
public double FetchLedgerBal(string ConString, string Action, int amnttype, string acnt_idno, int yearid) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { SqlParameter[] objSqlPara = new SqlParameter[4]; objSqlPara[0] = new SqlParameter("@Action", Action); objSqlPara[1] = new SqlParameter("@AMNTTYPE", amnttype); objSqlPara[2] = new SqlParameter("@ACNTIDNO", acnt_idno); objSqlPara[3] = new SqlParameter("@YEARIDNO", yearid); var Temp = SqlHelper.ExecuteScalar(ConString, CommandType.StoredProcedure, "spVoucherEntry", objSqlPara); return(Convert.ToDouble(Temp)); } }
public Int64 Countall() { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { Int32 Count = 0; Count = (from CH in db.tblPayToOwnAccs //join cifrom in db.tblCityMasters on CH.BaseCity_Idno equals cifrom.City_Idno join cito in db.tblCityMasters on CH.BaseCity_Idno equals cito.City_Idno join AM in db.AcntMasts on CH.Driver_IdNo equals AM.Acnt_Idno select CH.Id).Count(); return(Count); } }
public IList CheckItemExistInOtherMaster(Int32 PurBillIdno, Int32 ItemIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { return((from obj in db.tblPBillDetls join obj1 in db.Stckdetls on obj.PBillHead_Idno equals obj1.PBillIdno where obj.PBillHead_Idno == PurBillIdno && obj.Item_Idno == ItemIdno orderby obj1.SerialNo select new { SerialIdo = obj1.SerlDetl_id, }).ToList()); } }
public Int64 Select_PurchaseBillCount(Int32 yearIdno, DateTime?DateFrom, DateTime?DateTo) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { Int64 lst = (from PBH in db.tblPBillHeads join cifrom in db.tblCityMasters on PBH.Loc_Idno equals cifrom.City_Idno join acnts in db.AcntMasts on PBH.Prty_Idno equals acnts.Acnt_Idno where PBH.Year_Idno == yearIdno && PBH.PBillHead_Date >= DateFrom && PBH.PBillHead_Date <= DateTo select PBH).Count(); return(lst); } }
public List <tblCityMaster> BindCityAll() { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { List <tblCityMaster> objCityMasterList = new List <tblCityMaster>(); objCityMasterList = (from obj in db.tblCityMasters where obj.Status == true orderby obj.City_Name select obj).ToList(); return(objCityMasterList); } }
public DataSet UpdateGrDetl(string Constring, string Action, Int64 Qty, double Weight, Int64 Grno, Int64 Locid) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { SqlParameter[] objSqlParameter = new SqlParameter[6]; objSqlParameter[0] = new SqlParameter("@Action", Action); objSqlParameter[1] = new SqlParameter("@Qty", Qty); objSqlParameter[2] = new SqlParameter("@Weight", Weight); objSqlParameter[3] = new SqlParameter("@GrNO", Grno); objSqlParameter[4] = new SqlParameter("@Locid", Locid); DataSet ds = SqlHelper.ExecuteDataset(Constring, CommandType.StoredProcedure, "spUpdateGr", objSqlParameter); return(ds); } }
public IList TyreSerialFromLoc(Int32 ItemIdno, Int64 LocIdno, Int64 tyresizeidno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { var Lst = (from N in db.Stckdetls where N.Is_Issued == false && N.MtrlIssue_Idno == 0 && N.ItemIdno == ItemIdno && N.TyresizeIdno == tyresizeidno && (N.Billed == false || N.Billed == null) && (N.Loc_Idno == LocIdno) && (N.Item_from != "CP") select new { StckId = N.SerlDetl_id, SerialNo = N.SerialNo }).ToList(); return(Lst); } }
public IList BindTollPump(Int64[] Ids) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { return((from obj in db.tbltollmasters where obj.Status == true && Ids.Contains(obj.Toll_id) select new { TollName = obj.Tolltax_name, TollIdno = obj.Toll_id, Amount = obj.Amount }).ToList()); } }
public bool Insert(DataTable dT, Int32 itemidno, string strRateType, Int32 FrmCityIdno, Int32 ToCityIdno, Int32 empIdno, string strTranType, Int64 TranTypeID) { bool value = true; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { for (int i = 0; i < dT.Rows.Count; i++) { tblRateMastRetailer obj = new tblRateMastRetailer(); obj.Item_Idno = itemidno; obj.FrmCity_Idno = FrmCityIdno; obj.ToCity_Idno = ToCityIdno; obj.Emp_Idno = empIdno; obj.Rate_Type = Convert.ToString(dT.Rows[i]["Rate_Type"]); obj.Rate_Date = Convert.ToDateTime(dT.Rows[i]["Rate_Date"]); obj.Item_Rate = Convert.ToDouble(dT.Rows[i]["Item_Rate"]); obj.Item_WghtRate = Convert.ToDouble(dT.Rows[i]["Item_WghtRate"]); obj.ToCity_Idno = Convert.ToInt32(dT.Rows[i]["ToCity_Idno"]); obj.Cityvia_Idno = Convert.ToInt32(dT.Rows[i]["CityVia_Idno"]); obj.QtyShrtg_Limit = Convert.ToDouble(dT.Rows[i]["QtyShrtg_Limit"]); obj.QtyShrtg_Rate = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["QtyShrtg_Rate"])) ? 0 : Convert.ToDouble(dT.Rows[i]["QtyShrtg_Rate"]); obj.WghtShrtg_Limit = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["WghtShrtg_Limit"])) ? 0 : Convert.ToDouble(dT.Rows[i]["WghtShrtg_Limit"]); obj.WghtShrtg_Rate = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["WghtShrtg_Rate"])) ? 0 : Convert.ToDouble(dT.Rows[i]["WghtShrtg_Rate"]); obj.Item_Rate2 = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["Item_Rate2"])) ? 0 : Convert.ToDouble(dT.Rows[i]["Item_Rate2"]); obj.Item_Rate3 = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["Item_Rate3"])) ? 0 : Convert.ToDouble(dT.Rows[i]["Item_Rate3"]); obj.ItemRate_Type = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["ItemRateType_Idno"])) ? 0 : Convert.ToInt32(dT.Rows[i]["ItemRateType_Idno"]); obj.Dist_Km = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["Dist_km"])) ? 0 : Convert.ToDouble(dT.Rows[i]["Dist_km"]); obj.DistMast_Idno = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["DistanceIdno"])) ? 0 : Convert.ToInt64(dT.Rows[i]["DistanceIdno"]); obj.Con_Size = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["ConSize"])) ? "0" : Convert.ToString(dT.Rows[i]["ConSize"]); obj.Con_Weight = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["ConWeight"])) ? 0 : Convert.ToDouble(dT.Rows[i]["ConWeight"]); obj.ConSize_ID = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["ConSizeID"])) ? 0 : Convert.ToInt32(dT.Rows[i]["ConSizeID"]); obj.Item_Weight = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["Item_Weight"])) ? 0 : Convert.ToDecimal(dT.Rows[i]["Item_Weight"]); obj.IsWeight = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["Item_Weight"])) ? false : Convert.ToBoolean(dT.Rows[i]["IsWeight"]); obj.TranType = strTranType; obj.TranType_Idno = TranTypeID; obj.Status = true; obj.Date_Added = DateTime.Now; obj.Date_Modified = DateTime.Now; db.tblRateMastRetailers.AddObject(obj); db.SaveChanges(); } } catch (Exception Ex) { value = false; } } return(value); }
public Int64 UpdateForRecvd(tblClaimToComHead obj, Int32 Head_Idno, DataTable Dttemp) { Int64 ClaimHeadIdno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); try { tblClaimToComHead CHead = db.tblClaimToComHeads.Where(ch => ch.ClaimToComHead_Idno == Head_Idno).FirstOrDefault(); if (CHead != null) { CHead.ClaimToComRec_Date = obj.ClaimToComRec_Date; CHead.Against = obj.Against; db.SaveChanges(); ClaimHeadIdno = CHead.ClaimToComHead_Idno; List <tblClaimToComDetl> ClaimDetl = db.tblClaimToComDetls.Where(cd => cd.ClaimToComHead_Idno == Head_Idno).ToList(); foreach (tblClaimToComDetl tcd in ClaimDetl) { for (int i = 0; i < Dttemp.Rows.Count; i++) { Int64 Value = Convert.ToInt64(Dttemp.Rows[i]["ClaimDetailsIdno"]); List <tblClaimToComDetl> ClaimDetls = db.tblClaimToComDetls.Where(cd => cd.ClaimToComDetl_Idno == Value).ToList(); foreach (tblClaimToComDetl tcds in ClaimDetls) { tcds.Status = Convert.ToInt64(Dttemp.Rows[i]["Status"]); tcds.New_SerialNo = Convert.ToString(Dttemp.Rows[i]["NewSerialNo"]); tcds.Remark = Convert.ToString(Dttemp.Rows[i]["Remark"]); db.SaveChanges(); string NewSerialNo = Dttemp.Rows[i]["NewSerialNo"].ToString(); if (string.IsNullOrEmpty(NewSerialNo) == false) { Stckdetl SD = db.Stckdetls.Where(d => d.SerialNo == NewSerialNo).FirstOrDefault(); tcds.NewStckDetl_Idno = SD.SerlDetl_id; db.SaveChanges(); } } } } } } catch { ClaimHeadIdno = 0; } } return(ClaimHeadIdno); }
public Int64 TotalRecords() { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { Int32 Count = 0; Count = (from hd in db.tblSummaryRegisters join cito in db.tblCityMasters on hd.FromCity_Idno equals cito.City_Idno join trk in db.LorryMasts on hd.Truck_Idno equals trk.Lorry_Idno select hd.SumReg_Idno).Count(); return(Count); } }