コード例 #1
0
 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()));
 }
コード例 #2
0
 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());
 }
コード例 #3
0
 public DataTable Get_Cust(string User_ID)
 {
     return(ToDataTable.LINQResultToDataTable(db.AspNetUsers.Where(use => use.Id == User_ID).ToList()));
 }
コード例 #4
0
 public DataTable GetCars(string User_ID)
 {
     return(ToDataTable.LINQResultToDataTable(db.Car_Specifications_Table.Where(car => car.Car_Owner_ID == User_ID).ToList()));
 }
コード例 #5
0
 public DataTable GetCompanyInf()
 {
     return(ToDataTable.LINQResultToDataTable(db.Company_Table.ToList()));
 }