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);
}
