public ActionResult AssignDetails(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Requsition requisition = _requisitionManager.GetById((int)id);
var userEmployeeId = GetEmployeeId();
ViewBag.UserEmployeeId = userEmployeeId;
var driverId = driverStatusManager.Get(c => c.RequsitionId == id).Select(c => c.EmployeeId).FirstOrDefault();
if (userEmployeeId != driverId)
{
TempData["msg"] = "Sorry, you have no permission to access this type of data!";
return(RedirectToAction("MyDutyList"));
}
var vehicleId = vehicleStatusManager.Get(c => c.RequsitionId == id).Select(c => c.VehicleId).FirstOrDefault();
AssignedListViewModel assignVm = new AssignedListViewModel
{
Requisition = requisition,
Employee = _employeeManager.GetById((int)requisition.EmployeeId),
Driver = _employeeManager.GetById(driverId),
Vehicle = vehicleManager.GetById(vehicleId)
};
GetCommentViewModelForInsertComment(requisition, userEmployeeId, assignVm);
//Collect the list of comment to display the list under comment
GetCommentList(requisition, assignVm);
return(View(assignVm));
}
// GET: Requsition/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
Requsition requisition = _requisitionManager.GetById((int)id);
var userEmployeeId = GetEmployeeId();
ViewBag.UserEmployeeId = userEmployeeId;
EditRequisitionViewModel EditRequsition = new EditRequisitionViewModel();
EditRequsition.Id = requisition.Id;
EditRequsition.Form = requisition.Form;
EditRequsition.To = requisition.To;
EditRequsition.Description = requisition.Description;
EditRequsition.JourneyStart = requisition.JourneyStart;
EditRequsition.JourneyEnd = requisition.JouneyEnd;
EditRequsition.EmployeeId = (int)requisition.EmployeeId;
EditRequsition.RequestTypes = GetRequisitionTypes();
EditRequsition.RequestType = requisition.RequestType;
var employees = _employeeManager.Get(c => c.IsDriver == false && c.IsDeleted == false && c.Id != userEmployeeId);
ViewBag.Employees = employees.ToList();
return(View(EditRequsition));
}
public ActionResult Create(RequsitionViewModel requisitionVm)
{
try
{
Requsition requisition = new Requsition();
requisition.Form = requisitionVm.Form;
requisition.To = requisitionVm.To;
requisition.Description = requisitionVm.Description;
requisition.JourneyStart = requisitionVm.JourneyStart;
requisition.JouneyEnd = requisitionVm.JouneyEnd;
requisition.EmployeeId = requisitionVm.EmployeeId;
bool isSaved = _requisitionManager.Add(requisition);
if (isSaved)
{
TempData["msg"] = "Requisition Send Successfully";
return(RedirectToAction("RequisitionIndex", TempData["msg"]));
}
return(RedirectToAction("Create"));
}
catch
{
return(View());
}
}
// GET: Requsition/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
int requsitionId = (int)id;
Requsition requsition = _requisitionManager.GetById(requsitionId);
if (requsition == null)
{
return(HttpNotFound());
}
var employee = _employeeManager.Get(c => c.IsDriver == true && c.IsDeleted == false);
var manager = _managerManager.GetAll();
RequsitionViewModel requsitionViewModel = new RequsitionViewModel();
requsitionViewModel.Id = requsition.Id;
requsitionViewModel.Form = requsition.Form;
requsitionViewModel.To = requsition.To;
requsitionViewModel.JourneyStart = requsition.JourneyStart;
requsitionViewModel.JouneyEnd = requsition.JouneyEnd;
requsitionViewModel.Description = requsition.Description;
requsitionViewModel.Employee = requsition.Employee;
requsitionViewModel.Manager = manager.FirstOrDefault(c => c.RequsitionId == requsition.Id);
int? emplId = requsition.EmployeeId;
string employeeNam = requsition.Employee.Name;
requsitionViewModel.CommentViewModel = new CommentViewModel
{
EmployeeId = (int)emplId,
EmployeName = employeeNam,
RequsitionId = requsitionId
};
//Collect the list of comment to display the list under comment
List <CommentViewModel> commentListViewModel = new List <CommentViewModel>();
var commentListView = commentManager.GetCommentsByRequisition(requsitionId);
foreach (var item in commentListView.ToList())
{
commentListViewModel.Add
(
new CommentViewModel
{
RequsitionId = requsitionId,
Comments = item.Comments,
EmployeeId = item.EmployeeId,
EmployeName = item.Employee.Name,
UserName = item.UserName,
CommentTime = item.CommentTime
}
);
}
requsitionViewModel.CommentViewModels = commentListViewModel;
return(View(requsitionViewModel));
}
private void GetCommentList(Requsition requisition, AssignedListViewModel assignVm)
{
List <CommentViewModel> commentListViewModel = new List <CommentViewModel>();
var commentListView = commentManager.GetCommentsByRequisition(requisition.Id).Where(c => c.ReceiverEmployeeId == GetEmployeeId() || c.SenderEmployeeId == GetEmployeeId());
foreach (var item in commentListView.ToList())
{
var cmnt = new CommentViewModel
{
Id = item.Id,
RequsitionId = item.RequsitionId,
EmployeeId = item.EmployeeId,
Comments = item.Comments,
UserName = item.UserName,
CommentTime = item.CommentTime,
IsReceiverSeen = item.IsReceiverSeen,
ReceiverSeenTime = item.ReceiverSeenTime,
SenderEmployee = item.SenderEmployee,
SenderEmployeeId = (int)item.SenderEmployeeId,
ReceiverEmployee = item.ReceiverEmployee,
ReceiverEmployeeId = (int)item.ReceiverEmployeeId
};
commentListViewModel.Add(cmnt);
}
assignVm.CommentViewModels = commentListViewModel;
}
public JsonResult JsonCreate(RequsitionCreateViewModel requisitionVm)
{
//newDateTime = date.Date + time.TimeOfDay;
if (ModelState.IsValid)
{
var journeyStart = requisitionVm.JourneyStartDate.Date + requisitionVm.JourneyStartTime.TimeOfDay;
var jouneyEnd = requisitionVm.JouneyEndDate.Date + requisitionVm.JouneyEndTime.TimeOfDay;
Requsition requisition = new Requsition();
requisition.Form = requisitionVm.Form;
requisition.To = requisitionVm.To;
requisition.RequsitionNumber = AutoNumber();
requisition.Description = requisitionVm.Description;
requisition.JourneyStart = journeyStart;
requisition.JouneyEnd = jouneyEnd;
requisition.EmployeeId = requisitionVm.EmployeeId;
bool isSaved = _requisitionManager.Add(requisition);
if (isSaved)
{
TempData["msg"] = "Requisition Send Successfully";
}
else
{
TempData["msg"] = "Requisition not Send !";
}
}
else
{
TempData["msg"] = "Requisition not Send !";
}
return(Json(TempData["msg"], JsonRequestBehavior.AllowGet));
}
public ActionResult Details_V2(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Requsition requisition = _requisitionManager.GetById((int)id);
var userEmployeeId = GetEmployeeId();
ViewBag.UserEmployeeId = userEmployeeId;
var driverId = 0;
var vehicleId = 0;
switch (requisition.Status)
{
case "Assign":
driverId = driverStatusManager.Get(c => c.RequsitionId == id && c.Status == "Assign").Select(c => c.EmployeeId).FirstOrDefault();
vehicleId = vehicleStatusManager.Get(c => c.RequsitionId == id && c.Status == "Assign").Select(c => c.VehicleId).FirstOrDefault();
break;
case "Complete":
driverId = driverStatusManager.Get(c => c.RequsitionId == id && c.Status == "Complete").Select(c => c.EmployeeId).FirstOrDefault();
vehicleId = vehicleStatusManager.Get(c => c.RequsitionId == id && c.Status == "Complete").Select(c => c.VehicleId).FirstOrDefault();
break;
}
//if (requisition.Status == "Assign")
//{
// driverId = driverStatusManager.Get(c => c.RequsitionId == id && c.Status== "Assign").Select(c => c.EmployeeId).FirstOrDefault();
// vehicleId = vehicleStatusManager.Get(c => c.RequsitionId == id && c.Status == "Assign").Select(c => c.VehicleId).FirstOrDefault();
//}
//if (requisition.Status == "Complete")
//{
// driverId = driverStatusManager.Get(c => c.RequsitionId == id && c.Status == "Complete").Select(c => c.EmployeeId).FirstOrDefault();
// vehicleId = vehicleStatusManager.Get(c => c.RequsitionId == id && c.Status == "Complete").Select(c => c.VehicleId).FirstOrDefault();
//}
if (!User.IsInRole("Controller"))
{
if (requisition.EmployeeId != userEmployeeId && requisition.RequestedBy != userEmployeeId && driverId != userEmployeeId)
{
TempData["msg"] = "Sorry, you have no permission to access this type of data!";
return(RedirectToAction("Dashboard", "Home"));
}
}
AssignedListViewModel assignVm = new AssignedListViewModel
{
Requisition = requisition,
Employee = _employeeManager.GetById((int)requisition.EmployeeId),
Driver = _employeeManager.GetById(driverId),
Vehicle = vehicleManager.GetById(vehicleId)
};
GetCommentViewModelForInsertComment(requisition, userEmployeeId, assignVm);
//Collect the list of comment to display the list under comment
GetCommentList(requisition, assignVm);
return(View(assignVm));
}
public ActionResult MyJsonCreate(MyRequsitionCreateViewModel requisitionVm)
{
//newDateTime = date.Date + time.TimeOfDay;
//TempData["msg"] = null;
ViewBag.Message = null;
List <MyRequsitionListViewModel> requsitionViewList;
if (ModelState.IsValid)
{
int requestForEmployeeId;
if (requisitionVm.RequestForOther == false)
{
requestForEmployeeId = GetEmployeeId();
}
else
{
requestForEmployeeId = (int)requisitionVm.EmployeeId;
}
DateTime journyStartDate = (DateTime)requisitionVm.JourneyStartDate;
var journeyStart = journyStartDate.Date + requisitionVm.JourneyStartTime.TimeOfDay;
DateTime jouneyEndDate = (DateTime)requisitionVm.JouneyEndDate;
var jouneyEnd = jouneyEndDate.Date + requisitionVm.JouneyEndTime.TimeOfDay;
Requsition requisition = new Requsition();
requisition.Form = requisitionVm.Form;
requisition.To = requisitionVm.To;
requisition.RequsitionNumber = AutoNumber();
requisition.Description = requisitionVm.Description;
requisition.JourneyStart = journeyStart;
requisition.JouneyEnd = jouneyEnd;
requisition.EmployeeId = requestForEmployeeId;
requisition.RequestedBy = GetEmployeeId();
requisition.RequestType = requisitionVm.RequestType;
bool isSaved = _requisitionManager.Add(requisition);
if (isSaved)
{
//TempData["msg"] = "Requisition Send Successfully";
ViewBag.Message = "Requisition Send Successfully";
}
else
{
//TempData["msg"] = "Requisition not Send !";
ViewBag.Message = "Requisition not Send !";
}
requsitionViewList = MyRequisitionListView();
return(PartialView("_MyRequisitionListPartial", requsitionViewList));
}
//TempData["msg"] = "Requisition not Send !";
ViewBag.Message = "Requisition not Send !";
requsitionViewList = MyRequisitionListView();
return(PartialView("_MyRequisitionListPartial", requsitionViewList));
}
public ActionResult Edit(EditRequisitionViewModel requisitionVm)
{
try
{
if (ModelState.IsValid)
{
int requestForEmployeeId;
if (requisitionVm.RequestForOther == false)
{
requestForEmployeeId = GetEmployeeId();
}
else
{
requestForEmployeeId = (int)requisitionVm.EmployeeId;
}
DateTime journyStartDate = (DateTime)requisitionVm.JourneyStartDate;
var journeyStart = journyStartDate.Date + requisitionVm.JourneyStartTime.TimeOfDay;
DateTime jouneyEndDate = (DateTime)requisitionVm.JouneyEndDate;
var jouneyEnd = jouneyEndDate.Date + requisitionVm.JouneyEndTime.TimeOfDay;
Requsition requisition = _requisitionManager.GetById((int)requisitionVm.Id);
requisition.Form = requisitionVm.Form;
requisition.To = requisitionVm.To;
requisition.Description = requisitionVm.Description;
requisition.JourneyStart = journeyStart;
requisition.JouneyEnd = jouneyEnd;
requisition.EmployeeId = requestForEmployeeId;
requisition.RequestedBy = GetEmployeeId();
requisition.RequestType = requisitionVm.RequestType;
bool isUpdated = _requisitionManager.Update(requisition);
if (isUpdated)
{
TempData["msg"] = "Requisition Updated Successfully";
}
else
{
TempData["msg"] = "Requisition Not Updated !";
}
}
return(RedirectToAction("Dashboard", "Home"));
}
catch
{
return(View());
}
}
public ActionResult Print_V2(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Requsition requisition = _requisitionManager.GetById((int)id);
var driverId = driverStatusManager.Get(c => c.RequsitionId == id).Select(c => c.EmployeeId).FirstOrDefault();
var vehicleId = vehicleStatusManager.Get(c => c.RequsitionId == id).Select(c => c.VehicleId).FirstOrDefault();
AssignedListViewModel assignVm = new AssignedListViewModel
{
Requisition = requisition,
Employee = _employeeManager.GetById((int)requisition.EmployeeId),
Driver = _employeeManager.GetById(driverId),
Vehicle = vehicleManager.GetById(vehicleId)
};
List <ManagerViewModel> managerViewModels = new List <ManagerViewModel>();
var managersVM = new ManagerViewModel
{
Id = assignVm.Id,
EmployeeName = assignVm.Employee.Name,
EmployeNumber = assignVm.Employee.ContactNo,
JourneyEnd = assignVm.Requisition.JouneyEnd,
To = assignVm.Requisition.To,
Description = assignVm.Requisition.Description,
JourneyStart = assignVm.Requisition.JourneyStart,
DriverName = assignVm.Driver.Name,
VehicleModel = assignVm.Vehicle.Name,
Designation = assignVm.Employee.Designation.Name
};
managerViewModels.Add(managersVM);
string reportpath = Request.MapPath(Request.ApplicationPath) + @"Report\AssignRequsition\RequsitionAssignRDLC.rdlc";
var reportViewer = new ReportViewer()
{
KeepSessionAlive = true,
SizeToReportContent = true,
Width = Unit.Percentage(100),
ProcessingMode = ProcessingMode.Local
};
reportViewer.LocalReport.ReportPath = reportpath;
ReportDataSource rds = new ReportDataSource("AssignRequsition", managerViewModels);
reportViewer.LocalReport.DataSources.Add(rds);
ViewBag.ReportViewer = reportViewer;
return(View(managerViewModels));
}
public JsonResult MyJsonCreate(MyRequsitionCreateViewModel requisitionVm)
{
//newDateTime = date.Date + time.TimeOfDay;
if (ModelState.IsValid)
{
int requestForEmployeeId;
if (requisitionVm.RequestForOther == false)
{
requestForEmployeeId = GetEmployeeId();
}
else
{
requestForEmployeeId = (int)requisitionVm.EmployeeId;
}
DateTime journyStartDate = (DateTime)requisitionVm.JourneyStartDate;
var journeyStart = journyStartDate.Date + requisitionVm.JourneyStartTime.TimeOfDay;
DateTime jouneyEndDate = (DateTime)requisitionVm.JouneyEndDate;
var jouneyEnd = jouneyEndDate.Date + requisitionVm.JouneyEndTime.TimeOfDay;
Requsition requisition = new Requsition();
requisition.Form = requisitionVm.Form;
requisition.To = requisitionVm.To;
requisition.RequsitionNumber = AutoNumber();
requisition.Description = requisitionVm.Description;
requisition.JourneyStart = journeyStart;
requisition.JouneyEnd = jouneyEnd;
requisition.EmployeeId = requestForEmployeeId;
requisition.RequestedBy = GetEmployeeId();
requisition.RequestType = requisitionVm.RequestType;
bool isSaved = _requisitionManager.Add(requisition);
if (isSaved)
{
TempData["msg"] = "Requisition Send Successfully";
}
else
{
TempData["msg"] = "Requisition not Send !";
}
return(Json(TempData["msg"], JsonRequestBehavior.AllowGet));
}
TempData["msg"] = "Requisition not Send !";
return(Json(TempData["msg"], JsonRequestBehavior.AllowGet));
}
public ActionResult Complete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Requsition requsition = _requsitionManager.GetById((int)id);
if (requsition.JouneyEnd == requsition.JourneyStart)
{
return(RedirectToAction("Complete"));
}
return(View());
}
// GET: Requsition/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Requsition requsition = _requsitionManager.GetById((int)id);
if (requsition == null)
{
return(HttpNotFound());
}
return(View(requsition));
}
private void GetCommentViewModelForInsertComment(Requsition requisition, int userEmployeeId, AssignedListViewModel assignVm)
{
int? emplId = requisition.EmployeeId;
string employeeNam = requisition.Employee.Name;
var comment = new CommentViewModel
{
EmployeeId = (int)emplId,
EmployeName = employeeNam,
RequsitionId = requisition.Id,
SenderEmployeeId = userEmployeeId,
ReceiverEmployees = _employeeManager.Get(c => c.UserRole == "Controller")
};
assignVm.CommentViewModel = comment;
}
// GET: Requsition/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
Requsition requisition = _requisitionManager.GetById((int)id);
bool isRemove = _requisitionManager.Remove(requisition);
if (isRemove)
{
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult MyRequisitionList(MyRequsitionCreateViewModel requisitionVm)
{
if (ModelState.IsValid)
{
int requestForEmployeeId;
if (requisitionVm.RequestForOther == false)
{
requestForEmployeeId = GetEmployeeId();
}
else
{
requestForEmployeeId = (int)requisitionVm.EmployeeId;
}
DateTime journyStartDate = (DateTime)requisitionVm.JourneyStartDate;
var journeyStart = journyStartDate.Date + requisitionVm.JourneyStartTime.TimeOfDay;
DateTime jouneyEndDate = (DateTime)requisitionVm.JouneyEndDate;
var jouneyEnd = jouneyEndDate.Date + requisitionVm.JouneyEndTime.TimeOfDay;
Requsition requisition = new Requsition();
requisition.Form = requisitionVm.Form;
requisition.To = requisitionVm.To;
requisition.RequsitionNumber = AutoNumber();
requisition.Description = requisitionVm.Description;
requisition.JourneyStart = journeyStart;
requisition.JouneyEnd = jouneyEnd;
requisition.EmployeeId = requestForEmployeeId;
requisition.RequestedBy = GetEmployeeId();
requisition.RequestType = requisitionVm.RequestType;
bool isSaved = _requisitionManager.Add(requisition);
if (isSaved)
{
TempData["msg"] = "Requisition Send Successfully";
}
else
{
TempData["msg"] = "Requisition not Send !";
}
return(RedirectToAction("MyRequisitionList"));
}
requisitionVm.RequestTypes = GetRequisitionTypes();
TempData["msg"] = "Requisition not Send !";
return(View(requisitionVm));
}
public ActionResult AssignDetails(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Requsition requisition = _requisitionManager.GetById((int)id);
var driverId = driverStatusManager.Get(c => c.RequsitionId == id).Select(c => c.EmployeeId).FirstOrDefault();
var vehicleId = vehicleStatusManager.Get(c => c.RequsitionId == id).Select(c => c.VehicleId).FirstOrDefault();
AssignedListViewModel assignVm = new AssignedListViewModel
{
Requisition = requisition,
Employee = _employeeManager.GetById((int)requisition.EmployeeId),
Driver = _employeeManager.GetById(driverId),
Vehicle = vehicleManager.GetById(vehicleId)
};
return(View(assignVm));
}
// GET: Requsition/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
Requsition requsition = _requsitionManager.GetById((int)id);
RequsitionViewModel requsitionView = new RequsitionViewModel();
requsitionView.Id = requsition.Id;
requsitionView.Form = requsition.Form;
requsitionView.To = requsition.To;
requsitionView.Description = requsition.Description;
requsitionView.JourneyStart = requsition.JourneyStart;
requsitionView.JouneyEnd = requsition.JouneyEnd;
requsitionView.EmployeeId = requsition.EmployeeId;
ViewBag.EmployeeId = new SelectList(_employeeManager.GetAll(), "Id", "Name", requsition.EmployeeId);
return(View(requsitionView));
}
public ActionResult OnProgress()
{
Requsition requsition = new Requsition();
var data = _requsitionManager.GetAllBySeen(requsition.Status = "Seen");
var employee = _employeeManager.GetAll();
List <RequsitionViewModel> requsitionViewModels = new List <RequsitionViewModel>();
foreach (var allRequsition in data)
{
var requsitionVM = new RequsitionViewModel();
requsitionVM.Id = allRequsition.Id;
requsitionVM.Form = allRequsition.Form;
requsitionVM.To = allRequsition.To;
requsitionVM.Description = allRequsition.Description;
requsitionVM.JourneyStart = allRequsition.JourneyStart;
requsitionVM.JouneyEnd = allRequsition.JouneyEnd;
requsitionVM.Employee = employee.Where(x => x.Id == allRequsition.EmployeeId).FirstOrDefault();
requsitionViewModels.Add(requsitionVM);
}
return(View(requsitionViewModels));
}
public ActionResult Assign(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Requsition requsition = _requsitionManager.GetById((int)id);
var employee = _employeeManager.GetAll();
var vehicle = vehicleRepository.GetAll();
Manager manager = new Manager();
ManagerViewModel managerVM = new ManagerViewModel();
managerVM.Id = manager.Id;
managerVM.RequsitionId = requsition.Id;
//managerVM.EmployeeId = requsition.EmployeeId;
ViewBag.VehicleId = new SelectList(vehicleRepository.GetAll(), "Id", "VehicleName", manager.VehicleId);
ViewBag.EmployeeId = new SelectList(_employeeManager.GetAll(), "Id", "Name", manager.EmployeeId);
managerVM.VehicleId = manager.VehicleId;
return(View(managerVM));
}
public ActionResult Edit(RequsitionViewModel requsitionVM)
{
try
{
Requsition requsition = new Requsition();
requsition.Id = requsitionVM.Id;
requsition.Form = requsitionVM.Form;
requsition.To = requsitionVM.To;
requsition.Description = requsitionVM.Description;
requsition.JourneyStart = requsitionVM.JourneyStart;
requsition.JouneyEnd = requsitionVM.JouneyEnd;
requsition.EmployeeId = requsitionVM.EmployeeId;
requsition.RequsitionStatusId = requsitionVM.RequsitionStatusId;
_requsitionManager.Update(requsition);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult New()
{
Requsition requsitions = new Requsition();
var employee = _employeeManager.GetAll();
var requsition = _requsitionManager.GetAllByNull(requsitions.Status = null);
List <RequsitionViewModel> requsitionViewModels = new List <RequsitionViewModel>();
foreach (var data in requsition)
{
var requsitionVM = new RequsitionViewModel()
{
Id = data.Id,
Form = data.Form,
To = data.To,
Description = data.Description,
JourneyStart = data.JourneyStart,
JouneyEnd = data.JouneyEnd,
Employee = employee.Where(x => x.Id == data.EmployeeId).FirstOrDefault()
};
requsitionViewModels.Add(requsitionVM);
}
return(View(requsitionViewModels));
}
