Ejemplo n.º 1
0
        public ActionResult Create(tblEmployeeDetail employeeDetail, HttpPostedFileBase FileUpload)
        {
            using (BusManagementContext db = new BusManagementContext())
            {
                try
                {
                    //Save image in folder

                    string FileName     = Path.GetFileName(FileUpload.FileName);
                    string SaveLocation = Server.MapPath("~/EmployeePicture/" + FileName);
                    FileUpload.SaveAs(SaveLocation);

                    //save image name in database

                    employeeDetail.employeeImage = "~/EmployeePicture/" + FileName;


                    // byte image Save


                    employeeDetail.employeePicture = new byte[FileUpload.ContentLength];
                    ViewBag.TeacherPicture         = FileUpload.InputStream.Read(employeeDetail.employeePicture, 0, FileUpload.ContentLength);

                    db.tblEmployeeDetails.Add(employeeDetail);
                    db.SaveChanges();

                    return(RedirectToAction("Index"));
                }
                catch
                {
                    return(View());
                }
            }
        }
Ejemplo n.º 2
0
        public void UpdateEmployeeDetails(Employee employee)
        {
            tblEmployeeDetail objTblEmployeeDetail = new tblEmployeeDetail();

            objTblEmployeeDetail = entities.tblEmployeeDetails.ToList().Find(objTblEmployee => objTblEmployee.EmployeeDetailsID == employee.EmployeeID);
            UpdateEmployee(objTblEmployeeDetail, employee);
        }
Ejemplo n.º 3
0
        public bool AddNewEmployee(Employee objEmployee, bool IsPermanent)
        {
            tblEmployeeDetail objTblEmployeeDetail = new tblEmployeeDetail();

            try
            {
                objTblEmployeeDetail.FirstName = objEmployee.FirstName;
                objTblEmployeeDetail.LastName  = objEmployee.LastName;
                objTblEmployeeDetail.Email     = objEmployee.Email;
                objTblEmployeeDetail.Mobile    = objEmployee.Mobile;
                objTblEmployeeDetail.Phone     = objEmployee.Phone;

                // tblAddress bb = bb.tblEmployeeDetails..FirstOrDefault();

                objTblEmployeeDetail.tblAddress = ConvertAddress(objEmployee.CommunicationAddress);

                if (!IsPermanent)
                {
                    objTblEmployeeDetail.tblAddress1 = ConvertAddress(objEmployee.PermanentAddress);
                }
                else
                {
                    //objTblEmployeeDetail.tblAddress1 = ConvertAddress(objEmployee.CommunicationAddress);
                    objTblEmployeeDetail.ISPermanentCommunicationSame = true;
                }

                entities.tblEmployeeDetails.Add(objTblEmployeeDetail);
                entities.SaveChanges();
            }
            catch (Exception e)
            {
                IsSuccess = false;
            }
            return(IsSuccess);
        }
Ejemplo n.º 4
0
        public Employee FetchEmployeeDetails(int EmployeeID)
        {
            tblEmployeeDetail objTblEmployeeDetail = new tblEmployeeDetail();

            objTblEmployeeDetail = entities.tblEmployeeDetails.ToList().Find(objTblEmployee => objTblEmployee.EmployeeDetailsID == EmployeeID);

            return(objEmployee = ConvertTblEmployee(objTblEmployeeDetail));
        }
Ejemplo n.º 5
0
        public tblEmployeeDetail AddempDetail(int empid, Nullable <DateTime> joiningdate, decimal salary)
        {
            var adddetail = new tblEmployeeDetail()
            {
                EmployeeId     = empid,
                EmployeeStatus = "Active",
                Dateofjoining  = joiningdate,
                IsSalaryset    = true,
                EmployeeSalary = salary,
            };

            return(adddetail);
        }
Ejemplo n.º 6
0
        // GET: Employees/Create
        public ActionResult Create()
        {
            using (BusManagementContext db = new BusManagementContext())
            {
                tblEmployeeDetail t = new tblEmployeeDetail();


                ViewBag.DepartmentDropdown   = db.tblDepartments.ToList();
                ViewBag.DesignationsDropdown = db.tblDesignations.ToList();
                ViewBag.GenderDropdown       = db.tblGenders.ToList();

                return(View(t));
            }
        }
Ejemplo n.º 7
0
 // GET: Employees/Details/5
 public ActionResult Details(int?id)
 {
     using (BusManagementContext db = new BusManagementContext())
     {
         if (id == null)
         {
             return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
         }
         tblEmployeeDetail emp = db.tblEmployeeDetails.Find(id);
         if (emp == null)
         {
             return(HttpNotFound());
         }
         return(View(emp));
     }
 }
Ejemplo n.º 8
0
 public ActionResult Delete(int id)
 {
     using (BusManagementContext db = new BusManagementContext())
     {
         try
         {
             tblEmployeeDetail emp = db.tblEmployeeDetails.Find(id);
             db.tblEmployeeDetails.Remove(emp);
             db.SaveChanges();
             return(RedirectToAction("Index"));
         }
         catch
         {
             return(View());
         }
     }
 }
Ejemplo n.º 9
0
        public ActionResult EmployeeMaster(EmployeeMasters objMaster)
        {
            tblEmployeeDetail master = new tblEmployeeDetail();

            master.EmpName          = objMaster.EmpName;
            master.EmpCode          = objMaster.EmpCode;
            master.EmpDesignationID = objMaster.EmpDesignationID;
            master.EmpDept          = objMaster.EmpDept;
            master.PhoneNo          = objMaster.PhoneNo;
            master.CreatedDate      = Convert.ToDateTime(System.DateTime.Now.ToString("dd-MM-yyyy hh:mm"));
            master.ModifiedDate     = Convert.ToDateTime(System.DateTime.Now.ToString("dd-MM-yyyy hh:mm"));
            master.IsActive         = true;
            objAdminEnti.tblEmployeeDetails.Add(master);
            objAdminEnti.SaveChanges();
            TempData["Success"] = "Employee added successfully.";
            return(RedirectToAction("EmployeeMaster"));

            // return View();
        }
Ejemplo n.º 10
0
        public void UpdateEmployee(tblEmployeeDetail objTblEmp, Employee objEmployee)
        {
            objTblEmp.FirstName = objEmployee.FirstName;
            objTblEmp.LastName  = objEmployee.LastName;
            objTblEmp.Email     = objEmployee.Email;
            objTblEmp.Mobile    = objEmployee.Mobile;
            objTblEmp.Phone     = objEmployee.Phone;

            tblAddress objAddress    = ConvertAddress(objEmployee.CommunicationAddress);
            tblAddress objTblAddress = entities.tblAddresses.Find(objAddress.AddressID);

            objTblAddress.Address1 = objAddress.Address1;
            objTblAddress.Address2 = objAddress.Address2;
            objTblAddress.Address3 = objAddress.Address3;

            objTblAddress.StateID    = objAddress.StateID;
            objTblAddress.DistrictID = objAddress.DistrictID;
            objTblAddress.CityID     = objAddress.CityID;
            objTblAddress.Pincode    = objAddress.Pincode;


            objTblEmp.CommunicationAddressID = objAddress.AddressID;


            tblAddress objAddress1    = ConvertAddress(objEmployee.PermanentAddress);
            tblAddress objTblAddress1 = entities.tblAddresses.Find(objAddress1.AddressID);

            objTblAddress1.Address1 = objAddress1.Address1;
            objTblAddress1.Address2 = objAddress1.Address2;
            objTblAddress1.Address3 = objAddress1.Address3;

            objTblAddress1.StateID    = objAddress1.StateID;
            objTblAddress1.DistrictID = objAddress1.DistrictID;
            objTblAddress1.CityID     = objAddress1.CityID;
            objTblAddress1.Pincode    = objAddress1.Pincode;

            objTblEmp.PermanentAddressID = objTblAddress1.AddressID;

            //objTblEmp.tblAddress1 = ConvertAddress(objEmployee.PermanentAddress);

            entities.SaveChanges();
        }
Ejemplo n.º 11
0
        // GET: Employees/Edit/5
        public ActionResult Edit(int?id)
        {
            using (BusManagementContext db = new BusManagementContext())
            {
                ViewBag.DepartmentDropdown   = db.tblDepartments.ToList();
                ViewBag.DesignationsDropdown = db.tblDesignations.ToList();
                ViewBag.GenderDropdown       = db.tblGenders.ToList();


                if (id == null)
                {
                    return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
                }
                tblEmployeeDetail emp = db.tblEmployeeDetails.Find(id);
                if (emp == null)
                {
                    return(HttpNotFound());
                }
                return(View(emp));
            }
        }
Ejemplo n.º 12
0
        public Employee ConvertTblEmployee(tblEmployeeDetail objTblEmployee)
        {
            objEmployee.EmployeeID = objTblEmployee.EmployeeDetailsID;
            objEmployee.FirstName  = objTblEmployee.FirstName;
            objEmployee.LastName   = objTblEmployee.LastName;
            objEmployee.Email      = objTblEmployee.Email;
            objEmployee.Mobile     = objTblEmployee.Mobile;
            objEmployee.Phone      = objTblEmployee.Phone;

            objEmployee.CommunicationAddress = ConvertTblAddress(objTblEmployee.tblAddress);

            if (!objTblEmployee.ISPermanentCommunicationSame)
            {
                objEmployee.PermanentAddress = ConvertTblAddress(objTblEmployee.tblAddress1);
            }
            else
            {
                objEmployee.PermanentAddress = ConvertTblAddress(objTblEmployee.tblAddress);
            }

            return(objEmployee);
        }
Ejemplo n.º 13
0
 public void Addempdetail(tblEmployeeDetail obj)
 {
     context.tblEmployeeDetails.Add(obj);
 }
Ejemplo n.º 14
0
 public ActionResult Edit(tblEmployeeDetail objEmployeeDetail)
 {
     return(View());
 }
Ejemplo n.º 15
0
        public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
        {
            //context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" });

            var emailId = AESEncrytDecry.DecryptStringAES(context.UserName);

            var password = AESEncrytDecry.DecryptStringAES(context.Password);
            tblEmployeeDetail    userData   = null;
            tblEmployeeJobDetail jobDeatils = null;
            var data = context.OwinContext.Get <ICONHRContext>();

            try
            {
                userData   = data.EmployeeDetails.FirstOrDefault(x => x.EmailID == emailId);
                jobDeatils = data.EmployeeJobDetails.FirstOrDefault(x => x.EmpID == userData.EmpID);
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                throw;
            }


            if (userData == null)
            {
                context.SetError("invalid_grant", "The user name or password is incorrect.");
                return;
            }
            //  bool isMatchPassword = PasswordHash.ValidatePassword(password, "1000:" + Convert.ToString(userData.PasswordSalt) + ":" + Convert.ToString(userData.PasswordHash));

            if (userData.PasswordSalt != context.Password)
            {
                context.SetError("invalid_grant", "The user name or password is incorrect.");
                // return;
            }

            // string imgData = Base64EncodeBytes(userData.ProfilePhoto);
            string profilePhoto = string.Empty;

            if (userData.ProfilePhoto != null)
            {
                profilePhoto = Convert.ToBase64String(userData.ProfilePhoto);
            }

            var companyDetail = data.CompanyDetails.Where(x => x.CompanyID == userData.CompanyID).FirstOrDefault();

            if (userData.CreatedDate.HasValue && userData.CreatedDate.Value.AddDays(30) < DateTime.Now)
            {
                if (companyDetail.IsTrailEnd && !companyDetail.IsPaid)
                {
                    //throw new Exception("Payment Redirection");
                    context.SetError("PaymentRedirection", "Payment Redirection");
                    return;
                }
            }
            else
            {
                if (companyDetail.IsTrailEnd && !companyDetail.IsPaid)
                {
                    context.SetError("PaymentRedirection", "Payment Redirection");
                    return;
                }
            }


            var claims = new List <Claim>();

            claims.Add(new Claim(ClaimTypes.Name, userData.EmpName));
            claims.Add(new Claim(ClaimTypes.Email, userData.EmailID));
            claims.Add(new Claim("UserId", userData.EmpID.ToString()));
            claims.Add(new Claim("CompanyId", userData.CompanyID.ToString()));
            if (companyDetail.CompanyName != null)
            {
                // claims.Add(new Claim("CompanyName", companyDetail.CompanyName));
            }
            claims.Add(new Claim(ClaimTypes.SerialNumber, userData.EmpID.ToString()));
            //claims.Add(new Claim("ProfilePhoto", userData.ProfilePhoto));
            // claims.Add(userData.ProfilePhoto);
            claims.Add(new Claim(ClaimTypes.Role, "Admin")); // userData.EmpRoleID TODO get roles from db
            if (jobDeatils != null)
            {
                claims.Add(new Claim("RepMgrID", jobDeatils.RepMgrID.ToString()));
                var reportMngDetails = data.EmployeeDetails.FirstOrDefault(x => x.EmpID == jobDeatils.RepMgrID);
                if (reportMngDetails != null)
                {
                    claims.Add(new Claim("RepMgrName", reportMngDetails.EmpName));
                }
                claims.Add(new Claim("DepartmentId", jobDeatils.DeptID.ToString()));
                claims.Add(new Claim("LocationId", jobDeatils.LocationID.ToString()));
            }
            // Setting Claim Identities for OAUTH 2 protocol.
            ClaimsIdentity oAuthClaimIdentity   = new ClaimsIdentity(claims, OAuthDefaults.AuthenticationType);
            ClaimsIdentity cookiesClaimIdentity = new ClaimsIdentity(claims, DefaultAuthenticationTypes.ApplicationCookie); // CookieAuthenticationDefaults.AuthenticationType match this in auth.cs(app.UseCookieAuthentication())


            AuthenticationProperties properties = CreateProperties(userData.EmpName);
            AuthenticationTicket     ticket     = new AuthenticationTicket(oAuthClaimIdentity, properties);

            context.Validated(ticket);
            context.Request.Context.Authentication.SignIn(cookiesClaimIdentity);
        }