コード例 #1
0
 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"));
                 }
             }
         }
     }
 }
コード例 #2
0
ファイル: ChangePasswordBL.cs プロジェクト: DaxMalaviya/local
        /// <summary>
        /// Inserting Data.
        /// </summary>
        /// <param name="obj"></param>
        public void InsertData(ChangePasswordTBL obj)
        {
            ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities();

            ent.ChangePasswordTBLs.AddObject(obj);
            ent.SaveChanges();
        }
コード例 #3
0
        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));
        }
コード例 #4
0
ファイル: AssignedTaskBL.cs プロジェクト: DaxMalaviya/local
        //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));
        }
コード例 #5
0
        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;
            }
        }
コード例 #6
0
        public List <AttendenceMaster> fillAttendenceGridForAdmin()
        {
            ProjectManagementSystemEntities ent = new ProjectManagementSystemEntities();
            List <AttendenceMaster>         obj = (from a in ent.AttendenceMasters select a).ToList();

            return(obj);
        }
コード例 #7
0
        /// <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);
        }
コード例 #8
0
        /// <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);
        }
コード例 #9
0
        /// <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);
        }
コード例 #10
0
ファイル: ChangePasswordBL.cs プロジェクト: DaxMalaviya/local
        /// <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);
        }
コード例 #11
0
ファイル: AssignedTaskBL.cs プロジェクト: DaxMalaviya/local
        /// <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();
            }
        }
コード例 #12
0
        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();
            }
        }
コード例 #13
0
        /// <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();
            }
        }
コード例 #14
0
        /// <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();
            }
        }
コード例 #15
0
ファイル: AssignedTaskBL.cs プロジェクト: DaxMalaviya/local
        /// <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();
            }
        }
コード例 #16
0
        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();
            }
        }
コード例 #17
0
        /// <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);
            }
        }
コード例 #18
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();
            }
        }
コード例 #19
0
        /// <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();
        }
コード例 #20
0
        /// <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();
            }
        }
コード例 #21
0
ファイル: AssignedTaskBL.cs プロジェクト: DaxMalaviya/local
        //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);
        }
コード例 #22
0
        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);
        }
コード例 #23
0
        /// <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);
        }
コード例 #24
0
        /// <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);
            }
        }
コード例 #25
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;
            }
        }
コード例 #26
0
        /// <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);
        }