public ActionResult DeleteConfirmed(string id)
{
ViewAttDataOT viewattdataot = db.ViewAttDataOTs.Find(id);
db.ViewAttDataOTs.Remove(viewattdataot);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "EmpDate,AttDate,Tin1,Tout1,Tin2,Tout2,Tin3,Tout3,Mins,EmpNo,EmpName,Expr1,CompName,EmpID")] ViewAttDataOT viewattdataot)
{
if (ModelState.IsValid)
{
db.Entry(viewattdataot).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(viewattdataot));
}
// GET: /Editor/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ViewAttDataOT viewattdataot = db.ViewAttDataOTs.Find(id);
if (viewattdataot == null)
{
return(HttpNotFound());
}
return(View(viewattdataot));
}
public ActionResult Create([Bind(Include = "EmpDate,AttDate,Tin1,Tout1,Tin2,Tout2,Tin3,Tout3,Mins,EmpNo,EmpName,Expr1,CompName,EmpID")] ViewAttDataOT viewattdataot)
{
User LoggedInUser = Session["LoggedUser"] as User;
if (viewattdataot.CompName == null)
{
ModelState.AddModelError("CompName", "This Company Name is not existing");
}
if (ModelState.IsValid)
{
db.ViewAttDataOTs.Add(viewattdataot);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CompName = new SelectList(CustomFunction.GetCompanies(db.Companies.ToList(), LoggedInUser), "CompID", "CompName", LoggedInUser.CompanyID);
return(View(viewattdataot));
}
public ActionResult EditorOT(FormCollection form)
{
TAS2013Entities db = new TAS2013Entities();
try
{
User LoggedInUser = Session["LoggedUser"] as User;
ViewBag.CompanyID = new SelectList(CustomFunction.GetCompanies(db.Companies.ToList(), LoggedInUser), "CompID", "CompName", LoggedInUser.CompanyID);
ViewData["datef"] = Convert.ToDateTime(Request.Form["DateFrom"].ToString()).ToString("yyyy-MM-dd");
//ViewData["datef"] = Request.Form["DateFrom"].ToString();
if (Request.Form["EmpNo"].ToString() != "" && Request.Form["DateFrom"].ToString() != "")
{
string _EmpNo = Request.Form["EmpNo"].ToString();
DateTime _AttDataFrom = Convert.ToDateTime(Request.Form["DateFrom"].ToString());
Session["EditAttendanceDate"] = Request.Form["DateFrom"].ToString();
var _CompId = Request.Form["CompanyID"];
int compID = Convert.ToInt32(_CompId);
ViewAttDataOT _attData = new ViewAttDataOT();
List <EmpView> _Emp = new List <EmpView>();
int EmpID = 0;
_Emp = db.EmpViews.Where(aa => aa.EmpNo == _EmpNo && aa.CompanyID == compID && aa.Status == true).ToList();
if (_Emp.Count > 0)
{
EmpID = _Emp.FirstOrDefault().EmpID;
if (db.AttDataOTs.Where(aa => aa.EmpID == EmpID && aa.AttDate == _AttDataFrom).Count() > 0)
{
_attData = db.ViewAttDataOTs.First(aa => aa.EmpID == EmpID && aa.AttDate == _AttDataFrom);
}
}
_attData.EmpID = EmpID;
_attData.EmpNo = _Emp.FirstOrDefault().EmpNo;
_attData.AttDate = _AttDataFrom;
_attData.EmpName = _Emp.FirstOrDefault().EmpName;
_attData.FatherName = _Emp.FirstOrDefault().FatherName;
_attData.SectionName = _Emp.FirstOrDefault().SectionName;
_attData.DeptName = _Emp.FirstOrDefault().DeptName;
_attData.DesignationName = _Emp.FirstOrDefault().DesignationName;
if (_attData.EmpNo != null)
{
List <PollData> _Polls = new List <PollData>();
string _EmpDate = _attData.EmpID.ToString() + _AttDataFrom.Date.ToString("yyMMdd");
_Polls = db.PollDatas.Where(aa => aa.EntDate == _AttDataFrom && aa.EmpID == _attData.EmpID).OrderBy(a => a.EntTime).ToList();
ViewBag.PollsDataIn = _Polls.Where(aa => aa.Reader.OnlyOT == true && aa.RdrDuty == 1);
ViewBag.PollsDataOut = _Polls.Where(aa => aa.Reader.OnlyOT == true && aa.RdrDuty == 1);
ViewBag.EmpID = new SelectList(db.Emps.OrderBy(s => s.EmpName), "EmpID", "EmpNo", _attData.EmpID);
Session["NEmpNo"] = _attData.EmpID;
ViewBag.SucessMessage = "";
return(View(_attData));
}
else
{
return(View(_attData));
}
}
else
{
return(View("Index"));
}
}
catch (Exception ex)
{
if (ex.Message.Contains("Sequence"))
{
ViewBag.Message = "No Entry found on this particular date";
}
return(View("Index"));
}
}
