public List <DTO_Transaction_Table> GetTransaction_Table()
{
List <DTO_Transaction_Table> dtts = new List <DTO_Transaction_Table>();
List <Transaction_Table> tts = db.Transaction_Table.ToList();
foreach (Transaction_Table tt in tts)
{
DTO_Transaction_Table dtt = new DTO_Transaction_Table();
tt.ConvertToDTO(dtt);
if (tt.User_Id != null)
{
User user = db.Users.Where(x => x.User_Id == dtt.User_Id).Single();
dtt.User_Name = user.F_Name + " " + user.L_Name;
dtt.User_Mobile_Number = user.Mobile_Number;
}
if (tt.Volunteer_Id != null)
{
Volunteer volunteer = db.Volunteers.Where(x => x.Volunteer_Id == dtt.Volunteer_Id).Single();
dtt.Volunteer_Name = volunteer.F_Name + " " + volunteer.L_Name;
dtt.Volunteer_Mobile = volunteer.Mobile_Number;
}
if (tt.Driver_Id != null)
{
Driver driver = db.Drivers.Where(x => x.Driver_Id == dtt.Driver_Id).Single();
dtt.Driver_Name = driver.F_Name + " " + driver.L_Name;
dtt.Driver_Mobile = driver.Mobile_Number;
}
dtts.Add(dtt);
}
return(dtts);
}
public IHttpActionResult GetTransaction_Table(int id)
{
Transaction_Table transaction_Table = db.Transaction_Table.Find(id);
if (transaction_Table == null)
{
return(NotFound());
}
DTO_Transaction_Table dtt = new DTO_Transaction_Table();
transaction_Table.ConvertToDTO(dtt);
if (transaction_Table.User_Id != null)
{
User user = db.Users.Where(x => x.User_Id == dtt.User_Id).Single();
dtt.User_Name = user.F_Name + " " + user.L_Name;
dtt.User_Mobile_Number = user.Mobile_Number;
}
if (transaction_Table.Volunteer_Id != null)
{
Volunteer volunteer = db.Volunteers.Where(x => x.Volunteer_Id == dtt.Volunteer_Id).Single();
dtt.Volunteer_Name = volunteer.F_Name + " " + volunteer.L_Name;
dtt.Volunteer_Mobile = volunteer.Mobile_Number;
}
if (transaction_Table.Driver_Id != null)
{
Driver driver = db.Drivers.Where(x => x.Driver_Id == dtt.Driver_Id).Single();
dtt.Driver_Name = driver.F_Name + " " + driver.L_Name;
dtt.Driver_Mobile = driver.Mobile_Number;
}
return(Ok(dtt));
}
public IHttpActionResult GetTransaction_TableByUser(int id)
{
Transaction_Table transaction_Table = db.Transaction_Table.Where(x => x.User_Id == id && (x.Status == "Volunteer Requested" || x.Status == "Active" || x.Status == "Driver Requested")).FirstOrDefault();
if (transaction_Table == null)
{
return(NotFound());
}
DTO_Transaction_Table dtt = new DTO_Transaction_Table();
transaction_Table.ConvertToDTO(dtt);
if (transaction_Table.User_Id != null)
{
User user = db.Users.Where(x => x.User_Id == dtt.User_Id).Single();
dtt.User_Name = user.F_Name + " " + user.L_Name;
dtt.User_Mobile_Number = user.Mobile_Number;
}
if (transaction_Table.Volunteer_Id != null)
{
Volunteer volunteer = db.Volunteers.Where(x => x.Volunteer_Id == dtt.Volunteer_Id).Single();
dtt.Volunteer_Name = volunteer.F_Name + " " + volunteer.L_Name;
dtt.Volunteer_Mobile = volunteer.Mobile_Number;
}
if (transaction_Table.Driver_Id != null)
{
Driver driver = db.Drivers.Where(x => x.Driver_Id == dtt.Driver_Id).Single();
dtt.Driver_Name = driver.F_Name + " " + driver.L_Name;
dtt.Driver_Mobile = driver.Mobile_Number;
}
return(Ok(dtt));
}
public void ConvertToDTO(DTO_Transaction_Table dtt)
{
dtt.Driver_Id = Driver_Id;
dtt.Items = Items;
dtt.L_Driver = L_Driver;
dtt.L_User = L_User;
dtt.L_Volunteer = L_Volunteer;
dtt.Status = Status;
dtt.Successful = Successful;
dtt.Time_Begin = Time_Begin;
dtt.Time_Close = Time_Close;
dtt.Transaction_Id = Transaction_Id;
dtt.User_Id = User_Id;
dtt.Vehicle = Vehicle;
dtt.Volunteer_Id = Volunteer_Id;
}
