Exemplo n.º 1
0
        public ActionResult EditEmp(int id)
        {
            if (Session["EmpName"] != null)
            {
                using (EmpDbContext empDb = new EmpDbContext())
                {
                    //SqlParameter param1 = new SqlParameter("@EmployeeId", id);
                    //var employee = empDb.Employees.SqlQuery(@"Exec GetEmpById @EmployeeId", param1).Single();

                    var result = (from s in empDb.Employees where s.EmployeeId == id select s).FirstOrDefault();

                    if (result != null)
                    {
                        ViewBag.CountryList = new SelectList(GetCountryList(), "CountryId", "CountryName");
                        if (result.CountryId != null)
                        {
                            var coID = (int)result.CountryId;
                            ViewBag.StatesList = new SelectList(GetStatesList(coID), "StateId", "StateName");
                        }


                        return(View(result));
                    }
                    else
                    {
                        return(View());
                    }
                }
            }
            else
            {
                return(RedirectToAction("Index"));
            }
        }
Exemplo n.º 2
0
        public ActionResult EmpDetails(int id)
        {
            //if (Session["EmpName"] != null)
            //{
            using (EmpDbContext empDb = new EmpDbContext())
            {
                var result = (from s in empDb.Employees where s.EmployeeId == id select s).FirstOrDefault();

                if (result != null)
                {
                    return(View(result));
                }
                else
                {
                    return(View());
                }
            }



            //}
            //else
            //{
            //    return RedirectToAction("Index");
            //}
        }
Exemplo n.º 3
0
        public List <Country> GetCountryList()
        {
            using (EmpDbContext db = new EmpDbContext())
            {
                List <Country> countries = db.Countries.ToList();

                return(countries);
            }
        }
Exemplo n.º 4
0
        public List <States> GetStatesList(int couID)
        {
            using (EmpDbContext db = new EmpDbContext())
            {
                List <States> states = db.States.Where(x => x.CountryId == couID).ToList();

                return(states);
            }
        }
Exemplo n.º 5
0
 public ActionResult GetStateList(int CountryId)
 {
     using (EmpDbContext db = new EmpDbContext())
     {
         List <States> stateList = db.States.Where(x => x.CountryId == CountryId).ToList();
         ViewBag.StateOptions = new SelectList(stateList, "StateId", "StateName");
         return(PartialView("_StateOptionPartial"));
     }
 }
        public ActionResult ImageRetrieve(int imgID)
        {
            using (EmpDbContext db = new EmpDbContext())
            {
                var img = db.FileUploads.SingleOrDefault(x => x.ImageId == imgID);

                return(File(img.Imagelength, "image/jpg"));
            }
        }
Exemplo n.º 7
0
        public ActionResult Index(string UserName, string Password)
        {
            if (ModelState.IsValid)
            {
                try
                {
                    using (EmpDbContext db = new EmpDbContext())
                    {
                        // var result = db.Users.FirstOrDefault(u => u.UserName == UserName && u.Password == Password);

                        var result = (from s in db.Users where s.UserName == UserName || s.Email == UserName select s).FirstOrDefault();
                        if (result != null)
                        {
                            var hashCode = result.Vcode;
                            //Password Hasing Process Call Helper Class Method
                            var encodingPasswordString = Helper.EncodePassword(Password, hashCode);
                            //Check Login Detail User Name Or Password
                            var query = (from s in db.Users where (s.UserName == UserName || s.Email == UserName) && s.Password.Equals(encodingPasswordString) select s).FirstOrDefault();
                            var empdb = new EmpDbContext();
                            if (query != null)
                            {
                                var getrole = (from s in empdb.Roles where (s.Roleid == query.Roleid) select s).FirstOrDefault();
                                Session["EmpName"]       = Convert.ToString(result.UserName);
                                Session["EmpID"]         = Convert.ToInt32(result.Empid);
                                Session["RoleID"]        = Convert.ToInt32(result.Roleid);
                                Session["Role"]          = Convert.ToString(getrole.RoleName);
                                Session["SessionExpire"] = false;

                                return(RedirectToAction("About"));
                            }
                            else
                            {
                                ViewBag.Message = "Invalid Password";
                                return(View());
                            }
                        }
                        else
                        {
                            ViewBag.Message = "Invalid UserName and Password";
                            return(View());
                        }
                    }
                }

                catch (Exception e)
                {
                    logger.ErrorException("Error occured in Home controller Index Action", e);
                    ViewBag.Message = "Error Login";
                    return(View());
                }
            }
            else
            {
                return(View());
            }
        }
Exemplo n.º 8
0
        public ActionResult Register()
        {
            var p = new User();

            using (EmpDbContext db = new EmpDbContext())
            {
                p.RoleList = db.Roles.ToList();
            }
            return(View(p));
            //return View();
        }
 public ActionResult DeleteSiteSettings(int SiteID)
 {
     // SiteSettings model = new SiteSettings();
     using (EmpDbContext db = new EmpDbContext())
     {
         SiteSettings sitelist = db.siteSettings.SingleOrDefault(x => x.SettingsID == SiteID);
         sitelist.Checkstatus = "N";
         db.SaveChanges();
     }
     return(RedirectToAction("SiteSetting", "Utility"));
 }
Exemplo n.º 10
0
        public ActionResult Index()
        {
            //Session.Abandon();


            using (EmpDbContext dba = new EmpDbContext())
            {
                var ado = dba.Employees.ToList();
                return(View());
            }
            //return View();
        }
        public ActionResult DeleteRole(int RoleID)
        {
            Role model = new Role();

            using (EmpDbContext db = new EmpDbContext())
            {
                Role rolelist = db.Roles.SingleOrDefault(x => x.Roleid == RoleID);
                rolelist.Checkstatus = "N";
                db.SaveChanges();
            }
            return(RedirectToAction("Roles", "Utility"));
        }
        public ActionResult DeleteTech(int TechId)
        {
            Technologies model = new Technologies();

            using (EmpDbContext Techdb = new EmpDbContext())
            {
                Technologies techlist = Techdb.Technologies.SingleOrDefault(x => x.TechId == TechId);
                techlist.Checkstatus = "N";
                Techdb.SaveChanges();
            }
            return(RedirectToAction("Index", "Technology"));
        }
Exemplo n.º 13
0
 public ActionResult PrintDetails(int id)
 {
     using (EmpDbContext empDb = new EmpDbContext())
     {
         //var result = (from s in empDb.Employees where s.EmployeeId == id select s).FirstOrDefault();
         var result = empDb.Employees.Where(x => x.EmployeeId == id).ToList();
         if (result != null)
         {
             return(PartialView("_Printpdf", result));
         }
         return(null);
     }
 }
Exemplo n.º 14
0
 public ActionResult Contact()
 {
     if (Session["EmpName"] != null)
     {
         ViewBag.Message = "Your contact page.";
         var employees = new EmpDbContext();
         return(View(employees.Employees.ToList()));
     }
     else
     {
         return(RedirectToAction("Index"));
     }
 }
 public ActionResult Roles()
 {
     if (Session["EmpName"] != null)
     {
         var db = new EmpDbContext();
         ViewBag.Roles = db.Roles.Where(x => x.Checkstatus == "Y").ToList();
         return(View());
     }
     else
     {
         return(RedirectToAction("Index", "Home"));
     }
 }
 // GET: Technology
 public ActionResult Index()
 {
     if (Session["EmpName"] != null)
     {
         var tech = new EmpDbContext();
         ViewBag.listcount = Convert.ToInt32(tech.Technologies.Where(x => x.Checkstatus == "Y").ToList().Count());
         ViewBag.tech      = tech.Technologies.Where(x => x.Checkstatus == "Y").ToList();
         return(View());
     }
     else
     {
         return(RedirectToAction("Index", "Home"));
     }
 }
Exemplo n.º 17
0
        public ActionResult Register(User user)
        {
            if (ModelState.IsValid)
            {
                try
                {
                    using (EmpDbContext db = new EmpDbContext())
                    {
                        var chkUser = (from s in db.Users where s.UserName == user.UserName || s.Email == user.Email select s).FirstOrDefault();
                        if (chkUser == null)
                        {
                            var keyNew   = Helper.GeneratePassword(10);
                            var password = Helper.EncodePassword(user.Password, keyNew);
                            user.Password = password;
                            //user.Checkstatus = "Y";
                            user.Vcode = keyNew;
                            db.Users.Add(user);
                            db.SaveChanges();
                            ModelState.Clear();
                            ViewBag.Message = "Registration Successful";

                            //var emailpassword = "******";
                            //var sub = "Sample application Registration";
                            //var body = "You have been succesfully registered in Sample application";


                            //RegEmail(user.Email, sub, body, emailpassword);

                            return(RedirectToAction("Index", "Home"));
                        }
                        var p = new User();
                        p.RoleList      = db.Roles.ToList();
                        ViewBag.Message = "User Already Exists!";
                        return(View(p));
                    }
                }
                catch (Exception e)
                {
                    logger.ErrorException("Error occured in registration", e);
                    ViewBag.Message = "Some exception occured" + e;
                    return(RedirectToAction("Register"));
                }
            }
            else
            {
                ViewBag.Message = "Registration Failed";
                return(RedirectToAction("Register"));
            }
        }
        public void ActivateSiteSetting(int SiteID)
        {
            using (EmpDbContext db = new EmpDbContext())
            {
                SiteSettings Inactivate = db.siteSettings.Where(x => x.IsActive == true).FirstOrDefault();
                if (Inactivate != null)
                {
                    Inactivate.IsActive = false;
                }

                SiteSettings sitelist = db.siteSettings.SingleOrDefault(x => x.SettingsID == SiteID);
                sitelist.IsActive = true;
                db.SaveChanges();
            }
        }
 public ActionResult Create(int id)
 {
     if (Session["EmpName"] != null)
     {
         using (EmpDbContext db = new EmpDbContext())
         {
             var x = db.FileUploads.Where(a => a.Checkstatus == "Y");
             return(View());
         }
     }
     else
     {
         return(RedirectToAction("Index", "Home"));
     }
 }
        public ActionResult AddEditRole(int RoleID)
        {
            Role model = new Role();

            using (EmpDbContext db = new EmpDbContext())
            {
                if (RoleID > 0)
                {
                    var rolelist = db.Roles.SingleOrDefault(x => x.Roleid == RoleID);
                    model.Roleid   = rolelist.Roleid;
                    model.RoleName = rolelist.RoleName;
                }
            }
            return(PartialView("_AddEditRole", model));
        }
        public ActionResult AddEditTechnology(Technologies technologies)
        {
            if (Session["EmpName"] != null)
            {
                if (ModelState.IsValid)
                {
                    try
                    {
                        using (EmpDbContext Techdb = new EmpDbContext())
                        {
                            if (technologies.TechId > 0)
                            {
                                //update
                                Technologies techlist = Techdb.Technologies.SingleOrDefault(x => x.TechId == technologies.TechId);
                                techlist.Technology  = technologies.Technology;
                                techlist.Description = technologies.Description;
                                Techdb.SaveChanges();
                            }
                            else
                            {
                                //Insert
                                //Technologies techins = new Technologies();
                                //techins.Technology = technologies.Technology;
                                //techins.Description = technologies.Description;
                                technologies.Checkstatus = "Y";
                                Techdb.Technologies.Add(technologies);
                                Techdb.SaveChanges();
                            }
                        }
                        ModelState.Clear();
                        return(RedirectToAction("Index", technologies));
                    }



                    catch (Exception ex)
                    {
                        return(View("Error", new HandleErrorInfo(ex, "Technology", "Index")));
                    }
                }

                return(RedirectToAction("AddEditTechnology", technologies.TechId));
            }
            else
            {
                return(RedirectToAction("Index", "Home"));
            }
        }
 public ActionResult Index()
 {
     if (Session["EmpName"] != null)
     {
         using (EmpDbContext db = new EmpDbContext())
         {
             ViewBag.tech = db.FileUploads.Where(x => x.Checkstatus == "Y").ToList();
             //var x = db.FileUploads.ToList();
             return(View());
         }
     }
     else
     {
         return(RedirectToAction("Index", "Home"));
     }
 }
        public ActionResult AddEditTechnology(int TechID)
        {
            Technologies model = new Technologies();

            using (EmpDbContext Techdb = new EmpDbContext())
            {
                if (TechID > 0)
                {
                    Technologies techlist = Techdb.Technologies.SingleOrDefault(x => x.TechId == TechID);
                    model.TechId      = techlist.TechId;
                    model.Technology  = techlist.Technology;
                    model.Description = techlist.Description;
                }
            }
            return(PartialView("_Create", model));
        }
Exemplo n.º 24
0
 public ActionResult EmpDelete(int id)
 {
     if (Session["EmpName"] != null)
     {
         using (EmpDbContext empDb = new EmpDbContext())
         {
             var result = (from s in empDb.Employees where s.EmployeeId == id select s).FirstOrDefault();
             empDb.Employees.Remove(result);
             empDb.SaveChanges();
         }
         return(RedirectToAction("Contact"));
     }
     else
     {
         return(RedirectToAction("Index"));
     }
 }
        public ActionResult SiteSetting()
        {
            if (Session["EmpName"] != null)
            {
                using (EmpDbContext db = new EmpDbContext())
                {
                    ViewBag.SettingsList = db.siteSettings.Where(x => x.Checkstatus == "Y").ToList();
                    ViewBag.ListCount    = (from row in db.siteSettings
                                            where row.Checkstatus == "Y"
                                            select row).Count();

                    return(View());
                }
            }
            else
            {
                return(RedirectToAction("Index", "Home"));
            }
        }
        public ActionResult AddEditRole(Role role)
        {
            if (Session["EmpName"] != null)
            {
                if (ModelState.IsValid)
                {
                    try
                    {
                        using (EmpDbContext db = new EmpDbContext())
                        {
                            if (role.Roleid > 0)
                            {
                                //update
                                Role rolelist = db.Roles.SingleOrDefault(x => x.Roleid == role.Roleid);
                                rolelist.RoleName = role.RoleName;
                                db.SaveChanges();
                            }
                            else
                            {
                                //Insert

                                role.Checkstatus = "Y";
                                db.Roles.Add(role);
                                db.SaveChanges();
                            }
                        }
                        ModelState.Clear();
                        return(RedirectToAction("Roles", "Utility"));
                    }
                    catch (Exception ex)
                    {
                        //return View("Error", new HandleErrorInfo(ex, "Utility", "Roles"));
                    }
                }
                return(RedirectToAction("AddEditRole", role.Roleid));
            }
            else
            {
                return(RedirectToAction("Index", "Home"));
            }
        }
Exemplo n.º 27
0
 public ActionResult AddEmp(Employee employee)
 {
     if (Session["EmpName"] != null)
     {
         try
         {
             if (ModelState.IsValid)
             {
                 using (EmpDbContext empDb = new EmpDbContext())
                 {
                     using (DbContextTransaction transaction = empDb.Database.BeginTransaction())
                     {
                         try
                         {
                             empDb.Employees.Add(employee);
                             empDb.SaveChanges();
                             transaction.Commit();
                         }
                         catch (Exception ex)
                         {
                             transaction.Rollback();
                             Console.WriteLine("Error occurred.");
                         }
                     }
                 }
                 ModelState.Clear();
                 return(RedirectToAction("Contact"));
             }
             return(View());
         }
         catch (Exception ex)
         {
             return(View("Error", new HandleErrorInfo(ex, "EmployeeInfo", "Create")));
         }
     }
     else
     {
         return(RedirectToAction("Index"));
     }
 }
Exemplo n.º 28
0
        public ActionResult EditEmp(Employee employee)
        {
            if (Session["EmpName"] != null)
            {
                try
                {
                    using (EmpDbContext empDb = new EmpDbContext())
                    {
                        var data = (from a in empDb.Employees
                                    where a.EmployeeId == employee.EmployeeId
                                    select a).FirstOrDefault();

                        data.Company           = employee.Company;
                        data.CountryId         = employee.CountryId;
                        data.StateId           = employee.StateId;
                        data.Description       = employee.Description;
                        data.IsEmployeeRetired = employee.IsEmployeeRetired;
                        data.Name     = employee.Name;
                        data.EmpDate  = employee.EmpDate;
                        data.IsActive = employee.IsActive;

                        empDb.Entry(data).State = EntityState.Modified;

                        empDb.SaveChanges();
                    }
                    return(RedirectToAction("Contact"));
                }
                catch (Exception ex)
                {
                    return(View("Error", new HandleErrorInfo(ex, "EmployeeInfo", "Create")));
                }
                // return RedirectToAction("EditEmp");
            }
            else
            {
                return(RedirectToAction("Index"));
            }
        }
        public ActionResult MenuManagement(FormCollection collection)
        {
            if (Session["EmpName"] != null)
            {
                using (EmpDbContext db = new EmpDbContext())
                {
                    var           menulist = db.MenuManagement.Where(x => x.Checkstatus == "Y").Select(p => p.Menu_NAME).ToList();
                    List <int>    applist  = new List <int>();
                    StringBuilder sb       = new StringBuilder();
                    // sb.Append("0");
                    foreach (var item in menulist)
                    {
                        if (!string.IsNullOrEmpty(collection[item]))
                        {
                            var checkResp = collection[item].Split(',')[0];

                            if (checkResp != "false")
                            {
                                //sb.Append(", " + int.Parse(checkResp));
                                sb.Append(int.Parse(checkResp) + " ,");
                            }
                        }
                    }
                    var rid     = int.Parse(collection["hdnroleid"]);
                    var menures = sb.ToString();
                    var result  = (from s in db.Roles where s.Roleid == rid select s).FirstOrDefault();
                    result.Menu_display = menures.Remove(menures.Length - 1);
                    db.SaveChanges();
                }

                return(RedirectToAction("Roles"));
            }
            else
            {
                return(RedirectToAction("Index", "Home"));
            }
        }
        public JsonResult Create(FileUpload img, HttpPostedFileBase ImageFile)
        {
            EmpDbContext db      = new EmpDbContext();
            int          imageId = 0;

            var file = ImageFile;

            //byte[] imagebyte = null;

            if (file != null)
            {
                string filename = Path.GetFileName(file.FileName);
                file.SaveAs(Server.MapPath("/Assets/" + filename));

                //BinaryReader reader = new BinaryReader(file.InputStream);
                Stream       stream       = file.InputStream;
                BinaryReader binaryReader = new BinaryReader(stream);


                Byte[] image = binaryReader.ReadBytes((int)stream.Length);
                //imagebyte = reader.ReadBytes(file.ContentLength);

                FileUpload fimg = new FileUpload
                {
                    FileName    = filename,
                    Imagelength = image,
                    ImagePath   = "/Assets/" + filename,
                    Checkstatus = "Y"
                };
                db.FileUploads.Add(fimg);
                db.SaveChanges();

                imageId = fimg.ImageId;
            }

            return(Json(imageId, JsonRequestBehavior.AllowGet));
        }