public ActionResult Autherize(ProjectManagementSystem.Models.EMPLOYEE userModel) { using (ProjectManagementSystemEntities db = new ProjectManagementSystemEntities()) { var userDetails = db.EMPLOYEEs.Where(x => x.F_name == userModel.F_name && x.L_name == userModel.L_name).FirstOrDefault(); if (userDetails == null) { userModel.LoginErrorMessage = "Wrong username or password."; return(View("Index", userModel)); } else { if (userDetails.Employee_type == "2") { return(RedirectToAction("Index", "HomeForClient")); } else { if (userDetails.Employee_type == "3") { return(RedirectToAction("Index", "HomeForEmployee")); } else { return(RedirectToAction("Index", "Home")); } } } } }
/// <summary> /// Inserting Data. /// </summary> /// <param name="obj"></param> public void InsertData(ChangePasswordTBL obj) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); ent.ChangePasswordTBLs.AddObject(obj); ent.SaveChanges(); }
public int GetModuleId(int Empid) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); ModuleAssigned obj = (from a in ent.ModuleAssigneds where a.TeamLeaderId == Empid select a).FirstOrDefault(); return(Convert.ToInt32(obj.ModuleId)); }
//public List<developergrid> fillGridForDeveloper(int DID) //{ // ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); // List<developergrid> obj = (from ta in ent.TaskAssigneds // join t in ent.Tasks on ta.TaskId equals t.TaskId // select new developergrid // { // TaskId = t.TaskId, // TaskName = t.TaskName, // TaskDescription = t.TaskDescription, // StartDate = Convert.ToString(t.StartDate), // EndDate = Convert.ToString(t.EndDate), // }).ToList(); // return obj; //} public int GetTaskId(int DID) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); TaskAssigned obj = (from a in ent.TaskAssigneds where a.EmpId == DID select a).FirstOrDefault(); return(Convert.ToInt32(obj.TaskId)); }
public List <Project> returnAllProject() { List <Project> projects = new List <Project>(); using (var context = new ProjectManagementSystemEntities()) { projects = context.Database.SqlQuery <Project>("select * from Project").ToList <Project>(); foreach (var pr in projects) { pr.User = context.Database.SqlQuery <User>($"select * from Users where Username='******'").FirstOrDefault(); pr.Tasks = context.Database.SqlQuery <ProjectManagmentSystem.Task>($"select * from Tasks where ProjectCode = '{pr.ProjectCode}'").ToList <Task>(); } /*(from p in context.Projects * select new { * ProjectCode=p.ProjectCode, * Name=p.Name, * ProjectManager=p.ProjectManager, * Tasks=(from t in context.Tasks where t.ProjectCode==p.ProjectCode select new {TaskID=t.TaskID }).ToList() * }).ToList(); * projects = new BindingList<Project>(dataa);*/ BindingList <Project> projectssss = new BindingList <Project>(projects); dvgProjects.DataSource = projectssss; } }
public List <AttendenceMaster> fillAttendenceGridForAdmin() { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); List <AttendenceMaster> obj = (from a in ent.AttendenceMasters select a).ToList(); return(obj); }
/// <summary> /// Get Data for client grid view. /// </summary> /// <returns></returns> public List <Client> getdataforclient() { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); List <Client> objclnt = (from a in ent.Clients select a).ToList(); return(objclnt); }
/// <summary> /// Retrive Record for perticular client. /// </summary> /// <param name="id"></param> /// <returns></returns> public Client retriveClientrecord(int id) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); Client objclnt = (from a in ent.Clients where a.ClientId == id select a).FirstOrDefault(); return(objclnt); }
/// <summary> /// Fill GridView of all employee Attendence in HR panel. /// </summary> /// <returns></returns> public List <AttendenceMaster> fillGrid(int id) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); List <AttendenceMaster> obj = (from a in ent.AttendenceMasters where a.EmpId == id select a).ToList(); return(obj); }
/// <summary> /// Take new password. /// </summary> /// <param name="id"></param> /// <returns></returns> public string TakePassword(int id) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); List <ChangePasswordTBL> objj = (from a in ent.ChangePasswordTBLs where a.EmpId == id select a).ToList(); ChangePasswordTBL obj = objj.Last(); return(obj.NewPassword); }
/// <summary> /// Deleting Record. /// </summary> /// <param name="id"></param> public void DeleteData(int id) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); TaskAssigned obj = (from a in ent.TaskAssigneds where a.TaskId == id select a).FirstOrDefault(); if (obj != null) { ent.TaskAssigneds.DeleteObject(obj); ent.SaveChanges(); } }
public void InsertData(ModuleAssigned obj) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); ModuleAssigned objM = (from a in ent.ModuleAssigneds where a.TeamLeaderId == obj.TeamLeaderId && a.ModuleId == obj.ModuleId select a).FirstOrDefault(); if (objM == null) { ent.ModuleAssigneds.AddObject(obj); ent.SaveChanges(); } }
/// <summary> /// Delete Data for client grid view. /// </summary> /// <param name="id"></param> public void deleteClientdata(int id) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); Client objclnt = (from a in ent.Clients where a.ClientId == id select a).FirstOrDefault(); if (objclnt != null) { ent.Clients.DeleteObject(objclnt); ent.SaveChanges(); } }
/// <summary> /// Delete Attendence from the Attendence Grid view in HR Panel. /// </summary> /// <param name="id"></param> public void deleteAttendence(int id) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); AttendenceMaster obj = (from a in ent.AttendenceMasters where a.EmpId == id select a).FirstOrDefault(); if (obj != null) { ent.AttendenceMasters.DeleteObject(obj); ent.SaveChanges(); } }
/// <summary> /// Insert new Record. /// </summary> /// <param name="obj"></param> public void InsertData(TaskAssigned obj) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); TaskAssigned objT = (from a in ent.TaskAssigneds where a.EmpId == obj.EmpId && a.TaskId == obj.TaskId select a).FirstOrDefault(); if (objT == null) { ent.TaskAssigneds.AddObject(obj); ent.SaveChanges(); } }
public void deleteModuledata(int ID) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); ModuleAssigned obj = (from a in ent.ModuleAssigneds where a.Id == ID select a).FirstOrDefault(); if (obj != null) { ent.ModuleAssigneds.DeleteObject(obj); ent.SaveChanges(); } }
/// <summary> /// Getting projct Id used for project manager to display own projects. /// </summary> /// <param name="ProMID"></param> /// <returns></returns> public int getProjectId(int ProMID) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); ProjectAssigned obj = (from a in ent.ProjectAssigneds where a.ProjectManagerId == ProMID select a).FirstOrDefault(); if (obj != null) { return(Convert.ToInt32(obj.ProjectId)); } else { return(0); } }
/// <summary> /// Inserts new project Assigned data. /// </summary> /// <param name="obj"></param> public void InsertData(ProjectAssigned obj) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); ProjectAssigned objp = (from a in ent.ProjectAssigneds where a.ProjectId == obj.ProjectId && a.ProjectManagerId == obj.ProjectManagerId select a).FirstOrDefault(); if (objp == null) { //objp.ProjectId = obj.ProjectId; //objp.ProjectManagerId = obj.ProjectManagerId; ent.ProjectAssigneds.AddObject(obj); ent.SaveChanges(); } }
/// <summary> /// Add New Client /// </summary> /// <param name="objclnt"></param> public void AddNewClient(Client objclnt) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); Client obj = new Client(); obj.FirstName = objclnt.FirstName; obj.MiddelName = objclnt.MiddelName; obj.LastName = objclnt.LastName; obj.Mobile = objclnt.Mobile; obj.Email = objclnt.Email; obj.CreateDate = objclnt.CreateDate; obj.CreateBy = objclnt.CreateBy; obj.IsActive = objclnt.IsActive; obj.IsDelete = objclnt.IsDelete; ent.Clients.AddObject(obj); ent.SaveChanges(); }
/// <summary> /// Update Data for Client. /// </summary> /// <param name="objclnt"></param> public void updateClientdata(Client objclnt) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); Client objclntupdate = (from a in ent.Clients where a.ClientId == objclnt.ClientId select a).FirstOrDefault(); if (objclntupdate != null) { objclntupdate.FirstName = objclnt.FirstName; objclntupdate.LastName = objclnt.LastName; objclntupdate.MiddelName = objclnt.MiddelName; objclntupdate.Mobile = objclnt.Mobile; objclntupdate.Email = objclnt.Email; objclntupdate.ModifyDate = objclnt.ModifyDate; objclntupdate.ModifyBy = objclnt.ModifyBy; ent.SaveChanges(); } }
//public class developergrid //{ // public int TaskId { get; set; } // public string TaskName { get; set; } // public string TaskDescription { get; set; } // public string StartDate { get; set; } // public string EndDate { get; set; } //} /// <summary> /// Fill GRID VIEW. /// </summary> /// <returns></returns> public List <gridview> fillGrid() { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); List <gridview> obj = (from at in ent.TaskAssigneds join em in ent.Employees on at.EmpId equals em.EmpID join t in ent.Tasks on at.TaskId equals t.TaskId select new gridview { EmpId = at.EmpId ?? 0, TaskId = at.TaskId ?? 0, TaskName = t.TaskName, FirstName = em.FirstName, MiddelName = em.MiddelName, LastName = em.LastName, }).ToList(); return(obj); }
public List <AssignModuleView> fillGrid() { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); List <AssignModuleView> ModuleList = (from pa in ent.ModuleAssigneds join cp in ent.Modules on pa.ModuleId equals cp.ModuleId join em in ent.Employees on pa.TeamLeaderId equals em.EmpID select new AssignModuleView { Id = pa.Id, FirstName = em.FirstName, LastName = em.LastName, MiddelName = em.MiddelName, TeamLeaderId = em.EmpID, ModuleId = cp.ModuleId, ModuleName = cp.ModuleName }).ToList(); return(ModuleList); }
/// <summary> /// Retrive records for grid view. /// </summary> /// <returns></returns> public List <AssignProjectView> FillGrid() { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); List <AssignProjectView> ProjectList = (from pa in ent.ProjectAssigneds join cp in ent.ClientProjects on pa.ProjectId equals cp.ProjectId join em in ent.Employees on pa.ProjectManagerId equals em.EmpID select new AssignProjectView { Id = pa.Id, FirstName = em.FirstName, LastName = em.LastName, MiddelName = em.MiddelName, PrjectManagerId = em.EmpID, ProjectId = cp.ProjectId, ProjectName = cp.ProjectName }).ToList(); return(ProjectList); }
/// <summary> /// Take Attendence of Each employeee on button click /// </summary> /// <param name="id"></param> public void TakeAttendence(int id, DateTime loginTime) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); AttendenceMaster obj = (from a in ent.AttendenceMasters where a.EmpId == id orderby a.Month descending select a).FirstOrDefault(); if (obj != null) { DateTime now = DateTime.Now; int month = now.Month; if (obj.Month == month) { DayEntry(obj, ent, 1); } else { DateTime now1 = DateTime.Now; ProjectManagementSystemEntities ent1 = new ProjectManagementSystemEntities(); AttendenceMaster objAttend = new AttendenceMaster(); objAttend.EmpId = id; objAttend.LoginTime = loginTime; objAttend.Month = now1.Month; objAttend.Year = now1.Year; DayEntry(objAttend, ent1, 0); } } else { DateTime now1 = DateTime.Now; ProjectManagementSystemEntities ent1 = new ProjectManagementSystemEntities(); AttendenceMaster objAttend = new AttendenceMaster(); objAttend.EmpId = id; objAttend.LoginTime = loginTime; objAttend.Month = now1.Month; objAttend.Year = now1.Year; DayEntry(objAttend, ent1, 0); } }
/// <summary> /// Performs Day Entry for All employees. /// </summary> /// <param name="obj"></param> /// <param name="ent"></param> /// <param name="flag"></param> public void DayEntry(AttendenceMaster obj, ProjectManagementSystemEntities ent, int flag) { DateTime now = DateTime.Now; int date = Convert.ToDateTime(now.Date).Day; switch (date) { case 1: if (flag == 1) { obj.Day1 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day1 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 2: if (flag == 1) { obj.Day2 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day2 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 3: if (flag == 1) { obj.Day3 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day3 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 4: if (flag == 1) { obj.Day4 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day4 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 5: if (flag == 1) { obj.Day5 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day5 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 6: if (flag == 1) { obj.Day6 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day6 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 7: if (flag == 1) { obj.Day7 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day7 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 8: if (flag == 1) { obj.Day8 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day8 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 9: if (flag == 1) { obj.Day9 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day9 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 10: if (flag == 1) { obj.Day10 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day10 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 11: if (flag == 1) { obj.Day11 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day11 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 12: if (flag == 1) { obj.Day12 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day12 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 13: if (flag == 1) { obj.Day13 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day13 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 14: if (flag == 1) { obj.Day14 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day14 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 15: if (flag == 1) { obj.Day15 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day15 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 16: if (flag == 1) { obj.Day16 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day16 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 17: if (flag == 1) { obj.Day17 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day17 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 18: if (flag == 1) { obj.Day18 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day18 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 19: if (flag == 1) { obj.Day19 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day19 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 20: if (flag == 1) { obj.Day20 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day20 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 21: if (flag == 1) { obj.Day21 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day21 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 22: if (flag == 1) { obj.Day22 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day22 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 23: if (flag == 1) { obj.Day23 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day23 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 24: if (flag == 1) { obj.Day24 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day24 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 25: if (flag == 1) { obj.Day25 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day25 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 26: if (flag == 1) { obj.Day26 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day26 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 27: if (flag == 1) { obj.Day27 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day27 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 28: if (flag == 1) { obj.Day28 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day28 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 29: if (flag == 1) { obj.Day29 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day29 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 30: if (flag == 1) { obj.Day30 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day30 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; case 31: if (flag == 1) { obj.Day31 = true; ent.SaveChanges(); } else if (flag == 0) { obj.Day31 = true; ent.AttendenceMasters.AddObject(obj); ent.SaveChanges(); } break; } }
/// <summary> /// checking for Attendence button is visible or not. /// </summary> /// <param name="id"></param> /// <returns></returns> public int CheckForVisibility(int id) { ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities(); int flag = 0; AttendenceMaster obj = (from a in ent.AttendenceMasters where a.EmpId == id orderby a.Month descending select a).FirstOrDefault(); DateTime now = DateTime.Now; int date = Convert.ToDateTime(now.Date).Day; switch (date) { case 1: if (obj.Day1 == null) { flag = 1; } else { flag = 0; } break; case 2: if (obj.Day2 == null) { flag = 1; } else { flag = 0; } break; case 3: if (obj.Day3 == null) { flag = 1; } else { flag = 0; } break; case 4: if (obj.Day4 == null) { flag = 1; } else { flag = 0; } break; case 5: if (obj.Day5 == null) { flag = 1; } else { flag = 0; } break; case 6: if (obj.Day6 == null) { flag = 1; } else { flag = 0; } break; case 7: if (obj.Day7 == null) { flag = 1; } else { flag = 0; } break; case 8: if (obj.Day8 == null) { flag = 1; } else { flag = 0; } break; case 9: if (obj.Day9 == null) { flag = 1; } else { flag = 0; } break; case 10: if (obj.Day10 == null) { flag = 1; } else { flag = 0; } break; case 11: if (obj.Day11 == null) { flag = 1; } else { flag = 0; } break; case 12: if (obj.Day12 == null) { flag = 1; } else { flag = 0; } break; case 13: if (obj.Day13 == null) { flag = 1; } else { flag = 0; } break; case 14: if (obj.Day14 == null) { flag = 1; } else { flag = 0; } break; case 15: if (obj.Day15 == null) { flag = 1; } else { flag = 0; } break; case 16: if (obj.Day16 == null) { flag = 1; } else { flag = 0; } break; case 17: if (obj.Day17 == null) { flag = 1; } else { flag = 0; } break; case 18: if (obj.Day18 == null) { flag = 1; } else { flag = 0; } break; case 19: if (obj.Day19 == null) { flag = 1; } else { flag = 0; } break; case 20: if (obj.Day20 == null) { flag = 1; } else { flag = 0; } break; case 21: if (obj.Day21 == null) { flag = 1; } else { flag = 0; } break; case 22: if (obj.Day22 == null) { flag = 1; } else { flag = 0; } break; case 23: if (obj.Day23 == null) { flag = 1; } else { flag = 0; } break; case 24: if (obj.Day24 == null) { flag = 1; } else { flag = 0; } break; case 25: if (obj.Day25 == null) { flag = 1; } else { flag = 0; } break; case 26: if (obj.Day26 == null) { flag = 1; } else { flag = 0; } break; case 27: if (obj.Day27 == null) { flag = 1; } else { flag = 0; } break; case 28: if (obj.Day28 == null) { flag = 1; } else { flag = 0; } break; case 29: if (obj.Day29 == null) { flag = 1; } else { flag = 0; } break; case 30: if (obj.Day30 == null) { flag = 1; } else { flag = 0; } break; case 31: if (obj.Day31 == null) { flag = 1; } else { flag = 0; } break; } return(flag); }