private List <RequsitionViewModel> RequisitionListView()
{
GetRequisitionComplete();
var allRequisitions = _requisitionManager.GetAll().OrderByDescending(c => c.Id);
var employee = _employeeManager.GetAll();
//var requstionStatus = _requsitionStatusManager.GetAll();
List <RequsitionViewModel> requisitionViewList = new List <RequsitionViewModel>();
foreach (var requisition in allRequisitions)
{
var requisitionVM = new RequsitionViewModel();
requisitionVM.Id = requisition.Id;
requisitionVM.Form = requisition.Form;
requisitionVM.To = requisition.To;
requisitionVM.Description = requisition.Description;
requisitionVM.JourneyStart = requisition.JourneyStart;
requisitionVM.JouneyEnd = requisition.JouneyEnd;
requisitionVM.Employee = employee.Where(x => x.Id == requisition.EmployeeId).FirstOrDefault();
requisitionVM.Status = requisition.Status;
requisitionViewList.Add(requisitionVM);
}
return(requisitionViewList);
}
public ActionResult SearchCompleteRequsition(FilteringSearchViewModel filteringSearchViewModels)
{
var userEmployeeId = GetEmployeeId();
ViewBag.UserEmployeeId = userEmployeeId;
var startTime = filteringSearchViewModels.Startdate;
var endTime = filteringSearchViewModels.EndDate;
var searchingValue = _requisitionManager.Get(c => c.Status == "Complete" && c.IsDeleted == false).Where(r => r.RequestedBy == userEmployeeId || r.EmployeeId == userEmployeeId);
var completeRequsitionList = searchingValue.Where(c => c.JourneyStart >= startTime && c.JouneyEnd <= endTime);
List <RequsitionViewModel> requsitionViewModels = new List <RequsitionViewModel>();
foreach (var item in completeRequsitionList)
{
var requisitionVM = new RequsitionViewModel();
requisitionVM.Id = item.Id;
requisitionVM.Employee = item.Employee;
requisitionVM.Form = item.Form;
requisitionVM.To = item.To;
requisitionVM.Description = item.Description;
requisitionVM.JourneyStart = item.JourneyStart;
requisitionVM.JouneyEnd = item.JouneyEnd;
requsitionViewModels.Add(requisitionVM);
}
filteringSearchViewModels.RequsitionViewModels = requsitionViewModels;
return(PartialView("_CompleteRequsitionPartial", requsitionViewModels));
}
// GET: Requsition/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Requsition requsition = _requsitionManager.GetById((int)id);
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.Description = requsition.Description;
requsitionViewModel.Employee = employee.Where(c => c.Id == requsition.EmployeeId).FirstOrDefault();
requsitionViewModel.Manager = manager.Where(c => c.RequsitionId == requsition.Id).FirstOrDefault();
if (requsition == null)
{
return(HttpNotFound());
}
return(View(requsitionViewModel));
}
// 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));
}
public ActionResult Index()
{
//GetRequisitionComplete();
var allRequisitions = _requisitionManager.GetAll();
var employee = _employeeManager.GetAll();
//var requstionStatus = _requsitionStatusManager.GetAll();
List <RequsitionViewModel> requisitionViewList = new List <RequsitionViewModel>();
foreach (var requisition in allRequisitions)
{
var requisitionVM = new RequsitionViewModel();
requisitionVM.Id = requisition.Id;
requisitionVM.Form = requisition.Form;
requisitionVM.To = requisition.To;
requisitionVM.Description = requisition.Description;
requisitionVM.JourneyStart = requisition.JourneyStart;
requisitionVM.JouneyEnd = requisition.JouneyEnd;
requisitionVM.Employee = employee.Where(x => x.Id == requisition.EmployeeId).FirstOrDefault();
requisitionVM.Status = requisition.Status;
requisitionViewList.Add(requisitionVM);
}
return(View(requisitionViewList));
}
public ActionResult AssignedList()
{
var userEmployeeId = GetEmployeeId();
ViewBag.UserEmployeeId = userEmployeeId;
var searchingValue =
_requisitionManager.Get(c => c.Status == "Assign" && c.IsDeleted == false).Where(c => c.EmployeeId == userEmployeeId).OrderByDescending(c => c.Id);
List <RequsitionViewModel> requsitionViewModels = new List <RequsitionViewModel>();
foreach (var item in searchingValue)
{
var requisitionVM = new RequsitionViewModel();
requisitionVM.Id = item.Id;
requisitionVM.Employee = item.Employee;
requisitionVM.Form = item.Form;
requisitionVM.To = item.To;
requisitionVM.StartTime = item.JourneyStart.ToString("f");
requisitionVM.EndTime = item.JouneyEnd.ToString("f");
requisitionVM.RequsitionNumber = item.RequsitionNumber;
requisitionVM.Description = item.Description;
requisitionVM.JourneyStart = item.JourneyStart;
requisitionVM.JouneyEnd = item.JouneyEnd;
requsitionViewModels.Add(requisitionVM);
}
return(View(requsitionViewModels));
}
public ActionResult HoldList()
{
var userEmployeeId = GetEmployeeId();
ViewBag.UserEmployeeId = userEmployeeId;
var requsition = _requisitionManager.Get(c => c.Status == "Hold").Where(c => c.EmployeeId == userEmployeeId);;
List <RequsitionViewModel> requsitionViewModels = new List <RequsitionViewModel>();
foreach (var data in requsition)
{
var requsitionVM = new RequsitionViewModel()
{
Id = data.Id,
Form = data.Form,
To = data.To,
RequsitionNumber = data.RequsitionNumber,
Description = data.Description,
JourneyStart = data.JourneyStart,
JouneyEnd = data.JouneyEnd,
Employee = data.Employee
};
requsitionViewModels.Add(requsitionVM);
}
return(View(requsitionViewModels));
}
public ActionResult Complete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var employee = _employeeManager.GetAll();
var requsition = _requsitionManager.GetById((int)id);
RequsitionViewModel requsitionVM = new RequsitionViewModel()
{
Id = requsition.Id,
Form = requsition.Form,
To = requsition.To,
Description = requsition.Description,
JourneyStart = requsition.JourneyStart,
JouneyEnd = requsition.JouneyEnd,
Employee = employee.Where(x => x.Id == requsition.EmployeeId).FirstOrDefault()
};
if (requsitionVM.JourneyStart == requsitionVM.JouneyEnd)
{
requsition.Status = "Complete";
_requsitionManager.Update(requsition);
return(RedirectToAction("Assign"));
}
return(View());
}
public ActionResult CompleteRequsition()
{
var userEmployeeId = GetEmployeeId();
ViewBag.UserEmployeeId = userEmployeeId;
var searchingValue = _requisitionManager.Get(c => c.Status == "Complete" && c.IsDeleted == false).Where(c => c.EmployeeId == userEmployeeId).OrderByDescending(c => c.JourneyStart);;
string todays = DateTime.Today.ToShortDateString();
var todayRequsition = searchingValue.Where(c => c.JouneyEnd.ToShortDateString() == todays);
FilteringSearchViewModel filteringSearchViewModel = new FilteringSearchViewModel();
List <RequsitionViewModel> requsitionViewModels = new List <RequsitionViewModel>();
foreach (var item in todayRequsition)
{
var requisitionVM = new RequsitionViewModel();
requisitionVM.Id = item.Id;
requisitionVM.Employee = item.Employee;
requisitionVM.Form = item.Form;
requisitionVM.To = item.To;
requisitionVM.Description = item.Description;
requisitionVM.JourneyStart = item.JourneyStart;
requisitionVM.JouneyEnd = item.JouneyEnd;
requsitionViewModels.Add(requisitionVM);
}
filteringSearchViewModel.RequsitionViewModels = requsitionViewModels;
//var designation = designationManager.GetAll();
//filteringSearchViewModel.Designations = designation;
return(View(filteringSearchViewModel));
}
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/Create
public ActionResult Create()
{
var employees = _employeeManager.Get(c => c.IsDriver == false && c.IsDeleted == false);
RequsitionViewModel requsitionVM = new RequsitionViewModel();
requsitionVM.Employees = employees;
return(View(requsitionVM));
}
// GET: Requsition/Create
public ActionResult Create()
{
var employee = _employeeManager.GetAll();
var requstionStatus = _requsitionStatusManager.GetAll();
RequsitionViewModel requsitionVM = new RequsitionViewModel();
requsitionVM.Employees = employee;
requsitionVM.RequsitionStatuses = requstionStatus;
return(View(requsitionVM));
}
public ActionResult CreateComment(RequsitionViewModel requsitionViewModel)
{
Comment comment = new Comment();
comment.RequsitionId = requsitionViewModel.Id;
comment.Comments = requsitionViewModel.CommentViewModel.Comments;
bool isSaved = commentManager.Add(comment);
if (isSaved)
{
return(RedirectToAction("Details"));
}
return(View());
}
public ActionResult Create(RequsitionViewModel RequsitionViewModel)
{
try
{
Comment comment = new Comment();
comment.RequsitionId = RequsitionViewModel.Id;
comment.Comments = RequsitionViewModel.CommentViewModel.Comments;
commentManager.Add(comment);
return(RedirectToAction("Details", "Requsition"));
}
catch
{
return(View());
}
}
public ActionResult Print(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var requsition = _requisitionManager.GetById((int)id);
var emplt = requsition.Employee.Name;
var empltNo = requsition.Employee.ContactNo;
var dept = requsition.Employee.Department.Name;
var des = requsition.Employee.Designation.Name;
var startdate = requsition.JourneyStart.ToString("f");
var enddate = requsition.JouneyEnd.ToString("f");
List <RequsitionViewModel> requsitionViewModels = new List <RequsitionViewModel>();
var requsitionVM = new RequsitionViewModel();
requsitionVM.DepartmentName = dept;
requsitionVM.EmployeeName = emplt;
requsitionVM.DesignationName = des;
requsitionVM.EmployeeNo = empltNo;
requsitionVM.Form = requsition.Form;
requsitionVM.To = requsition.To;
requsitionVM.Description = requsition.Description;
requsitionVM.StartTime = startdate;
requsitionVM.EndTime = enddate;
requsitionVM.JouneyEnd = requsition.JouneyEnd;
requsitionVM.RequsitionNumber = requsition.RequsitionNumber;
requsitionViewModels.Add(requsitionVM);
string reportpath = Request.MapPath(Request.ApplicationPath) + @"Report\RequsitionDetails\RequsitionDetailsRDLC.rdlc";
var reportViewer = new ReportViewer()
{
KeepSessionAlive = true,
SizeToReportContent = true,
Width = Unit.Percentage(100),
ProcessingMode = ProcessingMode.Local
};
reportViewer.LocalReport.ReportPath = reportpath;
ReportDataSource rds = new ReportDataSource("DataSet1", requsitionViewModels);
reportViewer.LocalReport.DataSources.Add(rds);
ViewBag.ReportViewer = reportViewer;
return(View(requsitionViewModels));
}
// 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 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;
_requsitionManager.Update(requsition);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Complete()
{
var requsition = _requsitionManager.Get(c => c.Status == "Complete" && c.IsDeleted == false);
var employee = _employeeManager.Get(c => c.IsDriver == false);
List <RequsitionViewModel> requsitionViewModels = new List <RequsitionViewModel>();
foreach (var Data in requsition)
{
var requsitionVM = new RequsitionViewModel();
requsitionVM.Id = Data.Id;
requsitionVM.Employee = employee.Where(c => c.Id == Data.EmployeeId).FirstOrDefault();
requsitionVM.Description = Data.Description;
requsitionVM.JourneyStart = Data.JourneyStart;
requsitionVM.JouneyEnd = Data.JouneyEnd;
requsitionVM.Form = Data.Form;
requsitionVM.To = Data.To;
requsitionViewModels.Add(requsitionVM);
}
return(View(requsitionViewModels));
}
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));
}//details
