public ActionResult DeleteConfirmed(int id)
{
AttProcessorScheduler attprocessor = context.AttProcessorSchedulers.Single(x => x.AttProcesserSchedulerID == id);
context.AttProcessorSchedulers.Remove(attprocessor);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(AttProcessorScheduler attprocessor)
{
if (ModelState.IsValid)
{
context.Entry(attprocessor).State = EntityState.Modified;
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(attprocessor));
}
public ActionResult DeleteConfirmed(int?id)
{
AttProcessorScheduler attprocessor = context.AttProcessorSchedulers.Find(id);
context.AttProcessorSchedulers.Remove(attprocessor);
context.SaveChanges();
int _userID = Convert.ToInt32(Session["LogedUserID"].ToString());
HelperClass.MyHelper.SaveAuditLog(_userID, (byte)MyEnums.FormName.Designation, (byte)MyEnums.Operation.Delete, DateTime.Now);
return(RedirectToAction("Index"));
}
public ActionResult Create(AttProcessorScheduler attprocessor)
{
string d = Request.Form["CriteriaID"].ToString();
switch (d)
{
case "C":
attprocessor.Criteria = "C";
break;
case "L": attprocessor.Criteria = "L"; break;
case "A": attprocessor.Criteria = "A"; break;
case "E":
{
attprocessor.Criteria = "E";
attprocessor.ProcessCat = false;
string ee = Request.Form["EmpNo"].ToString();
int cc = Convert.ToInt16(Request.Form["CompanyIDForEmp"].ToString());
List <Emp> empss = new List <Emp>();
empss = context.Emps.Where(aa => aa.EmpNo == ee && aa.CompanyID == cc).ToList();
if (empss.Count() > 0)
{
attprocessor.EmpID = empss.First().EmpID;
attprocessor.EmpNo = empss.First().EmpNo;
}
}
break;
}
int a = Convert.ToInt16(Request.Form["ProcessCats"].ToString());
if (a == 1)
{
attprocessor.ProcessCat = true;
}
else
{
attprocessor.ProcessCat = false;
}
attprocessor.ProcessingDone = false;
attprocessor.WhenToProcess = DateTime.Today;
attprocessor.CreatedDate = DateTime.Now;
int _userID = Convert.ToInt32(Session["LogedUserID"].ToString());
if (ModelState.IsValid)
{
attprocessor.UserID = _userID;
context.AttProcessorSchedulers.Add(attprocessor);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(attprocessor));
}
private void ProcessManualAttendanceMonthly(List <Emp> emps, AttProcessorScheduler req)
{
if (req.DateFrom.Date.Day == 21)
{
DateTime dt1 = new DateTime(req.DateFrom.Year, req.DateFrom.Month + 1, 20);
ProcessMonthlyPermanent(req.DateFrom, dt1);
}
if (req.DateFrom.Date.Day == 1)
{
int daysInMonths = System.DateTime.DaysInMonth(req.DateFrom.Year, req.DateFrom.Month);
DateTime dt1 = new DateTime(req.DateFrom.Year, req.DateFrom.Month, daysInMonths);
ProcessMonthlyPermanent(req.DateFrom, dt1);
}
}
//
// GET: /AttProcessors/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AttProcessorScheduler attprocessor = context.AttProcessorSchedulers.Find(id);
context.AttProcessorSchedulers.Remove(attprocessor);
context.SaveChanges();
if (id == null)
{
return(HttpNotFound());
}
return(RedirectToAction("Index"));
}
public void SaveManualRequest(int empid, DateTime?dts, DateTime?dte)
{
using (var db = new TAS2013Entities())
{
AttProcessorScheduler atp = new AttProcessorScheduler();
atp.WhenToProcess = DateTime.Today;
atp.PeriodTag = "D";
atp.EmpID = empid;
atp.EmpNo = atp.EmpID.ToString();
atp.DateFrom = (DateTime)dts;
atp.DateTo = (DateTime)dte;
atp.CompanyID = 1;
atp.CreatedDate = DateTime.Now;
atp.LocationID = 1;
atp.ProcessCat = false;
atp.ProcessingDone = false;
atp.UserID = 25;
db.AttProcessorSchedulers.Add(atp);
db.SaveChanges();
}
}
public ActionResult Create(AttProcessorScheduler attprocessor)
{
string d = Request.Form["CriteriaID"].ToString();
switch (d)
{
case "C":
attprocessor.Criteria = "C";
break;
case "L": attprocessor.Criteria = "L"; break;
case "A": attprocessor.Criteria = "A"; break;
}
int a = Convert.ToInt16(Request.Form["ProcessCats"].ToString());
if (a == 1)
{
attprocessor.ProcessCat = true;
}
else
{
attprocessor.ProcessCat = false;
}
attprocessor.ProcessingDone = false;
attprocessor.WhenToProcess = DateTime.Today;
int _userID = Convert.ToInt32(Session["LogedUserID"].ToString());
if (ModelState.IsValid)
{
attprocessor.UserID = _userID;
context.AttProcessorSchedulers.Add(attprocessor);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(attprocessor));
}
//
// GET: /AttProcessors/Details/5
public ViewResult Details(int id)
{
AttProcessorScheduler attprocessor = context.AttProcessorSchedulers.Single(x => x.AttProcesserSchedulerID == id);
return(View(attprocessor));
}
//
// GET: /AttProcessors/Delete/5
public ActionResult Delete(int id)
{
AttProcessorScheduler attprocessor = context.AttProcessorSchedulers.Single(x => x.AttProcesserSchedulerID == id);
return(View(attprocessor));
}
public ActionResult Create(AttProcessorScheduler attprocessor)
{
User LoggedInUser = Session["LoggedUser"] as User;
string d = Request.Form["CriteriaID"].ToString();
string Message = "";
switch (d)
{
case "C":
attprocessor.Criteria = "C";
break;
case "L": attprocessor.Criteria = "L"; break;
case "E":
{
TAS2013Entities db = new TAS2013Entities();
attprocessor.Criteria = "E";
string EmpNo = Request.Form["EmpNo"].ToString();
List <EmpView> emps = new List <EmpView>();
emps = db.EmpViews.Where(aa => aa.EmpNo == EmpNo && aa.Status == true).ToList();
emps = AssistantQuery.GetFilteredEmps(emps, db.UserSections.Where(aa => aa.UserID == LoggedInUser.UserID).ToList());
if (emps.Count() > 0)
{
attprocessor.EmpID = emps.First().EmpID;
attprocessor.EmpNo = emps.First().EmpNo;
}
else
{
Message = "There is no employee found";
ViewBag.CMessage = Message;
ViewBag.PeriodTag = new SelectList(new List <SelectListItem>
{
new SelectListItem {
Selected = true, Text = "Daily", Value = "D"
},
new SelectListItem {
Selected = false, Text = "Monthly", Value = "M"
},
new SelectListItem {
Selected = false, Text = "Summary", Value = "S"
},
}, "Value", "Text", 1);
ViewBag.CriteriaID = new SelectList(new List <SelectListItem>
{
new SelectListItem {
Selected = true, Text = "Company", Value = "C"
},
new SelectListItem {
Selected = false, Text = "Location", Value = "L"
},
new SelectListItem {
Selected = false, Text = "Employee", Value = "E"
},
}, "Value", "Text", 1);
ViewBag.LocationID = new SelectList(db.Locations.OrderBy(s => s.LocName), "LocID", "LocName");
return(View(attprocessor));
}
}
break;
}
attprocessor.ProcessingDone = false;
int _userID = Convert.ToInt32(Session["LogedUserID"].ToString());
if (ModelState.IsValid)
{
attprocessor.UserID = _userID;
attprocessor.CreatedDate = DateTime.Today;
context.AttProcessorSchedulers.Add(attprocessor);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(attprocessor));
}
public ActionResult Create(AttProcessorScheduler attprocessor)
{
string d = Request.Form["CriteriaID"].ToString();
switch (d)
{
case "C":
attprocessor.Criteria = "C";
break;
case "L": attprocessor.Criteria = "L"; break;
case "A": attprocessor.Criteria = "A"; break;
case "E":
{
attprocessor.Criteria = "E";
attprocessor.ProcessCat = false;
string ee = Request.Form["EmpNo"].ToString();
int cc = Convert.ToInt16(Request.Form["CompanyIDForEmp"].ToString());
List <Emp> empss = new List <Emp>();
empss = context.Emps.Where(aa => aa.EmpNo == ee && aa.CompanyID == cc).ToList();
if (empss.Count() > 0)
{
attprocessor.EmpID = empss.First().EmpID;
attprocessor.EmpNo = empss.First().EmpNo;
}
}
break;
}
int a = Convert.ToInt16(Request.Form["ProcessCats"].ToString());
if (a == 1)
{
attprocessor.ProcessCat = true;
}
else
{
attprocessor.ProcessCat = false;
}
attprocessor.ProcessingDone = false;
attprocessor.WhenToProcess = DateTime.Today;
attprocessor.CreatedDate = DateTime.Now;
int _userID = Convert.ToInt32(Session["LogedUserID"].ToString());
if ((attprocessor.DateTo - attprocessor.DateFrom).Days > 3 & attprocessor.PeriodTag == "D")
{
ModelState.AddModelError("DateTo", "Date Difference must be between 3 days!");
}
if (ModelState.IsValid)
{
attprocessor.UserID = _userID;
context.AttProcessorSchedulers.Add(attprocessor);
context.SaveChanges();
return(RedirectToAction("Index"));
}
TAS2013Entities db = new TAS2013Entities();
User LoggedInUser = Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
String query = qb.QueryForCompanyViewLinq(LoggedInUser);
ViewBag.PeriodTag = new SelectList(new List <SelectListItem>
{
new SelectListItem {
Selected = false, Text = "Monthly", Value = "M"
},
new SelectListItem {
Selected = true, Text = "Daily", Value = "D"
},
new SelectListItem {
Selected = false, Text = "Summary", Value = "S"
},
}, "Value", "Text", 1);
ViewBag.CriteriaID = new SelectList(new List <SelectListItem>
{
new SelectListItem {
Selected = true, Text = "Company", Value = "C"
},
new SelectListItem {
Selected = false, Text = "Location", Value = "L"
},
new SelectListItem {
Selected = false, Text = "Employee", Value = "E"
},
}, "Value", "Text", 1);
ViewBag.ProcessCats = new SelectList(new List <SelectListItem>
{
new SelectListItem {
Selected = true, Text = "Yes", Value = "1"
},
new SelectListItem {
Selected = false, Text = "No", Value = "0"
},
}, "Value", "Text", 1);
if (LoggedInUser.RoleID == 1)
{
ViewBag.CompanyID = new SelectList(CustomFunction.GetCompanies(db.Companies.ToList(), LoggedInUser), "CompID", "CompName", LoggedInUser.CompanyID);
ViewBag.CompanyIDForEmp = new SelectList(CustomFunction.GetCompanies(db.Companies.ToList(), LoggedInUser), "CompID", "CompName", LoggedInUser.CompanyID);
query = qb.QueryForLocationTableSegerationForLinq(LoggedInUser);
ViewBag.LocationID = new SelectList(CustomFunction.GetLocations(db.Locations.ToList(), db.UserLocations.Where(aa => aa.UserID == LoggedInUser.UserID).ToList()), "LocID", "LocName");
}
else
{
ViewBag.CompanyID = new SelectList(CustomFunction.GetCompanies(db.Companies.ToList(), LoggedInUser), "CompID", "CompName", LoggedInUser.CompanyID);
ViewBag.CompanyIDForEmp = new SelectList(CustomFunction.GetCompanies(db.Companies.ToList(), LoggedInUser), "CompID", "CompName", LoggedInUser.CompanyID);
query = qb.QueryForLocationTableSegerationForLinq(LoggedInUser);
ViewBag.LocationID = new SelectList(CustomFunction.GetLocations(db.Locations.ToList(), db.UserLocations.Where(aa => aa.UserID == LoggedInUser.UserID).ToList()), "LocID", "LocName");
}
ViewBag.CatID = new SelectList(db.Categories.OrderBy(s => s.CatName), "CatID", "CatName");
return(View(attprocessor));
}