public DataTable GetCu_Slot(string User_ID) { return(ToDataTable.LINQResultToDataTable( (from cu_sl in db.Customer_Slut_Table join Slot in db.Slut_Table on cu_sl.Slut_ID equals Slot.Slut_ID join car in db.Car_Specifications_Table on cu_sl.Car_Spe_ID equals car.Car_Spe_ID join user in db.AspNetUsers on cu_sl.Customer_ID equals user.Id where user.Id == User_ID select new { car.Care_Model, car.Car_plate_Number, cu_sl.Cus_Slut_Date, cu_sl.Cus_Slut_S_Time, cu_sl.Cus_Slut_E_Time, Slot.Name, Slot.Slut_Level }).ToList())); }
public DataTable GetArea() { return(ToDataTable.LINQResultToDataTable((from Are in db.Area_Table join user in db.AspNetUsers on Are.Area_Manger equals user.Id join stat in db.States_Table on Are.States_ID equals stat.States_ID join gov in db.Governorate_Table on stat.Gov_ID equals gov.Gov_ID select new { gov.Gov_Name, stat.States_Name, user.UserName, Are.Area_Desc, Are.Area_Name, Are.Area_Start_Time, Are.Area_End_Time , Are.Area_Hour_Rate }).ToList())); //return ToDataTable.LINQResultToDataTable(db.Area_Table.ToList()); }
public DataTable Get_Cust(string User_ID) { return(ToDataTable.LINQResultToDataTable(db.AspNetUsers.Where(use => use.Id == User_ID).ToList())); }
public DataTable GetCars(string User_ID) { return(ToDataTable.LINQResultToDataTable(db.Car_Specifications_Table.Where(car => car.Car_Owner_ID == User_ID).ToList())); }
public DataTable GetCompanyInf() { return(ToDataTable.LINQResultToDataTable(db.Company_Table.ToList())); }