public bool IsLorryRetrun(Int64 intTruckIdno) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { TblHireInvDetl objhiredetl = new TblHireInvDetl(); objhiredetl = (from id in db.TblHireInvDetls where id.Truck_Idno == intTruckIdno && (id.ReturnDate == null) select id).FirstOrDefault(); if (objhiredetl != null) { return(true); } else { return(false); } } }
public Int64 Update(Int64 HireHead_Idno, Int64 Year_Idno, DateTime?Invice_Date, Int64 Invioce_No, Int64 Loc_Idno, Int64 User_Idno, Int64 Comp_Idno, bool AccPost, string Remark, Int64 truckidno, Int64 partyidno, Int64 fromcityidno, Int64 citytoidno, Int64 viacityidno, DateTime?from_Date, DateTime?return_Date, double netamnt, double advamnt, double dieselamnt, Int32 recptidno, Int32 instno, DateTime?instdate, Int32 bankidno, double grossamnt, string GrIdno, DataTable dtitemdetail, string Con) { Int64 IHireHead_Idno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { TblHireInvHead objHireHead1 = (from mast in db.TblHireInvHeads where mast.Hire_Idno == HireHead_Idno select mast).FirstOrDefault(); if (objHireHead1 != null) { objHireHead1.Year_Idno = Year_Idno; objHireHead1.Hire_InvNo = Invioce_No; objHireHead1.Hire_Date = Invice_Date; objHireHead1.Loc_Idno = Loc_Idno; objHireHead1.User_Idno = User_Idno; objHireHead1.Comp_Idno = Comp_Idno; objHireHead1.Acc_Post = AccPost; objHireHead1.Remark = Remark; objHireHead1.Date_Modified = System.DateTime.Now; objHireHead1.Net_Amnt = netamnt; objHireHead1.Gross_Amnt = grossamnt; objHireHead1.Adv_Amnt = advamnt; objHireHead1.Diesel_Amnt = dieselamnt; objHireHead1.RcptType_Idno = recptidno; objHireHead1.Inst_No = instno; objHireHead1.Inst_Dt = instdate; objHireHead1.Bank_Idno = bankidno; objHireHead1.Truck_Idno = Convert.ToInt64(Convert.ToString(truckidno) == "" ? 0 : truckidno); objHireHead1.Party_Idno = Convert.ToInt64(Convert.ToString(partyidno) == "" ? 0 : partyidno); objHireHead1.LocFrm_Idno = Convert.ToInt64(Convert.ToString(fromcityidno) == "" ? 0 : fromcityidno); objHireHead1.ViaCity_Idno = Convert.ToInt64(Convert.ToString(viacityidno) == "" ? 0 : viacityidno); objHireHead1.ToCity_Idno = Convert.ToInt64(Convert.ToString(citytoidno) == "" ? 0 : citytoidno); objHireHead1.DateFrom = Convert.ToDateTime(from_Date); objHireHead1.ReturnDate = String.IsNullOrEmpty(Convert.ToString(return_Date)) ? (DateTime?)null : Convert.ToDateTime(return_Date); db.SaveChanges(); IHireHead_Idno = HireHead_Idno; if (IHireHead_Idno > 0) { List <TblHireInvDetl> lstHireDetl = db.TblHireInvDetls.Where(obj => obj.Hire_Idno == IHireHead_Idno).ToList(); if (lstHireDetl.Count > 0) { foreach (TblHireInvDetl obj in lstHireDetl) { db.TblHireInvDetls.DeleteObject(obj); } db.SaveChanges(); } foreach (DataRow row in dtitemdetail.Rows) { TblHireInvDetl objHireDetl = new TblHireInvDetl(); objHireDetl.Hire_Idno = HireHead_Idno; objHireDetl.Item_Idno = Convert.ToInt32(row["Item_Idno"]); objHireDetl.Unit_Idno = string.IsNullOrEmpty(Convert.ToString(row["Unit_Idno"])) ? 0 : Convert.ToInt32(row["Unit_Idno"]); objHireDetl.Rate_Type = string.IsNullOrEmpty(Convert.ToString(row["Rate_TypeIdno"])) ? 0 : Convert.ToInt32(row["Rate_TypeIdno"]); objHireDetl.Qty = Convert.ToInt64(row["Quantity"]); objHireDetl.Tot_Weght = Convert.ToDouble(row["Weight"]); objHireDetl.Item_Rate = Convert.ToDouble(row["Rate"]); objHireDetl.Amount = Convert.ToDouble(row["Amount"]); objHireDetl.Detail = Convert.ToString(row["Detail"]); objHireDetl.UnloadWeight = Convert.ToDouble(row["UnloadWeight"]); db.TblHireInvDetls.AddObject(objHireDetl); db.SaveChanges(); } } if (GrIdno != "") { UpdateFlag(Con, GrIdno, HireHead_Idno); } } else { IHireHead_Idno = -1; } } catch (Exception Ex) { IHireHead_Idno = 0; } } return(IHireHead_Idno); }