public ActionResult Rejected(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VMS_SVisitor vms_svisitor = db.VMS_SVisitor.Find(id);
if (vms_svisitor != null)
{
vms_svisitor.Status = "Rejected";
db.SaveChanges();
if (vms_svisitor.Status == "Rejected")
{
var EName = db.EmpViews.First(aa => aa.EmployeeID == vms_svisitor.EmpID).FullName;
string Toadd = "*****@*****.**";
string subject = "Pending Visitor's Vehicle Access for Employee" + EName;
string body = "Dear Concerned, <br/> your request is Rejected. <br/> Employee Name: " + EName + "<br/> Visitor Name: " + vms_svisitor.VisitorName + "<br/> Vehicle No: " + vms_svisitor.VehicleNo + "<br/> Date Time: " + vms_svisitor.Arrival_Date.Value.ToShortDateString() + vms_svisitor.ArrivalTime + "<br/> Please Click on below link to procced further <a href='http://192.168.0.21/wms'>http://192.168.0.21/ESSP</a>";
EmailManager.SendEmail(Toadd, subject, body);
}
ViewUserEmp LoggedInUser = Session["LoggedUser"] as ViewUserEmp;
int TypeID = Convert.ToInt16(Utilities.NotificationType.PendingVisitorEntry);
string TypeName = Utilities.NotificationType.PendingVisitorEntry.ToString().Replace("_", " ");
int EmployeeID = LoggedInUser.EmpID ?? 0;
Utilities.DeleteNotification(vms_svisitor.ID, Convert.ToInt16(Utilities.NotificationType.PendingVisitorEntry));
Utilities.InsertEMPNotification(TypeID, TypeName, EmployeeID, id ?? 0, vms_svisitor.EmpID ?? 0, BaseURL + "Attendance/ScheduleVisitor/Index");
ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;
AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Visitor_Entry), Convert.ToInt16(AuditManager.AuditOperation.Reject), DateTime.Now, (int)id);
return(RedirectToAction("ListOfPendingVisitor"));
}
return(RedirectToAction("ListOfPendingVisitor"));
}
public ActionResult DeleteConfirmed(int id)
{
VMS_SVisitor vms_svisitor = db.VMS_SVisitor.Find(id);
db.VMS_SVisitor.Remove(vms_svisitor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: /Attendance/ScheduleVisitor/Create
public ActionResult Create()
{
ViewBag.VisitTypeID = new SelectList(db.VMS_VisitType, "PVisitTypeID", "PVisitTypeName");
ViewBag.ReasonID = new SelectList(db.VMS_Reason, "PReasonID", "ReasonName");
VMS_SVisitor vs = new VMS_SVisitor();
vs.Arrival_Date = DateTime.Today;
return(View(vs));
}
public ActionResult Edit([Bind(Include = "EmpID,VisitorName,Company,VehicleAccess,VehicleNo,CDateTime,ApprovedDate,Status,Arrival_Date")] VMS_SVisitor vms_svisitor)
{
if (ModelState.IsValid)
{
db.Entry(vms_svisitor).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;
AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Visitor_Entry), Convert.ToInt16(AuditManager.AuditOperation.Edit), DateTime.Now, (int)vms_svisitor.ID);
return(RedirectToAction("Index"));
}
return(View(vms_svisitor));
}
// GET: /Attendance/ScheduleVisitor/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VMS_SVisitor vms_svisitor = db.VMS_SVisitor.Find(id);
if (vms_svisitor == null)
{
return(HttpNotFound());
}
return(View(vms_svisitor));
}
private bool CheckForValidations(List <VMS_SVisitor> queryable, VMS_SVisitor vms_svisitor)
{
bool check = false;
foreach (var item in queryable)
{
DateTime dts = new DateTime();
DateTime dte = new DateTime();
while (dts <= dte)
{
if (dts == vms_svisitor.Arrival_Date.Value)
{
check = true;
}
dts = dts.AddDays(1);
}
}
return(check);
}
public ActionResult Create([Bind(Include = "EmpID,VisitorName,Company,VehicleAccess,VehicleNo,CDateTime,ApprovedDate,Status,ArrivalTime,Arrival_Date,VisitTypeID,ReasonID,Remarks")] VMS_SVisitor vms_svisitor)
{
ViewUserEmp LoggedInUser = Session["LoggedUser"] as ViewUserEmp;
if (CheckForValidations(db.VMS_SVisitor.Where(aa => aa.EmpID == LoggedInUser.EmployeeID || aa.Status == "Approved" || aa.Status == "Pending").ToList(), vms_svisitor))
{
ViewBag.VisitTypeID = new SelectList(db.VMS_VisitType, "PVisitTypeID", "PVisitTypeName");
ViewBag.ReasonID = new SelectList(db.VMS_Reason, "PReasonID", "ReasonName");
ModelState.AddModelError("DateStarted", "You already have applied on this date");
return(View(vms_svisitor));
}
else
{
var AM = DateTime.Now.ToString("08:30:00");
var PM = DateTime.Now.ToString("16:30:00");
if (vms_svisitor.ArrivalTime >= Convert.ToDateTime(AM) && vms_svisitor.ArrivalTime <= Convert.ToDateTime(PM))
{
DateTime CurrentTime = DateTime.Today;
DateTime time = DateTime.Now;
if (vms_svisitor.ArrivalTime >= time)
{
VMS_SVisitor obj = new VMS_SVisitor();
List <VMS_SVisitor> vms = db.VMS_SVisitor.Where(aa => aa.VisitorName == obj.VisitorName && aa.Arrival_Date == obj.Arrival_Date && aa.Company == obj.Company).ToList();
if (vms.Count() > 0)
{
ModelState.AddModelError("VisitorName", "Visitor name must be unique");
}
int RecordID = 0;
//var time = DateTime.Now.TimeOfDay;
//vms_svisitor.ArrivalTime = time;
//if (ModelState.IsValid)
{
DateTime date = DateTime.Today;
if (vms_svisitor.Arrival_Date >= date)
{
// ViewUserEmp LoggedInUser = Session["LoggedUser"] as ViewUserEmp;
if (string.IsNullOrEmpty(vms_svisitor.VisitorName))
{
ModelState.AddModelError("VisitorName", "Visitor Name is required!");
}
else
{
vms_svisitor.EmpID = LoggedInUser.EmployeeID;
if (vms_svisitor.VehicleAccess == "true")
{
vms_svisitor.Status = "Pending";
}
else
{
vms_svisitor.Status = "Approved";
}
if (LoggedInUser.UserType == "E")
{
vms_svisitor.Status = "Approved";
}
//ViewBag.VisitTypeID = new SelectList(db.VMS_VisitType, "PVisitTypeID", "PVisitTypeName", vms_svisitor.VisitTypeID);
//ViewBag.ReasonID = new SelectList(db.VMS_Reason, "PReasonID", "ReasonName", vms_svisitor.ReasonID);
if (ModelState.IsValid)
{
vms_svisitor.CDateTime = DateTime.Now;
db.VMS_SVisitor.Add(vms_svisitor);
db.SaveChanges();
if (vms_svisitor.VehicleAccess == "true")
{
var EName = db.EmpViews.First(aa => aa.EmployeeID == vms_svisitor.EmpID).FullName;
string Toadd = "*****@*****.**";
string subject = "Pending Visitor's Vehicle Access for Employee" + EName;
string body = "Dear Sir/Madam, <br/> A new visitor entry is awaited for your approval. Details are Listed below <br/> Employee Name: " + EName + "<br/> Visitor Name: " + vms_svisitor.VisitorName + "<br/> Vehicle No: " + vms_svisitor.VehicleNo + "<br/> Date Time: " + vms_svisitor.Arrival_Date.Value.ToShortDateString() + vms_svisitor.ArrivalTime + "<br/> Please Click on below link to procced further <a href='http://192.168.0.21/wms'>http://192.168.0.21/ESSP</a>";
EmailManager.SendEmail(Toadd, subject, body);
}
RecordID = vms_svisitor.ID;
int TypeID = Convert.ToInt16(Utilities.NotificationType.PendingVisitorEntry);
string TypeName = Utilities.NotificationType.PendingVisitorEntry.ToString().Replace("_", " ");
int EmployeeID = LoggedInUser.EmpID ?? 0;
int Sid = 13479;
Utilities.InsertEMPNotification(TypeID, TypeName, EmployeeID, RecordID, Sid, BaseURL + "Attendance/ScheduleVisitor/ListOfPendingVisitor");
ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;
AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Visitor_Entry), Convert.ToInt16(AuditManager.AuditOperation.Add), DateTime.Now, (int)vms_svisitor.ID);
if (vms_svisitor.VehicleAccess == "true")
{
string Subject = "Pending Visitor's Vehicle Access";
string Body = "";
}
}
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.Date = "can not insert previous date";
}
}
ViewBag.VisitTypeID = new SelectList(db.VMS_VisitType, "PVisitTypeID", "PVisitTypeName");
ViewBag.ReasonID = new SelectList(db.VMS_Reason, "PReasonID", "ReasonName");
return(View(vms_svisitor));
}
else
{
ViewBag.VisitTypeID = new SelectList(db.VMS_VisitType, "PVisitTypeID", "PVisitTypeName");
ViewBag.ReasonID = new SelectList(db.VMS_Reason, "PReasonID", "ReasonName");
ViewBag.TimeError = "Time increment must be greater than current time";
return(View(vms_svisitor));
}
}
else
{
ViewBag.VisitTypeID = new SelectList(db.VMS_VisitType, "PVisitTypeID", "PVisitTypeName");
ViewBag.ReasonID = new SelectList(db.VMS_Reason, "PReasonID", "ReasonName");
ViewBag.TimeError = "Incorrenct Time";
return(View(vms_svisitor));
}
}
}
