public ActionResult DeleteConfirmed(int id, DateTime?eddate)
{
ViewBag.eddate = eddate;
leave_absence leave_absence = db.leave_absence.Find(id);
db.leave_absence.Remove(leave_absence);
db.SaveChanges();
return(RedirectToAction("leave_absence_Index", "Leaves", new{ eddate = eddate }));
}
public ActionResult Create([Bind(Include = "Employee_id,Id,absence,month,fromd,tod")] leave_absence leave_absence)
{
if (ModelState.IsValid)
{
db.leave_absence.Add(leave_absence);
db.SaveChanges();
return(RedirectToAction("leave_absence_Index", "Leaves"));
}
ViewBag.Employee_id = new SelectList(db.master_file, "employee_id", "employee_no", leave_absence.Employee_id);
return(View(leave_absence));
}
public ActionResult Edit([Bind(Include = "Employee_id,Id,absence,month,fromd,tod")] leave_absence leave_absence, DateTime?eddate)
{
ViewBag.eddate = eddate;
if (ModelState.IsValid)
{
db.Entry(leave_absence).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("leave_absence_Index", "Leaves", new{ eddate = eddate }));
}
ViewBag.Employee_id = new SelectList(db.master_file, "employee_id", "employee_no", leave_absence.Employee_id);
return(View(leave_absence));
}
public ActionResult Abstransfer(int?id, DateTime?date1, string empnos)
{
var newlistemo = new List <int>();
var neweos = "";
var abslist = db.leave_absence.ToList();
var mastervar = db.master_file.OrderByDescending(x => x.date_changed).ToList();
if (!abslist.Exists(x => x.master_file.employee_no == id && x.fromd <= date1 && x.tod >= date1))
{
var absvar = new leave_absence();
var emp = mastervar.Find(x => x.employee_no == id);
if (emp != null)
{
var date2 = date1.Value.AddDays(-1);
if (abslist.Exists(x => x.Employee_id == emp.employee_id && x.fromd <= date2 && x.tod >= date2))
{
var abs1 = abslist.Find(x => x.Employee_id == emp.employee_id && x.fromd <= date2 && x.tod >= date2);
abs1.tod = date1;
abs1.absence = (abs1.tod - abs1.fromd).Value.Days + 1;
this.db.Entry(abs1).State = EntityState.Modified;
this.db.SaveChanges();
}
else
{
absvar.Employee_id = emp.employee_id;
absvar.fromd = date1;
absvar.tod = date1;
absvar.absence = 1;
absvar.month = date1;
this.db.leave_absence.Add(absvar);
this.db.SaveChanges();
}
if (!empnos.IsNullOrWhiteSpace())
{
if (!empnos.Contains(emp.employee_no.ToString() + "(" + date1.ToString() + ")"))
{
empnos += " , " + emp.employee_no + "(" + date1.ToString() + ")";
neweos = empnos;
}
}
else
{
empnos = emp.employee_no.ToString() + "(" + date1.ToString() + ")";
neweos = empnos;
}
}
}
return(RedirectToAction("Absent", new { getdate = date1, empnos = neweos }));
}
// GET: leave_absence/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
leave_absence leave_absence = db.leave_absence.Find(id);
if (leave_absence == null)
{
return(HttpNotFound());
}
return(View(leave_absence));
}
// GET: leave_absence/Delete/5
public ActionResult Delete(int?id, DateTime?eddate)
{
ViewBag.eddate = eddate;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
leave_absence leave_absence = db.leave_absence.Find(id);
if (leave_absence == null)
{
return(HttpNotFound());
}
return(View(leave_absence));
}
// GET: leave_absence/Edit/5
public ActionResult Edit(int?id, DateTime?eddate)
{
ViewBag.eddate = eddate;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
leave_absence leave_absence = db.leave_absence.Find(id);
ViewBag.eddate = eddate;
if (leave_absence == null)
{
return(HttpNotFound());
}
ViewBag.Employee_id = new SelectList(db.master_file, "employee_id", "employee_no", leave_absence.Employee_id);
return(View(leave_absence));
}
