public ActionResult LoadMessagesForSpecificDriver(int driverID)
{
ChatUserMessagesVM userMessagesModel = new ChatUserMessagesVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var driver = _db.vozaci.Where(x => x.vozac_id == driverID).FirstOrDefault();
userMessagesModel.DriverID = driver.vozac_id;
userMessagesModel.DriverFullName = driver.ime + " " + driver.prezime;
userMessagesModel.UserMessages = _db.poruke.Where(s => s.vozac_id == driver.vozac_id).Select(s => new ChatMessagesVM
{
MessageID = s.poruka_id,
DriverID = s.vozac_id,
UnixCreationTime = s.vrijeme,
SByteFromDriver = s.odvozaca,
MessageText = s.text
}).OrderByDescending(s => s.MessageID).Take(50).ToList();
foreach (var userMessage in userMessagesModel.UserMessages)
{
userMessage.CreationTime = UnixTime.ConvertToDateTimeString(userMessage.UnixCreationTime);
userMessage.FromDriver = Convert.ToBoolean(userMessage.SByteFromDriver);
}
}
return(PartialView(viewName: "_UserMessages", model: userMessagesModel));
}
public ActionResult Index()
{
ChatVM model = new ChatVM();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var drivers = _db.vozaci.ToList();
model.FirstDriverID = drivers.First().vozac_id;
model.ChatUsersMessages = new List <ChatUserMessagesVM>();
if (drivers != null)
{
foreach (var driver in drivers)
{
ChatUserMessagesVM userMessagesModel = new ChatUserMessagesVM();
userMessagesModel.DriverID = driver.vozac_id;
userMessagesModel.DriverFullName = driver.ime + " " + driver.prezime;
userMessagesModel.UserMessages = _db.poruke.Where(s => s.vozac_id == driver.vozac_id).Select(s => new ChatMessagesVM
{
MessageID = s.poruka_id,
DriverID = s.vozac_id,
UnixCreationTime = s.vrijeme,
SByteFromDriver = s.odvozaca,
MessageText = s.text
}).OrderByDescending(s => s.MessageID).Take(50).ToList();
foreach (var userMessage in userMessagesModel.UserMessages)
{
userMessage.CreationTime = UnixTime.ConvertToDateTimeString(userMessage.UnixCreationTime);
userMessage.FromDriver = Convert.ToBoolean(userMessage.SByteFromDriver);
}
model.ChatUsersMessages.Add(userMessagesModel);
}
}
}
return(View(viewName: "Index", model: model));
}
