public ActionResult Register(Employee obj)
{
if (ModelState != null)
{
TSREntities data = new TSREntities();
data.Employees.Add(obj);
data.SaveChanges();
}
ViewBag.Message = obj.FirstName + " " + obj.LastName + " " + "Successfully Registerd";
ModelState.Clear();
return(View());
}
public ActionResult List()
{
//RegMvc ob = new RegMvc();
//List<RegMvc> list = new List<RegMvc>();
//list.Add(ob);
//return View(list.ToList());
TSREntities obj = new TSREntities();
List <RegMvc> reg = obj.RegMvcs.ToList();
return(View(reg));
}
public ActionResult Register(RegMvc obj)
{
if (ModelState.IsValid)
{
TSREntities db = new TSREntities();
db.RegMvcs.Add(obj);
db.SaveChanges();
}
ViewBag.Message = obj.FirstName + " " + obj.LastName + " " + "Successfully registerd";
ModelState.Clear();
return(View());
}
public JsonResult DeleteEmployee(int taskId)
{
TSREntities entities = new TSREntities();
TasksImpUrg IU = (from c in entities.TasksImpUrgs
where c.TaskId == taskId
select c).FirstOrDefault();
TasksImpNurg INU = (from c in entities.TasksImpNurgs
where c.TaskId == taskId
select c).FirstOrDefault();
TasksNimpUrg NIU = (from c in entities.TasksNimpUrgs
where c.TaskId == taskId
select c).FirstOrDefault();
TasksNimpNurg NINU = (from c in entities.TasksNimpNurgs
where c.TaskId == taskId
select c).FirstOrDefault();
EmployeeTaskList deletedtedEmployee = (from c in entities.EmployeeTaskLists
where c.TaskId == taskId
select c).FirstOrDefault();
entities.EmployeeTaskLists.Remove(deletedtedEmployee);
if (IU != null)
{
entities.TasksImpUrgs.Remove(IU);
}
if (INU != null)
{
entities.TasksImpNurgs.Remove(INU);
}
if (NIU != null)
{
entities.TasksNimpUrgs.Remove(NIU);
}
if (NINU != null)
{
entities.TasksNimpNurgs.Remove(NINU);
}
entities.SaveChanges();
return(Json("yes", JsonRequestBehavior.AllowGet));
}
public JsonResult List(EmployeeTaskModel model)
{
TSREntities db = new TSREntities();
EmployeeTaskList obj = new EmployeeTaskList();
//DateTime dt = DateTime.Parse(TaskDate, CultureInfo.InvariantCulture);
obj.EmpId = Session["Empid"].ToString();
obj.TaskDate = model.TaskDate;
obj.Task = model.Task;
obj.Type_Of_Task = model.Type_Of_Task;
db.EmployeeTaskLists.Add(obj);
db.SaveChanges();
return(Json("yes", JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateNINU(EmployeeTaskModel employees)
{
using (TSREntities entities = new TSREntities())
{
TasksNimpNurg updatedEmployee = (from c in entities.TasksNimpNurgs
where c.TaskId == employees.TaskId
select c).FirstOrDefault();
updatedEmployee.Task = employees.Task;
updatedEmployee.Type_Of_Task = employees.Type_Of_Task;
//updatedEmployee.Start_Time = employees.Start_Time;
//updatedEmployee.End_Time = employees.End_Time;
updatedEmployee.Status = employees.Status;
entities.SaveChanges();
}
return(Json("yes", JsonRequestBehavior.AllowGet));
}
public ActionResult Login(Employee obj)
{
TSREntities db = new TSREntities();
var user = db.Employees.SingleOrDefault(u => u.EmpId == obj.EmpId && u.Password == obj.Password);
if (user != null)
{
Session["Empid"] = user.EmpId.ToString();
Session["Fname"] = user.FirstName.ToString();
Session["Lname"] = user.LastName.ToString();
return(RedirectToAction("UserPage"));
}
else
{
ViewBag.Message = "Invalid Credentials";
}
return(View());
}
public ActionResult Login(RegMvc obj)
{
TSREntities db = new TSREntities();
var user = db.RegMvcs.Single(u => u.Email == obj.Email && u.Password == obj.Password);
if (user != null)
{
Session["email"] = user.Email.ToString();
Session["password"] = user.Password.ToString();
Session["Fname"] = user.FirstName.ToString();
Session["Lname"] = user.LastName.ToString();
return(RedirectToAction("LoggedIn"));
}
else
{
ModelState.AddModelError("", "Invalid Email or Password");
}
return(View());
}
public ActionResult NIUTasks()
{
TSREntities ob = new TSREntities();
string empID = Session["Empid"].ToString();
List <EmployeeTaskModel> lis = (from log in ob.TasksNimpUrgs
where log.EmpId == empID
select log).Select(x => new EmployeeTaskModel
{
EmpId = x.EmpId,
TaskDate = x.TaskDate,
Task = x.Task,
TaskId = x.TaskId,
Type_Of_Task = x.Type_Of_Task,
//Start_Time = x.Start_Time,
//End_Time = x.End_Time,
Status = x.Status
}).ToList();
return(PartialView("NIUList", lis));
}
public ActionResult ParSearch(string PDate)
{
TSREntities db = new TSREntities();
string empID = Session["Empid"].ToString();
DateTime dt1 = DateTime.Parse(PDate, CultureInfo.InvariantCulture);
List <EmployeeTaskModel> serData = (from log in db.EmployeeTaskLists
where ((EntityFunctions.TruncateTime(log.TaskDate) == EntityFunctions.TruncateTime(dt1)) && (log.EmpId == empID))
select log).Select(x => new EmployeeTaskModel
{
EmpId = x.EmpId,
TaskDate = x.TaskDate,
Task = x.Task,
TaskId = x.TaskId,
Type_Of_Task = x.Type_Of_Task,
//Start_Time = x.Start_Time,
//End_Time = x.End_Time,
Status = x.Status
}).ToList();
return(PartialView("TaskList", serData));
}
public JsonResult saveList(string ItemList, string TableName)
{
TSREntities db = new TSREntities();
var main = ItemList.Split(',');
foreach (var itm in main)
{
RegMvc ob = db.RegMvcs.Single(x => x.Id.ToString() == itm);
RegMvc1 ob1 = new RegMvc1();
ob1.Id = ob.Id;
ob1.FirstName = ob.FirstName;
ob1.LastName = ob.LastName;
ob1.Email = ob.Email;
ob1.Password = ob.Password;
ob1.ConfirmPassword = ob.ConfirmPassword;
db.RegMvc1.Add(ob1);
db.SaveChanges();
}
return(Json("yes", JsonRequestBehavior.AllowGet));
}
public ActionResult BtwSearch(string From, string To)
{
TSREntities db = new TSREntities();
string empID = Session["Empid"].ToString();
DateTime dt1 = DateTime.Parse(From, CultureInfo.InvariantCulture);
DateTime dt2 = DateTime.Parse(To, CultureInfo.InvariantCulture);
List <EmployeeTaskModel> serData = (from x in db.EmployeeTaskLists
where ((EntityFunctions.TruncateTime(x.TaskDate) >= EntityFunctions.TruncateTime(dt1) && EntityFunctions.TruncateTime(x.TaskDate) <= EntityFunctions.TruncateTime(dt2)) && x.EmpId == empID)
select x).Select(x => new EmployeeTaskModel
{
EmpId = x.EmpId,
TaskDate = x.TaskDate,
Task = x.Task,
TaskId = x.TaskId,
Type_Of_Task = x.Type_Of_Task,
//Start_Time = x.Start_Time,
//End_Time = x.End_Time,
Status = x.Status
}).ToList();
return(PartialView("TaskList", serData));
}
public JsonResult saveList(string ItemList, string TableName)
{
TSREntities db = new TSREntities();
var main = ItemList.Split(','); // Split the taskids
switch (TableName)
{
case "IU":
foreach (var itm in main)
{
EmployeeTaskList ob = db.EmployeeTaskLists.Single(x => x.TaskId.ToString() == itm);
TasksImpUrg ob1 = new TasksImpUrg();
if (ob.Flag == 1)
{
return(Json("no", JsonRequestBehavior.AllowGet));
}
else
{
ob1.EmpId = ob.EmpId;
ob1.TaskId = ob.TaskId;
ob1.TaskDate = ob.TaskDate;
ob1.Task = ob.Task;
ob1.Type_Of_Task = ob.Type_Of_Task;
//ob1.Start_Time = ob.Start_Time;
//ob1.End_Time = ob.End_Time;
ob1.Status = ob.Status;
db.TasksImpUrgs.Add(ob1);
ob.Flag = 1;
db.SaveChanges();
}
}
break;
case "INU":
foreach (var itm in main)
{
EmployeeTaskList ob = db.EmployeeTaskLists.Single(x => x.TaskId.ToString() == itm);
TasksImpNurg ob1 = new TasksImpNurg();
if (ob.Flag == 1)
{
return(Json("no", JsonRequestBehavior.AllowGet));
}
else
{
ob1.EmpId = ob.EmpId;
ob1.TaskId = ob.TaskId;
ob1.TaskDate = ob.TaskDate;
ob1.Task = ob.Task;
ob1.Type_Of_Task = ob.Type_Of_Task;
//ob1.Start_Time = ob.Start_Time;
//ob1.End_Time = ob.End_Time;
ob1.Status = ob.Status;
db.TasksImpNurgs.Add(ob1);
ob.Flag = 1;
db.SaveChanges();
}
}
break;
case "NIU":
foreach (var itm in main)
{
EmployeeTaskList ob = db.EmployeeTaskLists.Single(x => x.TaskId.ToString() == itm);
TasksNimpUrg ob1 = new TasksNimpUrg();
if (ob.Flag == 1)
{
return(Json("no", JsonRequestBehavior.AllowGet));
}
else
{
ob1.EmpId = ob.EmpId;
ob1.TaskId = ob.TaskId;
ob1.TaskDate = ob.TaskDate;
ob1.Task = ob.Task;
ob1.Type_Of_Task = ob.Type_Of_Task;
//ob1.Start_Time = ob.Start_Time;
//ob1.End_Time = ob.End_Time;
ob1.Status = ob.Status;
db.TasksNimpUrgs.Add(ob1);
ob.Flag = 1;
db.SaveChanges();
}
}
break;
case "NINU":
foreach (var itm in main)
{
EmployeeTaskList ob = db.EmployeeTaskLists.Single(x => x.TaskId.ToString() == itm);
TasksNimpNurg ob1 = new TasksNimpNurg();
if (ob.Flag == 1)
{
return(Json("no", JsonRequestBehavior.AllowGet));
}
else
{
ob1.EmpId = ob.EmpId;
ob1.TaskId = ob.TaskId;
ob1.TaskDate = ob.TaskDate;
ob1.Task = ob.Task;
ob1.Type_Of_Task = ob.Type_Of_Task;
//ob1.Start_Time = ob.Start_Time;
//ob1.End_Time = ob.End_Time;
ob1.Status = ob.Status;
db.TasksNimpNurgs.Add(ob1);
ob.Flag = 1;
db.SaveChanges();
}
}
break;
default:
break;
}
return(Json("yes", JsonRequestBehavior.AllowGet));
}
