public ActionResult Delete(string id, FormCollection collection)
{
try
{
// TODO: Add delete logic here
using (VC_LMSEntities d = new VC_LMSEntities())
{
var row = d.UsersTables.Where(x => x.EMPLOYEE_ID == id && x.ROLES == "Admin").FirstOrDefault();
if (row != null)
{
ViewBag.Message = "Cannot delete Admin";
return(View());
}
foreach (var item in d.Leaves)
{
if (item.Employee_Id == id)
{
d.Leaves.Remove(item);
}
}
UsersTable usertable = d.UsersTables.Where(x => x.EMPLOYEE_ID == id).FirstOrDefault();
d.UsersTables.Remove(usertable);
d.SaveChanges();
}
return(RedirectToAction("view"));
}
catch
{
return(View());
}
}
public ActionResult Edit(int id)
{
VC_LMSEntities d = new VC_LMSEntities();
var row = d.Leaves.Where(x => x.ID == id).FirstOrDefault();
return(View(row));
}
public ActionResult Manager()
{
List <UsersTable> l = new List <UsersTable>();
VC_LMSEntities d = new VC_LMSEntities();
foreach (var item in d.UsersTables)
{
l.Add(item);
}
ViewData["Manager"] = new SelectList(l, "EMPLOYEE_ID", "FIRST_NAME");
return(View());
}
public ActionResult Editmyleave(int id)
{
VC_LMSEntities d = new VC_LMSEntities();
if (d.Leaves.Where(x => x.ID == id && (x.Status == "Pending on HR" || x.Status == "Pending on Approvers")).FirstOrDefault() != null)
{
return(View(d.Leaves.Where(x => x.ID == id).FirstOrDefault()));
}
else
{
ViewBag.Message = "Can't Edit Approved Leave";
return(RedirectToAction("myleave"));
}
}
public ActionResult myleave()
{
VC_LMSEntities d = new VC_LMSEntities();
List <Leave> leave = new List <Leave>();
foreach (var item in d.Leaves)
{
if (item.Employee_Id == Session["userID"].ToString())
{
leave.Add(item);
}
}
return(View(leave));
}
public ActionResult approvals(int id)
{
VC_LMSEntities d = new VC_LMSEntities();
List <approval> ap = new List <approval>();
foreach (var item in d.approvals)
{
if (item.Leave_id == id)
{
ap.Add(item);
}
}
return(View(ap));
}
public ActionResult Edit(string id, LeaveManagementSystemValueCreed.Models.UsersTable user)
{
try
{
VC_LMSEntities d = new VC_LMSEntities();
List <RolesTable> r = new List <RolesTable>();
foreach (var item in d.RolesTables)
{
if (item.NAME != "Admin")
{
r.Add(item);
}
}
//ViewBag.Managers = new SelectList(d.managers, "manager_emp_id", "name");
ViewBag.Departments = new SelectList(d.department_tbl, "DEPARTMENT", "DEPARTMENT");
ViewBag.Roles = new SelectList(r, "NAME", "NAME");
if (user.Emp_end_date < user.Emp_start_date)
{
ViewBag.Message = "Date of Joining Can't be Before Date of Leaving";
return(View());
}
// TODO: Add update logic here
using (VC_LMSEntities db = new VC_LMSEntities())
{
//var row = db.managers.Where(x => x.manager_emp_id == manger_id).FirstOrDefault();
//if (row != null)
//{
// user.manager_name = row.name;
//}
//else
//{
// ViewBag.Message = "No Such Manager Exists,Please give correct input or Create a manager";
// return View();
//}
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit_now(int id)
{
VC_LMSEntities d = new VC_LMSEntities();
var row = d.Leaves.Where(x => x.ID == id).FirstOrDefault();
if (row.Status == "Cancelled" || row.Status == "Approved By Manager")
{
ViewBag.Message = "Cannot Edit this Leave";
return(View());
}
else
{
return(View(d.Leaves.Where(x => x.ID == id).FirstOrDefault()));
}
}
public ActionResult Index()
{
try
{
VC_LMSEntities d = new VC_LMSEntities();
int c = 0;
ViewBag.Name = Session["userName"].ToString();
return(View());
}
catch (Exception ex)
{
return(View("Index", "Login"));
}
}
public ActionResult view()
{
VC_LMSEntities d = new VC_LMSEntities();
//List<UsersTable> user = new List<UsersTable>();
List <UsersTable> user = d.UsersTables.ToList();
//foreach (var item in d.UsersTables)
//{
// if (item.EMPLOYEE_ID != (Session["usrID"]).ToString())
// {
// user.Add(item);
// }
//}
return(View(user));
}
public ActionResult myleave()
{
List <Leave> l = new List <Leave>();
VC_LMSEntities ds = new VC_LMSEntities();
foreach (var item in ds.Leaves)
{
if (item.Employee_Id.ToString() == Session["userID"].ToString())
{
l.Add(item);
}
}
List <Leave> leaves = ds.Leaves.ToList();
return(View(l));
}
public ActionResult Create()
{
VC_LMSEntities d = new VC_LMSEntities();
List <department_tbl> l = new List <department_tbl>();
List <RolesTable> r = new List <RolesTable>();
foreach (var item in d.RolesTables)
{
if (item.NAME != "Admin")
{
r.Add(item);
}
}
//ViewBag.Managers = new SelectList(d.managers, "manager_emp_id", "name");
ViewBag.Departments = new SelectList(d.department_tbl, "DEPARTMENT", "DEPARTMENT");
ViewBag.Roles = new SelectList(r, "NAME", "NAME");
return(View());
}
public ActionResult viewleave()
{
try
{
VC_LMSEntities d = new VC_LMSEntities();
List <Leave> leaves = new List <Leave>();
var a = (Session["userID"].ToString());
var aproverrow = d.approvers.Where(x => x.approver_id == a).FirstOrDefault();
List <approver> app = new List <approver>();
foreach (var apporver in d.approvers)
{
if (apporver.approver_id == a)
{
app.Add(apporver);
}
}
foreach (var row in app)
{
foreach (var leaf in d.Leaves)
{
if (leaf.Status == "Requested Approvers For Cancellation")
{
leaves.Add(leaf);
}
if (leaf.Employee_Id == row.Emplyoee_id && leaf.Status != "Cancelled" && leaf.Status != "Pending on Manager" && leaf.Status != "Rejected By Approver" && leaf.Status != "Rejected By HR" && leaf.Status != "Approved By HR")
{
var approval = d.approvals.Where(x => x.Aprrover_id == row.approver_id && x.Employee_id == row.Emplyoee_id && leaf.ID == x.Leave_id).FirstOrDefault();
if (approval == null)
{
leaves.Add(leaf);
}
}
}
}
return(View(leaves));
}
catch (Exception ex)
{
return(RedirectToAction("Index", "Login"));
}
}
public ActionResult Index()
{
try
{
VC_LMSEntities d = new VC_LMSEntities();
int c = 0;
var id = (Session["userID"].ToString());
var user = d.UsersTables.Where(x => x.EMPLOYEE_ID == id).FirstOrDefault();
string b = user.leaves_alloted.ToString();
ViewBag.leave = b;
ViewBag.Name = Session["userName"].ToString();
return(View());
}
catch (Exception ex)
{
return(RedirectToAction("Index", "Login"));
}
}
public ActionResult Edit(string id)
{
VC_LMSEntities d = new VC_LMSEntities();
List <department_tbl> l = new List <department_tbl>();
List <RolesTable> r = new List <RolesTable>();
foreach (var item in d.RolesTables)
{
if (item.NAME != "Admin")
{
r.Add(item);
}
}
//ViewBag.Managers = new SelectList(d.managers, "manager_emp_id", "name");
ViewBag.Departments = new SelectList(d.department_tbl, "DEPARTMENT", "DEPARTMENT");
ViewBag.Roles = new SelectList(r, "NAME", "NAME");
return(View(d.UsersTables.Where(x => x.EMPLOYEE_ID == id).FirstOrDefault()));
}
// GET: Employee/Edit/5
public ActionResult Edit(int id)
{
VC_LMSEntities d = new VC_LMSEntities();
if (d.Leaves.Where(x => x.Status == "Approved By HR" && x.ID == id && x.Start_Date > DateTime.Now).FirstOrDefault() != null)
{
g++;
return(View(d.Leaves.Where(x => x.ID == id).FirstOrDefault()));
}
if (d.Leaves.Where(x => x.ID == id && (x.Status == "Pending on Manager" || x.Status == "Pending on Approvers" || x.Status == "Pending on HR")).FirstOrDefault() != null)
{
return(View(d.Leaves.Where(x => x.ID == id).FirstOrDefault()));
}
else
{
ViewBag.Message = "Can't Edit Approved Leave";
return(RedirectToAction("Leave"));
}
}
public ActionResult Editmyleave(int id, LeaveManagementSystemValueCreed.Models.Leave leave)
{
try
{
using (VC_LMSEntities db = new VC_LMSEntities())
{
db.Entry(leave).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
// TODO: Add update logic here
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
string s = ex.Message;
return(View());
}
}
public ActionResult Leave()
{
try
{
VC_LMSEntities d = new VC_LMSEntities();
List <Leave> leave = new List <Leave>();
foreach (var item in d.Leaves)
{
if (item.Status != "Cancelled")
{
leave.Add(item);
}
}
return(View(leave));
}
catch (Exception ex)
{
return(View());
}
}
public ActionResult approverslist()
{
try
{
VC_LMSEntities d = new VC_LMSEntities();
List <approver> approvers = new List <approver>();
foreach (var item in d.approvers)
{
if (item.Emplyoee_id == Session["userId"].ToString())
{
approvers.Add(item);
}
}
return(View(approvers));
}
catch (Exception ex)
{
return(RedirectToAction("Index", "Login"));
}
}
public ActionResult Leave()
{
VC_LMSEntities d = new VC_LMSEntities();
List <Leave> leavelist = new List <Leave>();
//foreach (var item in d.UsersTables)
//{
// if (item.manager_id == (Session["userID"].ToString()))
// {
// foreach (var emplist in d.Leaves.ToList())
// {
// if ((item.EMPLOYEE_ID == emplist.Employee_Id) && (emplist.Status == "Pending on Manager"))
// {
// leavelist.Add(emplist);
// }
// }
// }
//}
return(View(leavelist));
}
public ActionResult Leave(LeaveManagementSystemValueCreed.Models.Leave user)
{
try
{
ViewBag.Message = Session["Message"];
List <Leave> l = new List <Leave>();
VC_LMSEntities ds = new VC_LMSEntities();
foreach (var item in ds.Leaves)
{
if (item.Employee_Id.ToString() == Session["userID"].ToString())
{
l.Add(item);
}
}
List <Leave> leaves = ds.Leaves.ToList();
return(View(l));
}
catch (Exception ex)
{
return(View());
}
//return RedirectToAction("Index", "Employee");
}
public ActionResult LeaveApply(LeaveManagementSystemValueCreed.Models.Leave leave)
{
var indian_zone = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
if (DateTime.Now.Date.Kind == DateTimeKind.Utc)
{
if (leave.Start_Date.Subtract(TimeZoneInfo.ConvertTimeFromUtc(DateTime.Now.Date, indian_zone)).Days > 360)
{
ViewBag.Message = "Cannot Apply for such date,as it is too Far";
return(View());
}
}
else
{
if (leave.Start_Date.Subtract(DateTime.Now.Date).Days > 360)
{
ViewBag.Message = "Cannot Apply for such date,as it is too Far";
return(View());
}
}
bool status = false;
string message = "";
if (DateTime.Now.Date.Kind != DateTimeKind.Utc)
{
var datediff = DateTime.Now.Date.Subtract(leave.End_Date);
if (datediff.TotalDays > 0)
{
ViewBag.Message = "Cannot Apply Leave if End Date is in the Past";
ViewBag.Status = false;
return(View());
}
}
else if (DateTime.Now.Date.Kind == DateTimeKind.Utc)
{
var datediff = TimeZoneInfo.ConvertTimeFromUtc(DateTime.Now.Date, indian_zone).Subtract(leave.End_Date);
if (datediff.TotalDays > 0)
{
ViewBag.Message = "Cannot Apply Leave if End Date is in the Past";
ViewBag.Status = false;
return(View());
}
}
if (leave.End_Date > leave.Start_Date)
{
int c = 0;
VC_LMSEntities dd = new VC_LMSEntities();
foreach (var item in dd.Leaves)
{
if ((Session["userID"].ToString()) == item.Employee_Id)
{
if ((item.Start_Date < leave.Start_Date) && (leave.End_Date < item.End_Date) && (item.Status != "Cancelled" || item.Status == "Approved By Approver" || item.Status == "Approved By Manager"))
{
ViewBag.Message = "Leave range falling under Another Leave Range ";
ViewBag.Status = false;
ModelState.Clear();
return(View());
}
else if ((item.Start_Date < leave.Start_Date) && (leave.End_Date < item.End_Date) && (item.Status != "Cancelled" || item.Status == "Approved By Approver" || item.Status == "Approved By Manager"))
{
ViewBag.Message = "Leave date conflict,Please Apply after previous leave Ends ";
ViewBag.Status = false;
ModelState.Clear();
return(View());
}
else if ((item.Start_Date < leave.Start_Date) && (leave.Start_Date < item.End_Date) && (item.Status != "Cancelled" || item.Status == "Approved By Approver" || item.Status == "Approved By Manager"))
{
ViewBag.Message = "Leave date conflict,Please Apply after previous leave Ends,or Edit ";
ViewBag.Status = false;
ModelState.Clear();
return(View());
}
if ((leave.Start_Date == item.Start_Date || leave.End_Date == item.End_Date) && item.Status != "Cancelled" || item.Status == "Approved By Approver" || item.Status == "Approved By Manager")
{
ViewBag.Message = "Matching Date For Already Applied Leave Found,Please Edit that Leave,if approved,then applya new Leave ";
ViewBag.Status = false;
ModelState.Clear();
return(View());
}
}
if (item.Employee_Id == (Session["userID"].ToString()) && (item.Status == "Pending on Manager" || item.Status == "Pending on Approver" || item.Status == "Approved By Approver" || item.Status == "Approved By Manager"))
{
c += item.Number_of_Days;
}
}
int x = Convert.ToInt32(Session["userID"]);
var account = dd.UsersTables.Where(a => a.EMPLOYEE_ID == x.ToString()).FirstOrDefault();
if (account.leaves_alloted == 0)
{
message = "Sorry Your Leave Balance is Zero and you cannot apply";
//return RedirectToAction("ApplyLeave");
status = false;
}
else
{
int e = 0;
var number_of_day = leave.End_Date.Date.Subtract(leave.Start_Date);
int number_of_days = 0;
number_of_days = number_of_day.Days;
int d = 0;
for (DateTime i = leave.Start_Date; i < leave.End_Date; i = i.AddDays(1))
{
if (i.DayOfWeek.ToString() == "Saturday" || i.DayOfWeek.ToString() == "Sunday")
{
e++;
}
}
number_of_days = number_of_days - e;
if ((c + number_of_days > account.leaves_alloted))
{
message = "Already Applied leaves Exceeds Your Leave Balance";
status = false;
ViewBag.Message = message;
ViewBag.Status = status;
}
else if (number_of_days <= account.leaves_alloted)
{
try
{
leave.Start_Date = leave.Start_Date.Date;
leave.End_Date = leave.End_Date.Date;
leave.Number_of_Days = number_of_days + 1;
leave.Leave_apply_date = TimeZoneInfo.ConvertTimeFromUtc(DateTime.Now.Date, indian_zone);
leave.Status = "Pending on Approvers";
leave.Employe_name = Session["userName"].ToString();
leave.Employee_Id = (Session["userID"].ToString());
using (VC_LMSEntities f = new VC_LMSEntities())
{
f.Leaves.Add(leave);
f.SaveChanges();
ModelState.Clear();
message = "Successfully Applied";
ViewBag.Status = status;
}
}
catch (Exception ex)
{
ViewBag.Message = "Exclude Special Characters from Reason";
return(View());
}
}
else
{
message = "Leave Applied for is greater than your Leave Balance";
ViewBag.Status = false;
}
}
}
else if (leave.End_Date < leave.Start_Date)
{
message = "End Date should be greater then Start Date";
status = false;
}
else if ((leave.End_Date == leave.Start_Date) && (leave.Start_Date == null))
{
message = "Cannot pass Null in Required Field";
status = false;
}
else if (leave.End_Date == leave.Start_Date)
{
try
{
leave.Start_Date = leave.Start_Date.Date;
leave.End_Date = leave.End_Date.Date;
leave.Number_of_Days = 1;
leave.Leave_apply_date = TimeZoneInfo.ConvertTimeFromUtc(DateTime.Now.Date, indian_zone);
leave.Status = "Pending on Approvers";
leave.Employe_name = Session["userName"].ToString();
leave.Employee_Id = (Session["userID"].ToString());
using (VC_LMSEntities f = new VC_LMSEntities())
{
f.Leaves.Add(leave);
f.SaveChanges();
ModelState.Clear();
message = "Successfully Applied";
ViewBag.Status = status;
}
}
catch (Exception ex)
{
ViewBag.Message = "Exclude Special Characters from Reason";
return(View());
}
}
ViewBag.Message = message;
ViewBag.Status = status;
ModelState.Clear();
return(View());
}
public ActionResult ApplyLeave(LeaveManagementSystemValueCreed.Models.Leave leave)
{
// leave.Start_Date = TimeZoneInfo.ConvertTimeToUtc(leave.Start_Date);
// leave.End_Date = TimeZoneInfo.ConvertTimeToUtc(leave.End_Date);
var months = leave.Start_Date.Subtract(DateTime.Now);
if (months.Days > 180)
{
ViewBag.Message = "Cannot Apply For more than 6 month in Advance";
return(View());
}
VC_LMSEntities r = new VC_LMSEntities();
var user_info = r.UsersTables.Where(w => w.EMPLOYEE_ID == leave.Employee_Id).FirstOrDefault();
var indian_zone = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
if (DateTime.Now.Date.Kind == DateTimeKind.Utc)
{
if (leave.Start_Date.Subtract(TimeZoneInfo.ConvertTimeFromUtc(DateTime.Now.Date, indian_zone)).Days > 360)
{
ViewBag.Message = "Cannot Apply for such date,as it is too Far";
return(View());
}
}
else
{
if (leave.Start_Date.Subtract(DateTime.Now.Date).Days > 360)
{
ViewBag.Message = "Cannot Apply for such date,as it is too Far";
return(View());
}
}
bool status = false;
string message = "";
if (DateTime.Now.Date.Kind != DateTimeKind.Utc)
{
var datediff = DateTime.Now.Date.Subtract(leave.End_Date.Date);
if (datediff.TotalDays > 0)
{
ViewBag.Message = "Cannot Apply Leave if End Date is in the Past";
ViewBag.Status = false;
return(View());
}
}
else if (DateTime.Now.Date.Kind == DateTimeKind.Utc)
{
var datediff = TimeZoneInfo.ConvertTimeFromUtc(DateTime.Now.Date, indian_zone).Subtract(leave.End_Date);
if (datediff.TotalDays > 0)
{
ViewBag.Message = "Cannot Apply Leave if End Date is in the Past";
ViewBag.Status = false;
return(View());
}
}
if (leave.End_Date > leave.Start_Date)
{
int c = 0;
VC_LMSEntities dd = new VC_LMSEntities();
foreach (var item in dd.Leaves)
{
if ((Session["userID"].ToString()) == item.Employee_Id)
{
if ((item.Start_Date < leave.Start_Date) && (leave.End_Date < item.End_Date) && (item.Status != "Cancelled"))
{
ViewBag.Message = "Leave range falling under Another Leave Range ";
ViewBag.Status = false;
ModelState.Clear();
return(View());
}
else if ((item.Start_Date < leave.Start_Date) && (leave.End_Date < item.End_Date) && (item.Status != "Cancelled"))
{
ViewBag.Message = "Leave date conflict,Please Apply after previous leave Ends ";
ViewBag.Status = false;
ModelState.Clear();
return(View());
}
else if ((item.Start_Date < leave.Start_Date) && (leave.Start_Date < item.End_Date) && (item.Status != "Cancelled"))
{
ViewBag.Message = "Leave date conflict,Please Apply after previous leave Ends,or Edit ";
ViewBag.Status = false;
ModelState.Clear();
return(View());
}
if ((leave.Start_Date == item.Start_Date || leave.End_Date == item.End_Date) && item.Status != "Cancelled")
{
ViewBag.Message = "Matching Date For Already Applied Leave Found,Please Cancel that Leave ";
ViewBag.Status = false;
ModelState.Clear();
return(View());
}
}
if (item.Employee_Id == (Session["userID"].ToString()) && (item.Status == "Pending on Manager" || item.Status == "Approved By Manager" || item.Status == "Pending on Approvers" || item.Status == "Approved By Approvers"))
{
c += item.Number_of_Days;
}
}
var x = (Session["userID"].ToString());
var account = dd.UsersTables.Where(a => a.EMPLOYEE_ID == x).FirstOrDefault();
if (account.leaves_alloted == 0)
{
message = "Sorry Your Leave Balance is Zero and you cannot apply";
//return RedirectToAction("ApplyLeave");
status = false;
}
else
{
int e = 0;
var number_of_day = leave.End_Date.Date.Subtract(leave.Start_Date.Date);
int number_of_days = 0;
number_of_days = number_of_day.Days + 1;
int d = 0;
VC_LMSEntities4 p = new VC_LMSEntities4();
for (DateTime i = leave.Start_Date; i <= leave.End_Date; i = i.AddDays(1))
{
if (i.DayOfWeek == DayOfWeek.Saturday || i.DayOfWeek == DayOfWeek.Sunday)
{
e = e + 1;
}
foreach (var item in p.holidays)
{
if (item.Holiday_date == i)
{
e++;
}
}
}
number_of_days = number_of_days - e;
if ((c + number_of_days > account.leaves_alloted))
{
message = "Already Applied or Approved leaves Exceeds Your Leave Balance";
status = false;
ViewBag.Message = message;
ViewBag.Status = status;
}
else if (number_of_days <= account.leaves_alloted)
{
try
{
leave.Start_Date = leave.Start_Date.Date;
leave.End_Date = leave.End_Date.Date;
if (DateTime.Now.Date.Kind == DateTimeKind.Utc)
{
leave.Leave_apply_date = TimeZoneInfo.ConvertTimeFromUtc(DateTime.Now.Date, indian_zone);
}
else if (DateTime.Now.Date.Kind != DateTimeKind.Utc)
{
leave.Leave_apply_date = DateTime.Now.Date;
}
VC_LMSEntities vc = new VC_LMSEntities();
int k = 0;
foreach (var item in vc.approvers)
{
if (item.Emplyoee_id == (Session["userID"].ToString()))
{
k++;
}
}
if (k > 0)
{
leave.Status = "Pending on Approvers";
}
else if (k == 0)
{
leave.Status = "Pending on HR";
}
leave.Number_of_Days = number_of_days;
leave.Employe_name = Session["userName"].ToString();
leave.Employee_Id = (Session["userID"].ToString());
using (VC_LMSEntities f = new VC_LMSEntities())
{
var row = f.UsersTables.Where(m => m.ROLES == "HR").FirstOrDefault();
string EmailID = row.EMAIL;
string employeename = leave.Employe_name;
int days_Leave = leave.Number_of_Days;
string hrname = row.FIRST_NAME;
SendverificationLinkEmail(EmailID, employeename, days_Leave, hrname, leave.LeaveType);
var emp_id = Session["userID"].ToString();
var apporvers = f.approvers.Where(y => y.Emplyoee_id == emp_id).FirstOrDefault();
if (apporvers != null)
{
foreach (var item in f.approvers)
{
if (item.Emplyoee_id == emp_id)
{
var approvr = f.UsersTables.Where(q => q.EMPLOYEE_ID == item.approver_id).FirstOrDefault();
var approvername = approvr.FIRST_NAME;
SendverificationLinkEmail(approvr.EMAIL, employeename, days_Leave, approvername, leave.LeaveType);
}
}
}
//var userinfo = f.UsersTables.Where(s => s.EMPLOYEE_ID == leave.Employee_Id).FirstOrDefault();
//var row2 = f.UsersTables.Where(m => m.EMPLOYEE_ID == userinfo.manager_id).FirstOrDefault();
//EmailID = row2.EMAIL;
//SendverificationLinkEmail(EmailID, employeename);
f.Leaves.Add(leave);
f.SaveChanges();
ModelState.Clear();
message = "Successfully Applied";
ViewBag.Status = status;
}
}
catch (Exception ex)
{
ViewBag.Message = "Exclude Special Characters from Reason";
return(View());
}
}
else if (number_of_days < account.leaves_alloted)
{
if (1 <= DateTime.Now.Month && DateTime.Now.Month <= 3)
{
if (4 <= leave.Start_Date.Month && leave.Start_Date.Month <= 6)
{
if (number_of_days < account.leaves_alloted + 5)
{
}
}
else if (7 <= leave.Start_Date.Month && leave.Start_Date.Month <= 9)
{
if (number_of_days < account.leaves_alloted + 10)
{
}
}
}
else if (4 <= DateTime.Now.Month && DateTime.Now.Month <= 6)
{
if (7 <= leave.Start_Date.Month && leave.Start_Date.Month <= 9)
{
if (number_of_days < account.leaves_alloted + 5)
{
}
}
else if (10 <= leave.Start_Date.Month && leave.Start_Date.Month <= 12)
{
if (number_of_days < account.leaves_alloted + 10)
{
}
}
}
else if (7 <= DateTime.Now.Month && DateTime.Now.Month <= 9)
{
if (10 <= leave.Start_Date.Month && leave.Start_Date.Month <= 12)
{
if (number_of_days < account.leaves_alloted + 5)
{
}
}
else if (1 <= leave.Start_Date.Month && leave.Start_Date.Month <= 3)
{
if (account.leaves_alloted > 10)
{
}
}
}
}
else
{
message = "Leave Applied for is greater than your Leave Balance";
ViewBag.Status = false;
}
}
}
else if (leave.End_Date < leave.Start_Date)
{
message = "End Date should be greater then Start Date";
status = false;
}
else if ((leave.End_Date == leave.Start_Date) && (leave.Start_Date == null))
{
message = "Cannot pass Null in Required Field";
status = false;
}
else if (leave.End_Date == leave.Start_Date)
{
try
{
if (leave.Start_Date.DayOfWeek == DayOfWeek.Saturday || leave.Start_Date.DayOfWeek == DayOfWeek.Sunday)
{
ViewBag.Message = "You are applying Leave on day which is already a Holiday";
return(View());
}
//else
{
leave.Start_Date = leave.Start_Date.Date;
leave.End_Date = leave.End_Date.Date;
leave.Number_of_Days = 1;
if (DateTime.Now.Date.Kind == DateTimeKind.Utc)
{
leave.Leave_apply_date = TimeZoneInfo.ConvertTimeFromUtc(DateTime.Now.Date, indian_zone);
}
else if (DateTime.Now.Date.Kind != DateTimeKind.Utc)
{
leave.Leave_apply_date = DateTime.Now.Date;
}
leave.Status = "Pending on Approvers";
leave.Employe_name = Session["userName"].ToString();
leave.Employee_Id = (Session["userID"].ToString());
using (VC_LMSEntities f = new VC_LMSEntities())
{
var row = f.UsersTables.Where(m => m.ROLES == "HR").FirstOrDefault();
string EmailID = row.EMAIL;
string employeename = leave.Employe_name;
int days_Leave = leave.Number_of_Days;
SendverificationLinkEmail(EmailID, employeename, days_Leave, row.FIRST_NAME, leave.LeaveType);
var emp_id = Session["userID"].ToString();
var apporvers = f.approvers.Where(y => y.Emplyoee_id == emp_id).FirstOrDefault();
if (apporvers != null)
{
foreach (var item in f.approvers)
{
if (item.Emplyoee_id == emp_id)
{
var approvr = f.UsersTables.Where(q => q.EMPLOYEE_ID == item.approver_id).FirstOrDefault();
SendverificationLinkEmail(approvr.EMAIL, employeename, days_Leave, approvr.FIRST_NAME, leave.LeaveType);
}
}
}
f.Leaves.Add(leave);
f.SaveChanges();
ModelState.Clear();
message = "Successfully Applied";
ViewBag.Status = status;
}
}
}
catch (Exception ex)
{
ViewBag.Message = "Exclude Special Characters from Reason";
return(View());
}
}
ViewBag.Message = message;
ViewBag.Status = status;
ModelState.Clear();
return(View());
}
public ActionResult Edit(int id, LeaveManagementSystemValueCreed.Models.Leave leave)
{
int n = 0;
//try
VC_LMSEntities j = new VC_LMSEntities();
var approval_tbl = j.approvals.Where(x => x.Leave_id == leave.ID && x.status == "Approved By HR").FirstOrDefault();
if (approval_tbl != null)
{
int leave_id = leave.ID;
VC_LMSEntities d = new VC_LMSEntities();
var user_id = d.UsersTables.Where(v => v.EMPLOYEE_ID == leave.Employee_Id).FirstOrDefault();
var approver_number = d.approvers.Where(w => w.Emplyoee_id == leave.Employee_Id).FirstOrDefault();
if (approver_number != null)
{
leave.Status = "Requested Approvers For Cancellation";
d.Entry(leave).State = System.Data.Entity.EntityState.Modified;
d.SaveChanges();
}
else
{
leave.Status = "Cancellation Pending on HR";
d.Entry(leave).State = System.Data.Entity.EntityState.Modified;
d.SaveChanges();
}
return(RedirectToAction("Leave", "Employee"));
}
else
{
VC_LMSEntities l = new VC_LMSEntities();
if (leave.Status == "Cancel")
{
leave.Status = "Cancelled";
l.Entry(leave).State = System.Data.Entity.EntityState.Modified;
l.SaveChanges();
return(RedirectToAction("Leave", "Employee"));
}
else
{
using (VC_LMSEntities db = new VC_LMSEntities())
{
var indian_zone = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
if (DateTime.Now.Date.Kind == DateTimeKind.Utc)
{
if (leave.Start_Date.Subtract(TimeZoneInfo.ConvertTimeFromUtc(DateTime.Now.Date, indian_zone)).Days > 360)
{
ViewBag.Message = "Cannot Apply for such date,as it is too Far";
return(View());
}
}
else
{
if (leave.Start_Date.Subtract(DateTime.Now.Date).Days > 360)
{
ViewBag.Message = "Cannot Apply for such date,as it is too Far";
return(View());
}
}
bool status = false;
string message = "";
if (DateTime.Now.Date.Kind != DateTimeKind.Utc)
{
var datediff = DateTime.Now.Date.Subtract(leave.End_Date);
if (datediff.TotalDays > 0)
{
ViewBag.Message = "Cannot Apply Leave if End Date is in the Past";
ViewBag.Status = false;
return(View());
}
}
else if (DateTime.Now.Date.Kind == DateTimeKind.Utc)
{
var datediff = TimeZoneInfo.ConvertTimeFromUtc(DateTime.Now.Date, indian_zone).Subtract(leave.End_Date);
if (datediff.TotalDays > 0)
{
ViewBag.Message = "Cannot Apply Leave if End Date is in the Past";
ViewBag.Status = false;
return(View());
}
}
if (leave.End_Date > leave.Start_Date)
{
int c = 0;
VC_LMSEntities dd = new VC_LMSEntities();
foreach (var item in dd.Leaves)
{
if ((Session["userID"].ToString()) == item.Employee_Id)
{
if ((item.Start_Date < leave.Start_Date) && (leave.End_Date < item.End_Date) && (item.Status != "Cancelled") && leave.ID != item.ID)
{
ViewBag.Message = "Leave range falling under Another Leave Range ";
ViewBag.Status = false;
ModelState.Clear();
return(View());
}
else if ((item.Start_Date < leave.Start_Date) && (leave.End_Date < item.End_Date) && (item.Status != "Cancelled") && leave.ID != item.ID)
{
ViewBag.Message = "Leave date conflict,Please Apply after previous leave Ends ";
ViewBag.Status = false;
ModelState.Clear();
return(View());
}
else if ((item.Start_Date < leave.Start_Date) && (leave.Start_Date < item.End_Date) && (item.Status != "Cancelled") && leave.ID != item.ID)
{
ViewBag.Message = "Leave date conflict,Please Apply after previous leave Ends,or Edit ";
ViewBag.Status = false;
ModelState.Clear();
return(View());
}
if ((leave.Start_Date == item.Start_Date || leave.End_Date == item.End_Date) && item.Status != "Cancelled" && leave.ID != item.ID)
{
ViewBag.Message = "Matching Date For Already Applied Leave Found,Please Cancel that Leave ";
ViewBag.Status = false;
ModelState.Clear();
return(View());
}
}
if (item.Employee_Id == (Session["userID"].ToString()) && (item.Status == "Pending on Manager" || item.Status == "Approved By Manager" || item.Status == "Pending on Approvers" || item.Status == "Approved By Approvers") && leave.ID != item.ID)
{
c += item.Number_of_Days;
}
}
var x = (Session["userID"].ToString());
var account = dd.UsersTables.Where(a => a.EMPLOYEE_ID == x).FirstOrDefault();
if (account.leaves_alloted == 0)
{
message = "Sorry Your Leave Balance is Zero and you cannot apply";
status = false;
}
else
{
int e = 0;
var number_of_day = leave.End_Date.Date.Subtract(leave.Start_Date);
int number_of_days = 0;
number_of_days = number_of_day.Days + 1;
int d = 0;
for (DateTime i = leave.Start_Date; i < leave.End_Date; i = i.AddDays(1))
{
if (i.DayOfWeek == DayOfWeek.Saturday || i.DayOfWeek == DayOfWeek.Sunday)
{
e = e + 1;
}
}
number_of_days = number_of_days - e;
if ((c + number_of_days > account.leaves_alloted))
{
message = "Already Applied or Approved leaves Exceeds Your Leave Balance";
status = false;
ViewBag.Message = message;
ViewBag.Status = status;
}
else if (number_of_days < account.leaves_alloted)
{
try
{
leave.Start_Date = leave.Start_Date.Date;
leave.End_Date = leave.End_Date.Date;
if (DateTime.Now.Date.Kind == DateTimeKind.Utc)
{
leave.Leave_apply_date = TimeZoneInfo.ConvertTimeFromUtc(DateTime.Now.Date, indian_zone);
}
else if (DateTime.Now.Date.Kind != DateTimeKind.Utc)
{
leave.Leave_apply_date = DateTime.Now.Date;
}
VC_LMSEntities vc = new VC_LMSEntities();
int k = 0;
foreach (var item in vc.approvers)
{
if (item.Emplyoee_id == (Session["userID"].ToString()))
{
k++;
}
}
if (k > 0)
{
leave.Status = "Pending on Approvers";
}
else if (k == 0)
{
leave.Status = "Pending on HR";
}
leave.Number_of_Days = number_of_days;
leave.Employe_name = Session["userName"].ToString();
leave.Employee_Id = (Session["userID"].ToString());
using (VC_LMSEntities f = new VC_LMSEntities())
{
var row = f.UsersTables.Where(m => m.ROLES == "HR").FirstOrDefault();
string EmailID = row.EMAIL;
string employeename = leave.Employe_name;
//SendverificationLinkEmail(EmailID, employeename);
//var userinfo = f.UsersTables.Where(s => s.EMPLOYEE_ID == leave.Employee_Id).FirstOrDefault();
//var row2 = f.UsersTables.Where(m => m.EMPLOYEE_ID == userinfo.manager_id).FirstOrDefault();
//EmailID = row2.EMAIL;
//SendverificationLinkEmail(EmailID, employeename);
l.Entry(leave).State = System.Data.Entity.EntityState.Modified;
l.SaveChanges();
message = "Successfully Applied";
ViewBag.Status = status;
return(RedirectToAction("Index", "Employee"));
}
}
catch (Exception ex)
{
ViewBag.Message = "Exclude Special Characters from Reason";
return(View());
}
}
else
{
message = "Leave Applied for is greater than your Leave Balance";
ViewBag.Status = false;
}
}
}
else if (leave.End_Date < leave.Start_Date)
{
message = "End Date should be greater then Start Date";
status = false;
}
else if ((leave.End_Date == leave.Start_Date) && (leave.Start_Date == null))
{
message = "Cannot pass Null in Required Field";
status = false;
}
else if (leave.End_Date == leave.Start_Date)
{
try
{
if (leave.Start_Date.DayOfWeek == DayOfWeek.Saturday || leave.Start_Date.DayOfWeek == DayOfWeek.Sunday)
{
ViewBag.Message = "You are applying Leave on day which is already a Holiday";
return(View());
}
//else
leave.Start_Date = leave.Start_Date.Date;
leave.End_Date = leave.End_Date.Date;
leave.Number_of_Days = 1;
if (DateTime.Now.Date.Kind == DateTimeKind.Utc)
{
leave.Leave_apply_date = TimeZoneInfo.ConvertTimeFromUtc(DateTime.Now.Date, indian_zone);
}
else if (DateTime.Now.Date.Kind != DateTimeKind.Utc)
{
leave.Leave_apply_date = DateTime.Now.Date;
}
leave.Status = "Pending on Manager";
leave.Employe_name = Session["userName"].ToString();
leave.Employee_Id = (Session["userID"].ToString());
using (VC_LMSEntities f = new VC_LMSEntities())
{
f.Entry(leave).State = System.Data.Entity.EntityState.Modified;
f.SaveChanges();
message = "Successfully Applied";
ViewBag.Status = status;
return(RedirectToAction("Index", "Employee"));
}
}
catch (Exception ex)
{
ViewBag.Message = "Exclude Special Characters from Reason";
return(View());
}
}
ViewBag.Message = message;
ViewBag.Status = status;
ModelState.Clear();
return(View());
}
}
}
}
public ActionResult Editmyleave(int id)
{
VC_LMSEntities d = new VC_LMSEntities();
return(View(d.Leaves.Where(x => x.ID == id).FirstOrDefault()));
}
public ActionResult Delete(string id)
{
VC_LMSEntities d = new VC_LMSEntities();
return(View(d.UsersTables.Where(x => x.EMPLOYEE_ID == id).FirstOrDefault()));
}
// GET: Login/Delete/5
public ActionResult Autherize(LeaveManagementSystemValueCreed.Models.UsersTable userid)
{
if (Session["userID"] != null)
{
return(View("Index", userid));
}
using (VC_LMSEntities d = new VC_LMSEntities())
{
////var detail = dd.userids.Contains(userid);
//var details = dd.userids.Where(x => x.userName == userid.userName && x.Password == userid.Password && userid.role == x.role).FirstOrDefault();
//var name = userid.userName.ToString();
//var role = userid.role.ToString();
//var role = d.roles.Find(name).NAME.ToString();
var details = d.UsersTables.Where(x => x.EMAIL == userid.EMAIL && x.Status == "Active").FirstOrDefault();
if (details == null)
{
ViewBag.Message = "No such Email Id Present in Database";
return(View("Index", userid));
}
else
{
VC_LMSEntities e = new VC_LMSEntities();
VC_LMSEntities dd = new VC_LMSEntities();
var aprover = e.approvers.Where(x => x.approver_id == details.EMPLOYEE_ID).FirstOrDefault();
if (aprover != null)
{
var id = dd.UsersTables.Where(x => x.EMPLOYEE_ID == aprover.approver_id).FirstOrDefault();
Session["userID"] = id.EMPLOYEE_ID;
Session["userName"] = id.FIRST_NAME;
Session["Name"] = id.EMAIL;
return(RedirectToAction("Index", "approver"));
}
foreach (var item in d.UsersTables)
{
if (userid.EMAIL == item.EMAIL)
{
if (item.ROLES == "Admin")
{
Session["userName"] = item.FIRST_NAME;
Session["Name"] = item.EMAIL;
Session["userID"] = item.EMPLOYEE_ID;
return(RedirectToAction("Index", "admin"));
}
else if (item.ROLES == "Employee")
{
Session["userName"] = item.FIRST_NAME;
Session["userID"] = item.EMPLOYEE_ID;
Session["Name"] = item.EMAIL;
return(RedirectToAction("Index", "Employee"));
}
else if (item.ROLES == "HR")
{
Session["userName"] = item.FIRST_NAME;
Session["userID"] = item.EMPLOYEE_ID;
Session["Name"] = item.EMAIL;
return(RedirectToAction("Index", "HR"));
}
}
}
}
return(View("Index", userid));
}
}
public ActionResult ExternalLoginCallback(string returnUrl)
{
string ProviderName = OpenAuth.GetProviderNameFromCurrentRequest();
if (ProviderName == null || ProviderName == "")
{
NameValueCollection nvs = Request.QueryString;
if (nvs.Count > 0)
{
if (nvs["state"] != null)
{
NameValueCollection provideritem = HttpUtility.ParseQueryString(nvs["state"]);
if (provideritem["__provider__"] != null)
{
ProviderName = provideritem["__provider__"];
}
}
}
}
GoogleOAuth2Client.RewriteRequest();
var redirectUrl = Url.Action("ExternalLoginCallback", new { ReturnUrl = returnUrl });
var retUrl = returnUrl;
var authResult = OpenAuth.VerifyAuthentication(redirectUrl);
if (!authResult.IsSuccessful)
{
ViewBag.Message = "Not A Valid EmailID";
return(Redirect(Url.Action("Account", "Login")));
}
// User has logged in with provider successfully
// Check if user is already registered locally
//You can call you user data access method to check and create users based on your model
VC_LMSEntities d = new VC_LMSEntities();
string email = authResult.ExtraData["email"];
var row = d.UsersTables.Where(x => x.EMAIL == email).FirstOrDefault();
if (row == null)
{
ViewBag.Message = "Email not in Database";
return(RedirectToAction("Index"));
}
else
{
var id = row.EMPLOYEE_ID;
//var manager = d.managers.Where(x => x.manager_emp_id == id).FirstOrDefault();
//if ( manager!= null&&row.Status=="Active")
//{
// Session["userID"] = row.EMPLOYEE_ID;
// Session["userName"] = row.FIRST_NAME;
// Session["Name"] = row.EMAIL;
// return RedirectToAction("Index", "manager");
//}
//else
{
var row1 = d.approvers.Where(x => x.approver_id == row.EMPLOYEE_ID).FirstOrDefault();
if (row1 != null && row.Status == "Active")
{
Session["userID"] = row.EMPLOYEE_ID;
Session["userName"] = row.FIRST_NAME;
Session["Name"] = row.EMAIL;
return(RedirectToAction("Index", "Approver"));
}
else if (row.ROLES == "HR" && row.Status == "Active")
{
Session["userID"] = row.EMPLOYEE_ID;
Session["userName"] = row.FIRST_NAME;
Session["Name"] = row.EMAIL;
return(RedirectToAction("Index", "HR"));
}
else if (row.ROLES == "Employee" && row.Status == "Active")
{
Session["userID"] = row.EMPLOYEE_ID;
Session["userName"] = row.FIRST_NAME;
Session["Name"] = row.EMAIL;
return(RedirectToAction("Index", "Employee"));
}
else if (row.ROLES == "Admin" && row.Status == "Active")
{
Session["userID"] = row.EMPLOYEE_ID;
Session["userName"] = row.FIRST_NAME;
Session["Name"] = row.EMAIL;
return(RedirectToAction("Index", "Admin"));
}
}
}
if (OpenAuth.Login(authResult.Provider, authResult.ProviderUserId, createPersistentCookie: false))
{
return(Redirect(Url.Action("Index", "Home")));
}
//Get provider user details
string ProviderUserId = authResult.ProviderUserId;
string ProviderUserName = authResult.UserName;
string Email = null;
if (Email == null && authResult.ExtraData.ContainsKey("email"))
{
Email = authResult.ExtraData["email"];
}
if (User.Identity.IsAuthenticated)
{
// User is already authenticated, add the external login and redirect to return url
OpenAuth.AddAccountToExistingUser(ProviderName, ProviderUserId, ProviderUserName, User.Identity.Name);
return(Redirect(Url.Action("Index", "Home")));
}
else
{
// User is new, save email as username
string membershipUserName = Email ?? ProviderUserId;
var createResult = OpenAuth.CreateUser(ProviderName, ProviderUserId, ProviderUserName, membershipUserName);
if (!createResult.IsSuccessful)
{
ViewBag.Message = "User cannot be created";
return(View());
}
else
{
// User created
if (OpenAuth.Login(ProviderName, ProviderUserId, createPersistentCookie: false))
{
return(Redirect(Url.Action("Index", "Home")));
}
}
}
return(View());
}
public ActionResult Create(LeaveManagementSystemValueCreed.Models.UsersTable usr)
{
try
{
bool t = usr.EMAIL.Contains("valuecreed.com");
if (t == false)
{
ViewBag.Message = "Please Enter internal Email of ValueCreed";
return(View());
}
VC_LMSEntities e = new VC_LMSEntities();
//var managername = e.UsersTables.Where(x => x.EMPLOYEE_ID == usr.manager_id).FirstOrDefault();
//if (managername == null)
//{
// ViewBag.Message = "Please Select Manager ";
// return View();
//}
//usr.manager_name = managername.FIRST_NAME;
//var row = e.UsersTables.Where(x => x.EMPLOYEE_ID == usr.manager_id).FirstOrDefault();
List <department_tbl> l = new List <department_tbl>();
List <RolesTable> r = new List <RolesTable>();
foreach (var item in e.RolesTables)
{
if (item.NAME != "Admin")
{
r.Add(item);
}
}
//ViewData["Manager"] = new SelectList(e.managers, "name", "name");
ViewData["Department"] = new SelectList(e.department_tbl, "DEPARTMENT", "DEPARTMENT");
ViewData["Roles"] = new SelectList(r, "NAME", "NAME");
VC_LMSEntities d = new VC_LMSEntities();
if (1 <= usr.Emp_start_date.Month && usr.Emp_start_date.Month < 3)
{
if (usr.Emp_start_date.Date < new DateTime(usr.Emp_start_date.Year, 1, 15))
{
usr.leaves_alloted = 5;
}
else if (usr.Emp_start_date.Date > new DateTime(usr.Emp_start_date.Year, 1, 15) && usr.Emp_start_date.Date < new DateTime(usr.Emp_start_date.Year, 2, 15))
{
usr.leaves_alloted = 3;
}
else if (usr.Emp_start_date.Date > new DateTime(usr.Emp_start_date.Year, 2, 15))
{
usr.leaves_alloted = 1;
}
}
else if (4 <= usr.Emp_start_date.Month && usr.Emp_start_date.Month < 6)
{
if (usr.Emp_start_date.Date < new DateTime(usr.Emp_start_date.Year, 4, 15))
{
usr.leaves_alloted = 5;
}
else if (usr.Emp_start_date.Date > new DateTime(usr.Emp_start_date.Year, 4, 15) && usr.Emp_start_date.Date < new DateTime(usr.Emp_start_date.Year, 5, 15))
{
usr.leaves_alloted = 3;
}
else if (usr.Emp_start_date.Date > new DateTime(usr.Emp_start_date.Year, 5, 15))
{
usr.leaves_alloted = 1;
}
}
else if (7 <= usr.Emp_start_date.Month && usr.Emp_start_date.Month < 9)
{
if (usr.Emp_start_date.Date < new DateTime(usr.Emp_start_date.Year, 7, 15))
{
usr.leaves_alloted = 5;
}
else if (usr.Emp_start_date.Date > new DateTime(usr.Emp_start_date.Year, 7, 15) && usr.Emp_start_date.Date < new DateTime(usr.Emp_start_date.Year, 8, 15))
{
usr.leaves_alloted = 3;
}
else if (usr.Emp_start_date.Date > new DateTime(usr.Emp_start_date.Year, 8, 15))
{
usr.leaves_alloted = 1;
}
}
else if (10 <= usr.Emp_start_date.Month && usr.Emp_start_date.Month < 12)
{
if (usr.Emp_start_date.Date < new DateTime(usr.Emp_start_date.Year, 10, 15))
{
usr.leaves_alloted = 5;
}
else if (usr.Emp_start_date.Date > new DateTime(usr.Emp_start_date.Year, 10, 15) && usr.Emp_start_date.Date < new DateTime(usr.Emp_start_date.Year, 11, 15))
{
usr.leaves_alloted = 3;
}
else if (usr.Emp_start_date.Date > new DateTime(usr.Emp_start_date.Year, 11, 15))
{
usr.leaves_alloted = 1;
}
}
using (VC_LMSEntities dd = new VC_LMSEntities())
{
var user = dd.UsersTables.Where(x => x.EMAIL == usr.EMAIL).FirstOrDefault();
if (user != null)
{
ViewBag.Message = "Email Already Present";
return(View());
}
d.UsersTables.Add(usr);
d.SaveChanges();
}
ModelState.Clear();
ViewBag.Meassage = "Creation Success";
return(View());
}
catch (Exception ex)
{
ViewBag.Message = "Some Invalid Values have been given,Please Retry";
return(View());
}
}
public ActionResult Edit(int id, LeaveManagementSystemValueCreed.Models.Leave leaf)
{
try
{
VC_LMSEntities h = new VC_LMSEntities();
var approval_row = h.approvals.Where(r => r.Leave_id == leaf.ID && r.status == "Approved By HR").FirstOrDefault();
if (approval_row != null)
{
if (leaf.Status == "Approved")
{
leaf.Status = "Cancellation Pending on HR";
h.Entry(leaf).State = System.Data.Entity.EntityState.Modified;
h.SaveChanges();
return(RedirectToAction("Index", "Approver"));
}
}
int c = 0;
int e = 0;
if (leaf.Status == "Approved")
{
c++;
}
VC_LMSEntities d = new VC_LMSEntities();
var hr1 = d.UsersTables.Where(x => x.EMPLOYEE_ID == leaf.Employee_Id).FirstOrDefault();
if (leaf.Status == "Approved" && hr1.ROLES == "HR")
{
approval approval2 = new approval();
approval2.Aprrover_id = Session["userID"].ToString();
approval2.Employee_id = leaf.Employee_Id;
approval2.Leave_id = leaf.ID;
approval2.status = "Approved By " + Session["Name"].ToString();
d.approvals.Add(approval2);
leaf.Status = "Approved";
hr1.leaves_alloted = hr1.leaves_alloted - leaf.Number_of_Days;
d.Entry(leaf).State = System.Data.Entity.EntityState.Modified;
d.Entry(hr1).State = System.Data.Entity.EntityState.Modified;
d.SaveChanges();
return(RedirectToAction("Index", "Approver"));
}
foreach (var item in d.approvals)
{
if (item.Leave_id == leaf.ID)
{
c++;
}
}
if (leaf.Status == "Approved")
{
var i = leaf.Employee_Id;
foreach (var item in d.approvers)
{
if (item.Emplyoee_id == leaf.Employee_Id)
{
e++;
}
}
if (c == e)
{
leaf.Status = "Approved By All Approvers";
var hr = d.UsersTables.Where(x => x.EMPLOYEE_ID == leaf.Employee_Id && x.ROLES == "HR").FirstOrDefault();
if (hr != null)
{
hr.leaves_alloted = hr.leaves_alloted - leaf.Number_of_Days;
d.Entry(hr).State = System.Data.Entity.EntityState.Modified;
approval approval2 = new approval();
approval2.Aprrover_id = Session["userID"].ToString();
approval2.Employee_id = leaf.Employee_Id;
approval2.Leave_id = leaf.ID;
approval2.status = "Approved By " + Session["Name"].ToString();
d.approvals.Add(approval2);
d.SaveChanges();
}
var emp = d.UsersTables.Where(x => x.EMPLOYEE_ID == leaf.Employee_Id).FirstOrDefault();
var body = "Hello " + emp.FIRST_NAME + ",< br /> <br /> your Leave has been approved by all the Approvers. <br /> <br /> Warm Regards, <br /> LMS Team.";
SendverificationLinkEmail(emp.EMAIL, body);
var hrmail = d.UsersTables.Where(x => x.ROLES == "HR").FirstOrDefault();
body = "Hello " + hrmail.FIRST_NAME + ",< br /> <br /> Leave application of " + leaf.Employe_name + " has been approved by all approvers and now it is pending on you. <br/> <br /> Warm Regards, <br /> LMS Team.";
//SendverificationLinkEmail(hrmail.EMAIL, body);
approval approval1 = new approval();
approval1.Aprrover_id = Session["userID"].ToString();
approval1.Employee_id = leaf.Employee_Id;
approval1.Leave_id = leaf.ID;
approval1.status = "Approved By " + Session["Name"].ToString();
d.approvals.Add(approval1);
d.SaveChanges();
}
else
{
var emp = d.UsersTables.Where(x => x.EMPLOYEE_ID == leaf.Employee_Id).FirstOrDefault();
var body = "Hello " + emp.FIRST_NAME + ",< br /> <br /> your Leave has been approved by " + Session["userName"] + "< br /> <br /> Warm Regards, <br /> LMS Team.";
//SendverificationLinkEmail(emp.EMAIL, body);
leaf.Status = "Pending on Approvers";
approval approval1 = new approval();
approval1.Aprrover_id = Session["userID"].ToString();
approval1.Employee_id = leaf.Employee_Id;
approval1.Leave_id = leaf.ID;
approval1.status = "Approved By " + Session["Name"].ToString();
d.approvals.Add(approval1);
d.SaveChanges();
}
}
else if (leaf.Status == "Rejected By Approver")
{
approval approval1 = new approval();
approval1.Aprrover_id = Session["userID"].ToString();
approval1.Employee_id = leaf.Employee_Id;
approval1.Leave_id = leaf.ID;
approval1.status = "Rejected By " + Session["Name"].ToString();
d.approvals.Add(approval1);
d.SaveChanges();
}
d.Entry(leaf).State = System.Data.Entity.EntityState.Modified;
d.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ViewBag.Message = "Unable to change the status";
return(View());
}
}
