Пример #1
0
 public EmployeeEditForm(EmployeeModel _dataModel)
 {
     InitializeComponent();
     this.dataModel = _dataModel;
     this.cbManagerID.Items.Add("");
     this.cbManagerID.Items.AddRange(dataModel.getIDItemArray("HR.Employees", 0, 1));
 }
Пример #2
0
        //TODO
        public CheckResult ValidateEmployee(SmartCRMEntitiesModel context, EmployeeModel model)
        {
            CheckResult result = CheckResult.Default;

            if (string.IsNullOrWhiteSpace(model.FirstName))
            {
                result.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, StaticReflection.GetMemberName<EmployeeModel>(x => x.FirstName), "Enter First Name!"));
            }

            if (string.IsNullOrWhiteSpace(model.LastName))
            {
                result.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, StaticReflection.GetMemberName<EmployeeModel>(x => x.LastName), "Enter Last Name!"));
            }

            //if (model.Username.Length < MinimumUsernameLength)
            //{
            //    result.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, StaticReflection.GetMemberName<UserModel>(x => x.Username), "Minimum required length of the Username is 3 symbols!"));
            //}

            //if (model.Password.Length < MinimumPasswordLength)
            //{
            //    result.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, StaticReflection.GetMemberName<UserModel>(x => x.Password), "Minimum required length of the Password is 6 symbols!"));
            //}

            return result;
        }
Пример #3
0
 public static void Map(Employee source, EmployeeModel destination)
 {
     Mapper.Map(source, destination);
     destination.Gender = (GenderType)source.Gender;
    // destination.Photo = source.Photo;
    // destination.PhotoImage = ImagesHelper.ByteArrayToImage(source.Photo);
 }
        public void CanSerializerSingleton()
        {
            // Arrange
            const string expect = "{" +
                "\"@odata.context\":\"http://localhost/odata/$metadata#Boss\"," +
                "\"@odata.id\":\"http://localhost/odata/Boss\"," +
                "\"@odata.editLink\":\"http://localhost/odata/Boss\"," +
                "\"EmployeeId\":987,\"EmployeeName\":\"John Mountain\"}";

            IEdmModel model = GetEdmModel();
            IEdmSingleton singleton = model.EntityContainer.FindSingleton("Boss");
            HttpRequestMessage request = GetRequest(model, singleton);
            ODataSerializerContext readContext = new ODataSerializerContext()
            {
                Url = new UrlHelper(request),
                Path = request.ODataProperties().Path,
                Model = model,
                NavigationSource = singleton
            };

            ODataSerializerProvider serializerProvider = new DefaultODataSerializerProvider();
            EmployeeModel boss = new EmployeeModel {EmployeeId = 987, EmployeeName = "John Mountain"};
            MemoryStream bufferedStream = new MemoryStream();

            // Act
            ODataEntityTypeSerializer serializer = new ODataEntityTypeSerializer(serializerProvider);
            serializer.WriteObject(boss, typeof(EmployeeModel), GetODataMessageWriter(model, bufferedStream), readContext);

            // Assert
            string result = Encoding.UTF8.GetString(bufferedStream.ToArray());
            Assert.Equal(expect, result);
        }
Пример #5
0
        //Method to parse the input file data into list object
        public List<EmployeeModel> ParseFileData(string FileInfo)
        {
            EmployeeModel EmpMdlObj = new EmployeeModel();
            var EmployeeModelList = new List<EmployeeModel>();

            try
            {
                var lines = File.ReadAllLines(FileInfo);
                foreach (var line in lines)
                {
                    var linedata = line.Split(',');
                    EmpMdlObj.EmployeeID = linedata[0];
                    EmpMdlObj.EmployeeName = linedata[1];
                    EmpMdlObj.EmployeeDOB = Convert.ToDateTime(linedata[2]);
                    EmpMdlObj.EmployeeCity = linedata[3];

                    EmployeeModelList.Add(EmpMdlObj);
                }

                return EmployeeModelList;
            }

            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw ex;
            }
        }
Пример #6
0
 public static int Insert(EmployeeModel model)
 {
     try
     {
         using (DataContentDataContext dc = new DataContentDataContext())
         {
             Employee emp = new Employee();
             emp.Id = model.ID;
             emp.EmployeeName = model.EmployeeName;
             emp.Username = model.Username;
             emp.Password = model.Password;
             emp.Creater = model.Creater;
             emp.CreateDate = model.CreateDate;
             emp.Modifier = model.Modifier;
             emp.ModifyDate = model.ModifyDate;
             dc.Employees.InsertOnSubmit(emp);
             dc.SubmitChanges();
         }
         return 1;
     }
     catch (Exception)
     {
         return 0;
     }
 }
 public ChatMessageModel(int id, EmployeeModel author, string message, DateTime created)
 {
     Id = id;
     Author = author;
     Message = message;
     Created = created;
 }
 public SimplifiedEmployeeViewModel(EmployeeModel employee)
 {
     Id = employee.Id;
     Name = employee.Name;
     Surname = employee.Surname;
     Position = Enum.GetName(typeof(Roles), employee.Position);
 }
Пример #9
0
        private void InsertEmployee(SmartCRMEntitiesModel db, EmployeeModel employeeModel)
        {
            Employee pocoEmployee = new Employee();
            MapHelper.Map(employeeModel, pocoEmployee);

            db.Add(pocoEmployee);
            db.FlushChanges();
            employeeModel.Id = pocoEmployee.Id;
        }
Пример #10
0
 private void InsertAccount(SmartCRMEntitiesModel db, UserModel userModel, EmployeeModel employeeModel)
 {
     User pocoUser = new User();
     MapHelper.Map(userModel, pocoUser);
     Employee pocoEmployee = new Employee();
     MapHelper.Map(employeeModel, pocoEmployee);
     pocoUser.Employee = pocoEmployee;
     db.Add(pocoUser);
 }
Пример #11
0
        private void UpdateEmployee(SmartCRMEntitiesModel db, EmployeeModel employeeModel)
        {
            var pocoEmployee = db.Employees.FirstOrDefault(x => x.Id.Equals(employeeModel.Id));
            if (pocoEmployee == null)
            {
                throw new NullReferenceException("Missing employee!");
            }

            MapHelper.Map(employeeModel, pocoEmployee);
        }
Пример #12
0
 public void SaveAccount(SmartCRMEntitiesModel db, UserModel userModel, EmployeeModel employeeModel)
 {
     if (userModel.IsNew)
     {
         this.InsertAccount(db, userModel, employeeModel);
     }
     else
     {
         this.UpdateAccount(db, userModel, employeeModel);
     }
 }
        public static ChatRoomModel CreateChat(EmployeeModel with)
        {
            using (var connection = new MySqlConnection(Settings.Default.ConnectionString))
            {
                connection.Open();
                //New Chatroom
                var query = "INSERT INTO ChatRoom VALUES(null, @topic)";
                MySqlCommand cmd = new MySqlCommand(query, connection);
                cmd.Parameters.Add(new MySqlParameter("@topic", MySqlDbType.String));
                cmd.Prepare();

                cmd.Parameters["@topic"].Value = $"Chat between {EmployeeModel.CurrentEmployee.Name} and {with.Name}";

                cmd.ExecuteNonQuery();

                //Get Chatroom-ID
                query = "SELECT LAST_INSERT_ID() as Id";
                cmd = new MySqlCommand(query, connection);

                var reader = cmd.ExecuteReader();
                int chatId = 0;

                if (reader.Read())
                {
                    chatId = reader.GetInt32("Id");
                }

                reader.Close();

                //New ChatMember
                cmd.CommandText = "INSERT INTO ChatMember VALUES(null, @member, @chatroom)";
                cmd.Parameters.Add(new MySqlParameter("@member", MySqlDbType.Int32));
                cmd.Parameters.Add(new MySqlParameter("@chatroom", MySqlDbType.Int32));
                cmd.Prepare();

                cmd.Parameters["@chatroom"].Value = chatId;

                //Add me
                cmd.Parameters["@member"].Value = EmployeeModel.CurrentEmployee.Id;
                cmd.ExecuteNonQuery();

                //Add with
                cmd.Parameters["@member"].Value = with.Id;
                cmd.ExecuteNonQuery();

                var newChatModel = new ChatRoomModel
                {
                    Id = chatId
                };
                newChatModel.Load();

                return newChatModel;
            }
        }
Пример #14
0
 public void SaveEmployee(SmartCRMEntitiesModel db, EmployeeModel employeeModel)
 {
     if (employeeModel.Id == 0)
     {
         this.InsertEmployee(db, employeeModel);
     }
     else
     {
         this.UpdateEmployee(db, employeeModel);
     }
 }
Пример #15
0
        private void UpdateAccount(SmartCRMEntitiesModel db, UserModel userModel, EmployeeModel employeeModel)
        {
            var pocoUser = db.Users.FirstOrDefault(x => x.UserId.Equals(userModel.UserId));
            if (pocoUser == null)
            {
                throw new NullReferenceException("Missing user!");
            }

            MapHelper.Map(userModel, pocoUser);
            MapHelper.Map(employeeModel, pocoUser.Employee);
        }
Пример #16
0
 public static EmployeeModel SelectOne(EmployeeModel model)
 {
     try
     {
         using (DataContentDataContext dc = new DataContentDataContext())
         {
             Employee item = dc.Employees.Where(a => a.Id == model.ID).SingleOrDefault();
             return new EmployeeModel(item.Id, item.EmployeeName, item.RoleId.ToString(), item.Username, item.Password, item.Creater, item.CreateDate, item.Modifier, item.ModifyDate);
         }
     }
     catch (Exception)
     {
         return new EmployeeModel();
     }
 }
        public void AddUser(EmployeeModel user)
        {
            using (var connection = new MySqlConnection(Settings.Default.ConnectionString))
            {
                connection.Open();
                var query = "INSERT INTO ChatMember VALUES(null, @member, @chatroom)";
                MySqlCommand cmd = new MySqlCommand(query, connection);
                cmd.Parameters.Add(new MySqlParameter("@member", MySqlDbType.Int32));
                cmd.Parameters.Add(new MySqlParameter("@chatroom", MySqlDbType.Int32));
                cmd.Prepare();

                cmd.Parameters["@chatroom"].Value = Chat.Id;
                cmd.Parameters["@member"].Value = user.Id;
                cmd.ExecuteNonQuery();
                Chat.Load();
            }
        }
Пример #18
0
        public CheckResult DeleteEmployee(EmployeeModel focusedUser)
        {
            CheckResult check = CheckResult.Default;
            //using (var db = DbManager.CreateInstance())
            //{
            //    try
            //    {
            //        UserRepository rep = new UserRepository();
            //        rep.DeleteUser(db, focusedUser);
            //        db.SaveChanges();
            //        this.Users.Remove(focusedUser);
            //    }
            //    catch (Exception ex)
            //    {
            //        check.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, "InvalidDeletion", "Cannot delete this user!"));
            //        return check;
            //    }

            //    return check;
            //}
            return check;
        }
Пример #19
0
 public bool checkEmployee(string strWhere)
 {
     this.em = new EmployeeDal();
     this.dbo = new DB_OPT();
     return (this.em.GetList(strWhere, this.dbo).Tables[0].Rows.Count > 0);
 }
Пример #20
0
 public void Update(EmployeeModel modelEmployee)
 {
     _employeesRepository.Update(modelEmployee.ToEntity());
 }
Пример #21
0
        //
        // GET: /Employee/
        public ActionResult Index()
        {
            EmployeeModel objEmpModel = new EmployeeModel();

            return(View(objEmpModel));
        }
Пример #22
0
        public bool Create([FromBody] EmployeeModel employee)
        {
            var data = EmployeeDataAccessLayer.SaveEmployee(employee);

            return(data);
        }
Пример #23
0
 public void Set(EmployeeModel model)
 {
     _cache[model.Id] = model;
 }
Пример #24
0
 public int CreateEmployee(EmployeeModel empModel)
 {
     return(_CreateEmployeeRepository.CreateEmployee(empModel));
 }
Пример #25
0
 public void MarkAsModified(EmployeeModel item)
 {
     Entry(item).State = EntityState.Modified;
 }
Пример #26
0
        public void Init()
        {
            var employees = new List <EmployeeModel>()
            {
                new EmployeeModel
                {
                    Id              = 1,
                    Birth           = DateTime.Now.AddYears(-10),
                    FirstName       = "John",
                    LastName        = "Doe",
                    Salary          = 1000,
                    TaxNumber       = "1234",
                    WorkingPosition = "Developer"
                },
                new EmployeeModel
                {
                    Id              = 2,
                    Birth           = DateTime.Now.AddYears(-20),
                    FirstName       = "Edward",
                    LastName        = "Kovalsky",
                    Salary          = 2000,
                    TaxNumber       = "0987",
                    WorkingPosition = "CEO"
                }
            };

            var pagedList = new PagedDataList <EmployeeModel>(employees, 0, 0, 0);

            var employeesForList = new List <EmployeeForListDto>()
            {
                new EmployeeForListDto
                {
                    Id              = 1,
                    Age             = 10,
                    FirstName       = "John",
                    LastName        = "Doe",
                    Salary          = 1000,
                    TaxNumber       = "1234",
                    WorkingPosition = "Developer"
                },
                new EmployeeForListDto
                {
                    Id              = 2,
                    Age             = 20,
                    FirstName       = "Edward",
                    LastName        = "Kovalsky",
                    Salary          = 2000,
                    TaxNumber       = "0987",
                    WorkingPosition = "CEO"
                }
            };

            var employee = new EmployeeModel
            {
                Id              = 1,
                Birth           = DateTime.Now.AddYears(-10),
                FirstName       = "John",
                LastName        = "Doe",
                Salary          = 1000,
                TaxNumber       = "1234",
                WorkingPosition = "Developer"
            };

            var employeeForList = new EmployeeForListDto
            {
                Id              = 1,
                Age             = 10,
                FirstName       = "John",
                LastName        = "Doe",
                Salary          = 1000,
                TaxNumber       = "1234",
                WorkingPosition = "Developer"
            };

            var eRMock = new Mock <IEmployeesRepository>(MockBehavior.Strict);

            eRMock.Setup(m => m.Get(null)).Returns(Task.FromResult(pagedList));

            eRMock.Setup(m => m.Get(1)).Returns(Task.FromResult(employee));

            eRMock.Setup(m => m.Save()).Returns(Task.FromResult(true));

            eRMock.Setup(m => m.Update(It.IsAny <EmployeeModel>(), It.IsAny <EmployeeModel>()));

            eRMock.Setup(m => m.Add(It.IsAny <EmployeeModel>()));

            eRMock.Setup(m => m.Delete(It.IsAny <EmployeeModel>()));

            var mapMock = new Mock <IMapper>(MockBehavior.Strict);

            mapMock.Setup(m => m.Map <IEnumerable <EmployeeForListDto> >(It.IsAny <EmployeeModel>())).Returns(employeesForList);
            mapMock.Setup(m => m.Map <EmployeeForListDto>(It.IsAny <EmployeeModel>())).Returns(employeeForList);
            mapMock.Setup(m => m.Map <IEnumerable <EmployeeForListDto> >(It.IsAny <PagedDataList <EmployeeModel> >())).Returns(employeesForList);

            this.employeesRepository = eRMock;
            this.mapper = mapMock;
        }
Пример #27
0
        public async Task <IHttpActionResult> GetEmployee(int EmpId)
        {
            try
            {
                using (MaxMasterDbEntities db = new MaxMasterDbEntities())
                {
                    Employee emp = await db.Employees.FindAsync(EmpId);

                    var employee = new EmployeeModel();

                    employee.FirstName         = emp.FirstName;
                    employee.MiddleName        = emp.MiddleName;
                    employee.LastName          = emp.LastName;
                    employee.Email             = emp.Email;
                    employee.PrimaryPhoneNum   = emp.PrimaryPhone;
                    employee.SecondaryPhoneNum = emp.SecondaryPhone;
                    employee.Gender            = emp.Gender;
                    employee.BloodGroup        = emp.BloodGroup;
                    employee.Aadhar            = emp.Aadhar;
                    employee.Pan          = emp.PAN;
                    employee.AddressLine1 = emp.AddressLine1;
                    employee.AddressLine2 = emp.AddressLine2;

                    if (emp.City_Id != 0)
                    {
                        employee.CityId      = emp.City_Id;
                        employee.CityName    = emp.City.Name;
                        employee.StateId     = emp.City.State_Id;
                        employee.StateName   = emp.City.State.Name;
                        employee.Country     = emp.City.State.Country_Id;
                        employee.CountryName = emp.City.State.Country.Name;
                    }

                    if (emp.Shift_Id != null)
                    {
                        employee.ShiftId      = emp.Shift_Id;
                        employee.ShiftTimings = (emp.Shift.InTime).ToString(@"hh\:mm") + "-" + (emp.Shift.OutTime).ToString(@"hh\:mm");
                    }

                    employee.DOB            = emp.DOB.ToString("yyyy-MM-dd");
                    employee.DOJ            = emp.DOJ.ToString("yyyy-MM-dd");
                    employee.ZIP            = emp.ZIP;
                    employee.EmploymentType = emp.EmploymentType;
                    employee.DesgId         = emp.Designation_Id;
                    employee.DesgName       = emp.Designation.Name;
                    employee.DeptId         = emp.Department_Id;
                    employee.DeptName       = emp.Department.Name;
                    employee.RoleId         = emp.Role_Id;
                    employee.RoleName       = emp.AspNetRole.Name;
                    employee.OrgId          = emp.OrgId;
                    employee.OrgName        = emp.Organisation.OrgName;
                    employee.PhotoUrl       = emp.PhotoURL;

                    var manager = emp.Manager_Id;
                    if (manager != null)
                    {
                        employee.ManagerId   = emp.Manager_Id;
                        employee.ManagerName = db.Employees.Where(x => x.Id == emp.Manager_Id).Select(x => x.FirstName + " " + x.LastName).FirstOrDefault();
                    }

                    employee.ProvisionalPeriod = emp.ProvisionalPeriod;

                    return(Content(HttpStatusCode.OK, new { employee }));
                }
            }
            catch (Exception ex)
            {
                new Error().logAPIError(System.Reflection.MethodBase.GetCurrentMethod().Name, ex.ToString(), ex.StackTrace);
                return(Content(HttpStatusCode.InternalServerError, "An error occured , please try again later"));
            }
        }
Пример #28
0
        public async Task UpdateProfile(ProfileEditViewModel model)
        {
            if (model.EmployeeImage != null)
            {
                var employeeImage = new EmployeeImageModel
                {
                    ImageId    = model.ImageId,
                    EmployeeId = model.EmployeeId,
                };

                using (var memoryStream = new MemoryStream())
                {
                    await model.EmployeeImage.CopyToAsync(memoryStream);

                    employeeImage.Images = memoryStream.ToArray();
                }

                var existingImage = await _employeeImageService.ExistsAsync(model.EmployeeId);

                if (existingImage)
                {
                    await _employeeImageService.UpdateAsync(employeeImage);
                }
                else
                {
                    await _employeeImageService.AddAsync(employeeImage);
                }
            }

            // update employee
            var employee = new EmployeeModel
            {
                EmployeeId    = model.EmployeeId,
                GlobalId      = model.GlobalId,
                CardId        = model.CardId,
                Title         = model.Title,
                TitleThai     = model.TitleThai,
                EmployeeType  = model.EmployeeType,
                FirstName     = model.FirstName,
                LastName      = model.LastName,
                FirstNameThai = model.FirstNameThai,
                LastNameThai  = model.LastNameThai,
                Gender        = model.Gender,
                BirthDate     = model.BirthDate,
                HireDate      = model.HireDate,
                AvailableFlag = true,
                ChangedDate   = DateTime.Now,
            };

            await _employeeService.UpdateAsync(employee);

            // add or update employee state
            var employeeState = new EmployeeStateModel
            {
                EmployeeId    = model.EmployeeId,
                DepartmentId  = model.DepartmentId,
                SectionId     = model.SectionId,
                ShiftId       = (byte)model.ShiftId,
                LevelId       = model.LevelId,
                PositionId    = model.JobPositionId,
                JobFunctionId = model.JobFunctionId,
                BusStationId  = model.BusStationId,
                JoinDate      = model.JoinDate,
                ChangedDate   = DateTime.Now
            };

            var existEmployeeState = await _employeeStateService.ExistsAsync(model.EmployeeId);

            if (existEmployeeState)
            {
                await _employeeStateService.UpdateAsync(employeeState);
            }
            else
            {
                await _employeeStateService.AddAsync(employeeState);
            }

            // add or update address
            var address = new EmployeeAddressModel
            {
                EmployeeAddressId = model.EmployeeAddressId,
                EmployeeId        = model.EmployeeId,
                HomeAddress       = model.HomeAddress,
                City         = model.City,
                Country      = model.Country,
                PostalCode   = model.PostalCode,
                PhoneNumber  = model.PhoneNumber,
                EmailAddress = model.EmailAddress,
                ChangedDate  = DateTime.Now
            };

            if (address.EmployeeAddressId > 0)
            {
                await _employeeAddressService.UpdateAsync(address);
            }
            else
            {
                await _employeeAddressService.AddAsync(address);
            }
        }
 public ActionResult Sample3FilterSearch(EmployeeModel objModel, int page = 1, int pageSize = 10)
 {
     BindSample3(objModel, page, pageSize);
     return(PartialView("Sample3List", objModel));
 }
Пример #30
0
        public IHttpActionResult GetAllEmployeeByCompanyId(int id)
        {
            EmployeeModel model = new EmployeeModel();

            return(Content(HttpStatusCode.OK, model.GetAllByCompanyId(id)));
        }
Пример #31
0
 public static void Map(EmployeeModel source, Employee destination)
 {
     Mapper.Map(source, destination);
     destination.Gender = (short)source.Gender;
    // destination.Photo = source.Photo; //ImagesHelper.ImageToByteArray(source.PhotoImage);
 }
Пример #32
0
 protected void loadData()
 {
     string currentFilter ;
     if (IsPostBack == false)
     {
         Session["emp_filter"] = "jobStatus=1 ";
         currentFilter = "jobStatus=1 ";
     }
     else
         currentFilter = (string)Session["emp_filter"];
     //this.scriptLb.Text = currentFilter;
     EmployeeParser newParser = new EmployeeParser();
     this.dataModel = new EmployeeModel(this.gvEmployees, @".\SQL2008",
          1433, "TSQLFundamentals2008","sa", "123456", "HR.Employees", newParser);
     newParser.DataModel = this.dataModel;
     try
     {
         this.dataModel.resetControl(currentFilter);
         if (this.IsPostBack == false)
             this.loadEmpIDS();
     }
     catch(Exception ex)
     {
         Session["current_error"] = ex.Message;
         Response.Redirect("serverError.aspx");
     }
 }
Пример #33
0
        public CheckResult DeleteEmployee(EmployeeModel focusedEmployee)
        {
            CheckResult check = CheckResult.Default;
            using (var db = DbManager.CreateInstance())
            {
                try
                {
                    EmployeeRepository rep = new EmployeeRepository();
                    rep.DeleteEmployee(db, focusedEmployee);
                    db.SaveChanges();
                    this.Employees.Remove(focusedEmployee);
                }
                catch (NullReferenceException nREx)
                {
                    //TODO Log
                    check.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, "", nREx.Message));
                    return check;
                }
                catch (DataStoreException)
                {
                    check.Details.Add(
                        new CheckResultDetail(
                            CheckResultDetail.ErrorType.Error,
                            "InvalidDeletion",
                            Messages.CannotDeleteLinkedItem));
                    return check;
                }
                catch (Exception)
                {
                    //TODO Log
                    check.Details.Add(
                        new CheckResultDetail(
                            CheckResultDetail.ErrorType.Error,
                            "InvalidDeletion",
                            "Deletion failed!"));
                    return check;
                }

                return check;
            }
        }
Пример #34
0
        static void Main(string[] args)
        {
            //string whatIdid;
            //int i;
            //double totalHours;
            //double ttl = 0;
            //double myTimeInHours;

            //List<TimeSheetEntry> ents = new List<TimeSheetEntry>();
            //TimeSheetEntry ent = new TimeSheetEntry();

            //what job do you do
            //how long do you do it for
            //check the value given by the user
            //add the data as an entry to the TimeSheetEntry

            //ask for more time - if yes repeat, - if no continue
            //check if worked for acme
            //send email to acme
            //calculate total bill for Acme
            //check if worked for ABC
            //send email to ABC
            //calculate total bill for ABC
            //calculate pay and overtime
            //end application

            //Console.Write("Enter what you did and for Acme or ABC?: ");
            //whatIdid = Console.ReadLine();


            //Console.Write("How many hours did you do it for: ");
            //string myHours = Console.ReadLine();
            //checkHoursValid(myHours);
            ////t = int.Parse(Console.ReadLine());

            //ent.WorkDone = whatIdid;
            //ent.WorkedHours = myTimeInHours;
            //ents.Add(ent);

            //Console.Write("Do you want to enter more time:");
            ////bool cont = bool.Parse(Console.ReadLine());
            //string answer = Console.ReadLine();
            //checkMoreTimeValid(answer);


            //while (cont == true)
            //{
            //    Console.Write("Enter what you did and for Acme or ABC?: ");
            //    whatIdid = Console.ReadLine();

            //    Console.Write("How many hours did you do it for: ");
            //    //t = int.Parse(Console.ReadLine());
            //    myHours = Console.ReadLine();
            //    checkHoursValid(myHours);

            //    ent = new TimeSheetEntry(); //this is a new instance, not a ref to the old one
            //    ent.WorkedHours = myTimeInHours;
            //    ent.WorkDone = whatIdid;
            //    ents.Add(ent);

            //    Console.Write("Do you want to enter more time:");
            //    //cont = bool.Parse(Console.ReadLine());
            //    answer = Console.ReadLine();
            //    checkMoreTimeValid(answer);
            //    //cont = false;
            //}


            //REFACTORED creation of new method LoadTimeSheets
            List <TimeSheetEntry> timeSheets = LoadTimeSheets();

            //pull a EmployeeModel reference to a certain employee and call if currentEmployee
            EmployeeModel currentEmployee = DataAccess.GetCurrentEmployee();

            //get me a list of customers we'll call customers of type "CustomerModel" populated by the method DataAccess.GetCustomer()
            List <CustomerModel> customers = DataAccess.GetCustomers();

            //(in one line)
            //Bill each customer in the TimeSheets and send them an email
            customers.ForEach(x => BillCustomer(timeSheets, x));

            //OR (standard way)
            //foreach(var customer in customers)
            //{
            //    //BillCustomer(timeSheets, customer.CustomerName, customer.HourlyRateToBill);
            //    //REFACTORED BillCustomer to just take in the CustomerModel so it can access those properties
            //    BillCustomer(timeSheets, customer);
            //}

            //totalHours = TimeSheetProcessing.GetHoursWorkedForCompany(timeSheets, "Acme");
            //Console.WriteLine();
            //Console.WriteLine("Simulating Sending email to Acme");
            //Console.WriteLine("Your bill is $" + totalHours * 150 + " for the hours worked.");
            //BillCustomer(timeSheets, "Acme", 150);

            //totalHours = TimeSheetProcessing.GetHoursWorkedForCompany(timeSheets, "ABC");
            //Console.WriteLine();
            //Console.WriteLine("Simulating Sending email to ABC");
            //Console.WriteLine("Your bill is $" + totalHours * 125 + " for the hours worked.");
            //BillCustomer(timeSheets, "ABC", 125);

            //totalHours = 0;
            //for (i = 0; i < timeSheets.Count; i++)
            //{
            //    totalHours += timeSheets[i].WorkedHours;
            //}

            //if (totalHours > 40)
            //{

            //    Console.WriteLine("You will get paid $" + ((40 * 10) + ((totalHours - 40) * 15)) + " for your work.");
            //}
            //else
            //{
            //    Console.WriteLine("You will get paid $" + totalHours * 10 + " for your time.");
            //}
            //Pay the employee based on the time sheet entry and the current employees pay rate
            PayEmployee(timeSheets, currentEmployee);

            Console.WriteLine();
            Console.Write("Press any key to exit application...");
            Console.ReadKey();
        }
Пример #35
0
 public static IEmployee ToEntity(this EmployeeModel source)
 {
     return(Mapper.Map <EmployeeModel, IEmployee>(source));
 }
Пример #36
0
        public void DeleteEmployee(SmartCRMEntitiesModel db, EmployeeModel employeeModel)
        {
            Employee pocoEmployee = db.Employees.FirstOrDefault(x => x.Id == employeeModel.Id);
            if (pocoEmployee == null)
            {
                throw new NullReferenceException("Missing employee in database!");
            }

            db.Delete(pocoEmployee);
        }
Пример #37
0
 public int UpdateEmployeeDetails(EmployeeModel empModel)
 {
     return(_UpdateEmployeeRepository.UpdateEmployeeDetails(empModel));
 }
Пример #38
0
 private IEmployeeModel PopulateEmployeeModelFromInterface()
 {
     var employee = new EmployeeModel
         {
             Address = address.Text,
             BankAccount = bankAccount.Text,
             BankName = bankName.Text,
             BirthDate = birthDate.Value,
             City = cityName.Text,
             CreatedBy = createdBy.Text,
             CreatedDate = createdDate.Value,
             FirstName = firstName.Text,
             Gender = gender.Text,
             HiredDate = hireDate.Value,
             Id = Convert.ToInt32(recordId.Text),
             LastName = lastName.Text,
             ModifiedBy = modifiedBy.Text,
             ModifiedDate = modifiedDate.Value,
             MaritalStatus = maritalStatus.Text,
             MiddleName = middleName.Text,
             NationalIDNumber = nationalIdNumber.Text,
             PayrollGroupCode = payrollGroupCode.Text,
             PositionName = positionName.Text,
             PostalCode = postalCode.Text,
             State = stateName.Text,
             Title = titleName.Text,
             EmployeeID = employeeId.Text
         };
     bool b;
     Boolean.TryParse(isTerminate.Text, out b);
     employee.IsTerminate = b;
     employee.TerminateDate = terminateDate.Checked ? (DateTime?)terminateDate.Value : null;
     employee.TerminateDescription = terminateDescription.Text;
     return employee;
 }
Пример #39
0
 public static void ReplaceReferences(ObservableCollection <DepartmentModel> collection, EmployeeModel selectedEmployee)
 {
     if (collection.Count > 0)
     {
         for (int i = collection.Count - 1; i >= 0; i--)
         {
             if (selectedEmployee.Department.Name == collection[i].Name && !ReferenceEquals(selectedEmployee.Department.Name, collection[i].Name))
             {
                 collection.Add(selectedEmployee.Department);
                 collection.Remove(collection[i]);
             }
         }
     }
 }
        public ActionResult AddEmployee(EmployeeModel model)
        {
            ViewBag.Class = "display-hide";
            try
            {
                if (ModelState.IsValid)
                {
                    model.CreatedBy = UserManager.user.UserId;
                    model.Archived  = "NonArchive";
                    string path = Server.MapPath("~/UploadDocuments/");
                    if (!Directory.Exists(path))
                    {
                        Directory.CreateDirectory(path);
                    }
                    if (model.ImageFile != null)
                    {
                        string Imagepath = Server.MapPath("~/Images/UserImages/");
                        if (!Directory.Exists(Imagepath))
                        {
                            Directory.CreateDirectory(Imagepath);
                        }
                        string fileName = Path.GetFileName(model.ImageFile.FileName);
                        fileName = "test" + Guid.NewGuid().ToString() + Path.GetExtension(model.ImageFile.FileName);
                        model.ImageFile.SaveAs(Imagepath + fileName);
                        model.Image     = fileName;
                        model.ImageFile = null;
                    }
                    if (model.IDCardFirst_File != null)
                    {
                        string fileName = Path.GetFileName(model.IDCardFirst_File.FileName);
                        fileName = "test" + Guid.NewGuid().ToString() + Path.GetExtension(model.IDCardFirst_File.FileName);
                        model.IDCardFirst_File.SaveAs(path + fileName);
                        model.IDCardFirst      = fileName;
                        model.IDCardFirst_File = null;
                    }
                    if (model.IDCardSecond_AddressProof_File != null)
                    {
                        string fileName = Path.GetFileName(model.IDCardSecond_AddressProof_File.FileName);
                        fileName = "test" + Guid.NewGuid().ToString() + Path.GetExtension(model.IDCardSecond_AddressProof_File.FileName);
                        model.IDCardSecond_AddressProof_File.SaveAs(path + fileName);
                        model.IDCardSecond_AddressProof_     = fileName;
                        model.IDCardSecond_AddressProof_File = null;
                    }
                    if (model.CV_File != null)
                    {
                        string fileName = Path.GetFileName(model.CV_File.FileName);
                        fileName = "test" + Guid.NewGuid().ToString() + Path.GetExtension(model.CV_File.FileName);
                        model.CV_File.SaveAs(path + fileName);
                        model.CV      = fileName;
                        model.CV_File = null;
                    }
                    if (model.ExperienceCertificate_File != null)
                    {
                        string fileName = Path.GetFileName(model.ExperienceCertificate_File.FileName);
                        fileName = "test" + Guid.NewGuid().ToString() + Path.GetExtension(model.ExperienceCertificate_File.FileName);
                        model.ExperienceCertificate_File.SaveAs(path + fileName);
                        model.ExperienceCertificate      = fileName;
                        model.ExperienceCertificate_File = null;
                    }
                    if (model.AppointementLetter_File != null)
                    {
                        string fileName = Path.GetFileName(model.AppointementLetter_File.FileName);
                        fileName = "test" + Guid.NewGuid().ToString() + Path.GetExtension(model.AppointementLetter_File.FileName);
                        model.AppointementLetter_File.SaveAs(path + fileName);
                        model.AppointementLetter      = fileName;
                        model.AppointementLetter_File = null;
                    }
                    if (model.AggrementDocument_File != null)
                    {
                        string fileName = Path.GetFileName(model.AggrementDocument_File.FileName);
                        fileName = "test" + Guid.NewGuid().ToString() + Path.GetExtension(model.AggrementDocument_File.FileName);
                        model.AggrementDocument_File.SaveAs(path + fileName);
                        model.AggrementDocument      = fileName;
                        model.AggrementDocument_File = null;
                    }
                    if (model.OtherDocument_File != null)
                    {
                        string fileName = Path.GetFileName(model.OtherDocument_File.FileName);
                        fileName = "test" + Guid.NewGuid().ToString() + Path.GetExtension(model.OtherDocument_File.FileName);
                        model.OtherDocument_File.SaveAs(path + fileName);
                        model.OtherDocument      = fileName;
                        model.OtherDocument_File = null;
                    }
                    if (!string.IsNullOrWhiteSpace(model.DOB))
                    {
                        model.DateOfBirth = DateTime.ParseExact(model.DOB, "dd/MM/yyyy", null);
                    }
                    //model.DateOfBirth = Convert.ToDateTime(model.DOB);
                    var serialized = JsonConvert.SerializeObject(model);
                    var client     = new HttpClient();
                    var content    = new StringContent(serialized, System.Text.Encoding.UTF8, "application/json");
                    client.BaseAddress = new Uri(HttpContext.Request.Url.AbsoluteUri);
                    var result = client.PostAsync(BaseURL + "/api/Management/AddUpdateEmployee", content).Result;
                    if (result.StatusCode == HttpStatusCode.OK)
                    {
                        var contents = result.Content.ReadAsStringAsync().Result;
                        var Response = JsonConvert.DeserializeObject <ResponseModel>(contents);
                        ModelState.Clear();
                        ModelState.AddModelError("CustomError", Response.response);
                        ViewBag.Class = "alert-success";
                        model         = new EmployeeModel();
                    }
                    else if (result.StatusCode == HttpStatusCode.Unauthorized)
                    {
                        var contents = result.Content.ReadAsStringAsync().Result;
                        var Response = JsonConvert.DeserializeObject <ResponseModel>(contents);
                        ModelState.AddModelError("CustomError", Response.response);
                        ViewBag.Class = "alert-danger";
                    }
                    else
                    {
                        ModelState.AddModelError("CustomError", "Error occurred");
                        ViewBag.Class = "alert-danger";
                    }
                }
            }
            catch (Exception ex)
            {
                ModelState.AddModelError("CustomError", ex.Message);
                ViewBag.Class = "alert-danger";
            }
            model.listDepartment = GetDepartments();
            model.listDepartment = model.listDepartment.Where(s => s.IsActive == true).ToList();
            if (model.DepartmentId > 0)
            {
                model.listDesignation = GetDesignations(model.DepartmentId);
            }
            var list = new List <SelectListItem>
            {
                new SelectListItem {
                    Text = "Admin", Value = "Admin"
                },
                new SelectListItem {
                    Text = "HR", Value = "HR"
                },
                new SelectListItem {
                    Text = "Project Manager", Value = "Project Manager"
                },
                new SelectListItem {
                    Text = "Network Admin", Value = "Network Admin"
                },
                new SelectListItem {
                    Text = "Team Leader", Value = "Team Leader"
                },
                new SelectListItem {
                    Text = "Employee", Value = "Employee"
                }
            };

            ViewData["ddlRole"] = list;
            return(View(model));
        }
Пример #41
0
        public bool Edit([FromBody] EmployeeModel employee)
        {
            var data = EmployeeDataAccessLayer.UpdateEmployee(employee);

            return(data);
        }
Пример #42
0
        public ActionResult Create(EmployeeModel employee)
        {
            _dal.AddEmployee(_mapper.MapToBEModel(employee));

            return(RedirectToAction("Index"));
        }
Пример #43
0
 public void Add(EmployeeModel employee)
 {
     _employeesRepository.Add(employee.ToEntity());
 }
        public void GetMapEmployeeBOL_ShouldReturnException()
        {
            var model = new EmployeeModel();

            Assert.ThrowsException <NullReferenceException>(() => model.GetMapEmployeeBOL(null));
        }
        public ActionResult AddEmployee(EmployeeModel Emp, FormCollection image)
        {
            //var clientPath = Path.GetDirectoryName(photo.FileName);
            //var filename = Path.GetFileName(photo.FileName);
            //var fileName = Path.GetDirectoryName(photo.FileName);
            //var fileName2 = Path.GetFullPath(photo.FileName);
            ////HttpPostedFileBase photo = Request.Files["photo"];
            ////string ss = form["photo"].ToString();
            ////var file2 = Request.Files[0];



            try
            {
                if (ModelState.IsValid)
                {
                    //EmpRepository EmpRepo = new EmpRepository();

                    //if (photo != null && photo.ContentLength > 0)
                    //{
                    //    var fileName = Path.GetFileName(photo.FileName);
                    //    var path = Path.Combine(Server.MapPath("~/TempFile/"), fileName); photo.SaveAs(path);
                    //    UploadImage_URL(path, fileName);

                    //    var fullPath = Server.MapPath("~/TempFile/" + fileName);

                    //    if (System.IO.File.Exists(fullPath))
                    //    {
                    //        System.IO.File.Delete(fullPath);
                    //        //ViewBag.deleteSuccess = "true";
                    //    }
                    //}

                    HttpPostedFileBase fileNameglobal = null;
                    foreach (string item in Request.Files)
                    {
                        HttpPostedFileBase file = Request.Files[item] as HttpPostedFileBase;
                        fileNameglobal = file;
                        if (file.ContentLength == 0)
                        {
                            continue;
                        }

                        if (file.ContentLength > 0)
                        {
                            CloudBlobContainer blobContainer = _blobServices.GetCloudBlobContainer();
                            CloudBlockBlob     blob          = blobContainer.GetBlockBlobReference(file.FileName);
                            blob.UploadFromStream(file.InputStream);
                        }
                    }

                    //var fileName = Path.GetFileName(photo.FileName);
                    var           fileName = Path.GetFileName(fileNameglobal.FileName);
                    EmpRepository EmpRepo  = new EmpRepository();
                    Emp.ImagePath = fileName;
                    EmpRepo.AddEmployee(Emp);
                    ViewBag.Message = "Records added successfully.";
                }

                //return View();
                return(RedirectToAction("GetAllEmpDetails"));
            }
            catch (Exception ex)
            {
                return(View());
            }
        }
Пример #46
0
 /// <summary>
 /// Sets the current employee and accept changes
 /// </summary>
 /// <param name="employee">Employee</param>
 public void SetEmployee(EmployeeModel employee)
 {
     this.CurrentEmployee = employee;
     if (this.CurrentEmployee != null)
     {
         this.CurrentEmployee.PropertyChanged += this.CurrentAccount_PropertyChanged;
         if (!this.CurrentEmployee.IsNew)
         {
             this.CurrentEmployee.AcceptChanges();
         }
         else
         {
             this.InvokeAccountChangedEvent();
         }
     }
 }
Пример #47
0
 public ActionResult Create(EmployeeModel objemployeemodel)
 {
     try
     {
         DynamicParameters param = new DynamicParameters();
         param.Add("@UserId", objemployeemodel.EmployeeUserName);
         param.Add("@Pass", objemployeemodel.EmployeePassword);
         IEnumerable <EmployeeModel> Employeedata = SqlHelper.QuerySP <EmployeeModel>("AdminLogIn", param, null);
         if (Employeedata != null && Employeedata.ToList().Count() > 0)
         {
             if (Employeedata.Where(x => x.EmployeeUserName == objemployeemodel.EmployeeUserName && x.EmployeePassword == objemployeemodel.EmployeePassword).Count() > 0)
             {
                 EmployeeModel objemp = new EmployeeModel();
                 objemp = Employeedata.Where(x => x.EmployeeUserName == objemployeemodel.EmployeeUserName && x.EmployeePassword == objemployeemodel.EmployeePassword).FirstOrDefault();
                 if (objemp.DesignationId == 1)
                 {
                     Session["Employee"] = objemp;
                     //Response.Redirect("~/Admin/Admin.aspx");
                     TempData["ErrorMessage"] = null;
                     return(RedirectToAction("Index", "Dashboard"));
                 }
                 else if (objemp.DesignationId == 2)
                 {
                     Session["Employee"] = objemp;
                     //Response.Redirect("~/Manager/Manager.aspx");
                     TempData["ErrorMessage"] = null;
                     return(RedirectToAction("Index", "Dashboard"));
                 }
                 else if (objemp.DesignationId == 3)
                 {
                     Session["Employee"] = objemp;
                     //Response.Redirect("./Chef.aspx");
                     TempData["ErrorMessage"] = null;
                     return(RedirectToAction("Index", "Dashboard"));
                 }
                 else
                 {
                     TempData["ErrorMessage"] = "Error Encountered.";
                     return(View("Index"));
                 }
             }
             else
             {
                 TempData["ErrorMessage"] = "Invalid Username or Password.";
                 return(View("Index"));
             }
         }
         else
         {
             //TempData["ErrorMessage"] = "Not a single user is registered.";
             //return View("Index");
             DynamicParameters param1 = new DynamicParameters();
             IEnumerable <TableInformationModel> tabledata = SqlHelper.QuerySP <TableInformationModel>("usp_GetTableInfo", param1, null);
             if (tabledata.Count() > 0)
             {
                 if (tabledata.ToList().Where(x => x.TableName == objemployeemodel.EmployeeUserName && x.TablePassword == objemployeemodel.EmployeePassword).Count() > 0)
                 {
                     Session["TableInfo"] = tabledata.ToList().Where(x => x.TableName == objemployeemodel.EmployeeUserName && x.TablePassword == objemployeemodel.EmployeePassword).FirstOrDefault();
                     return(RedirectToAction("Index", "Home"));
                 }
                 else
                 {
                     TempData["ErrorMessage"] = "Not a single user is registered.";
                     return(View("Index"));
                 }
             }
             else
             {
                 TempData["ErrorMessage"] = "Not a single user is registered.";
                 return(View("Index"));
             }
         }
     }
     catch
     {
         return(View());
     }
 }
 public ChatViewModel(EmployeeModel employee)
 {
     Chat = ChatRoomModel.CreateChat(employee);
 }
Пример #49
0
        public ActionResult Edit(EmployeeModel employee)
        {
            _dal.UpdateEmployee(_mapper.MapToBEModel(employee));

            return(RedirectToAction("Index"));
        }
Пример #50
0
 public Task <EmployeeModel> Update(EmployeeModel model)
 {
     throw new NotImplementedException();
 }
Пример #51
0
        public IActionResult Post()
        {
            var payload = ReadPayload();

            _logger.LogInformation("Received a webhook");

            var signatureHeader = Request.Headers["x-xero-signature"].FirstOrDefault();

            _logger.LogInformation("Verifying the signature to confirm that the payload is from Xero.");
            var isValid = _signatureVerifier.VerifySignature(payload, signatureHeader);

            if (!isValid)
            {
                _logger.LogWarning("The signature is incorrect. Responding with HTTP 401 Unauthorised.");
                return(Unauthorized());
            }

            _logger.LogInformation("The signature is correct. Saving the payload for processing later (so that we can respond as quickly as possible).");

            if (!payload.Contains("resourceId")) // hand-shake
            {
                return(Ok());
            }

            // _payloadQueue.Enqueue(payload);
            // var update = JsonConvert.DeserializeXNode(payload);

            var objectToUpdate = JsonConvert.DeserializeObject <Payload>(payload);


            var @event = objectToUpdate.Events.FirstOrDefault();

            if (@event != null)
            {
                return(Ok());
            }

            var model = new EmployeeModel {
                ContactId = @event.ResourceId
            };


            switch (@event.EventType)
            {
            case "UPDATE":
                _employeeService.Update(model);
                break;

            case "ADD":
                _employeeService.Add(model);
                break;
            }

            _contactObservable.AddActivity(
                new Activity
            {
                Id         = model.Id,
                PersonName = model.FullName,
                Status     = @event.EventType
            });

            _logger.LogInformation("Webhook is saved. Returning an empty 200 OK");
            return(Ok());
        }
        public ActionResult UpdateProject(ProjectListEdit EPL)
        {
            try
            {
                JavaScriptSerializer json_serializer = new JavaScriptSerializer();
                var modifiedOrNewEmpList             = json_serializer.Deserialize <EmployeeProjectList[]>(EPL.EmployeeProjectList);

                StringBuilder errorMessage = new StringBuilder();

                if (EPL.Theme.HasValue)
                {
                    var eligibleThemeGrants = ConfigurationManager.AppSettings["ThemeGrandCodes"].ToString().Split(',').ToList();
                    var themeMstType        = Convert.ToInt32(ConfigurationManager.AppSettings["TypeGrant"]);
                    var themes = DB.MasterData.Where(x => x.MstTypeID == themeMstType && eligibleThemeGrants.Contains(x.MstCode)).Select(x => x.MstID);
                    if (!themes.Contains(EPL.ProjectGrant))
                    {
                        EPL.Theme = null;
                    }
                }

                if (EPL.IsRDProject == 1)
                {
                    IEnumerable <EmployeeProjectList> GetDetails = DB.Database.SqlQuery <EmployeeProjectList>(
                        @"exec " + Constants.P_UpdateProjectList + " @ProjectName,@ProjectId,@ProjectCode,@StartDate,@EndDate,@InternalOrder,@ProjectGrant,@IsRDProject,@Theme,@ResearchArea,@TypeofResearch,@CostCenter,@ProjectDesc",
                        new object[] {
                        new SqlParameter("@ProjectName", EPL.ProjectName),
                        new SqlParameter("@ProjectId", EPL.ProjectID),
                        new SqlParameter("@ProjectCode", EPL.ProjectCode),
                        new SqlParameter("@StartDate", EPL.StartDate),
                        new SqlParameter("@EndDate", EPL.EndDate),
                        new SqlParameter("@InternalOrder", EPL.InternalOrder),
                        new SqlParameter("@ProjectGrant", EPL.ProjectGrant),
                        new SqlParameter("@ResearchArea", EPL.ResearchArea),
                        new SqlParameter("@TypeofResearch", EPL.TypeofResearch),
                        new SqlParameter("@IsRDProject", EPL.IsRDProject),
                        new SqlParameter("@CostCenter", EPL.CostCentre),
                        new SqlParameter("@ProjectDesc", EPL.ProjectDesc ?? ""),
                        new SqlParameter("@Theme", (object)EPL.Theme ?? DBNull.Value),
                    }).ToList().Distinct();
                }
                else
                {
                    IEnumerable <EmployeeProjectList> GetDetails = DB.Database.SqlQuery <EmployeeProjectList>(
                        @"exec " + Constants.P_UpdateProjectList + " @ProjectName,@ProjectId,@ProjectCode,@StartDate,@EndDate,@InternalOrder,@ProjectGrant,@IsRDProject,@Theme,null,null,@CostCenter,@ProjectDesc",
                        new object[] {
                        new SqlParameter("@ProjectName", EPL.ProjectName),
                        new SqlParameter("@ProjectId", EPL.ProjectID),
                        new SqlParameter("@ProjectCode", EPL.ProjectCode),
                        new SqlParameter("@StartDate", EPL.StartDate),
                        new SqlParameter("@EndDate", EPL.EndDate),
                        new SqlParameter("@InternalOrder", EPL.InternalOrder),
                        new SqlParameter("@ProjectGrant", EPL.ProjectGrant),
                        new SqlParameter("@IsRDProject", EPL.IsRDProject),
                        new SqlParameter("@Theme", (object)EPL.Theme ?? DBNull.Value),
                        new SqlParameter("@CostCenter", EPL.CostCentre),
                        new SqlParameter("@ProjectDesc", EPL.ProjectDesc ?? ""),
                    }).ToList().Distinct();
                }
                List <ProjectEmployeesModel> projectMembers = DB.ProjectEmployee.Where(x => x.ProjectID == EPL.ProjectID).ToList();

                foreach (ProjectEmployeesModel item in projectMembers)
                {
                    if (item.EndDate > EPL.EndDate)
                    {
                        item.EndDate         = EPL.EndDate;
                        DB.Entry(item).State = System.Data.Entity.EntityState.Modified;
                        DB.SaveChanges();
                    }
                }
                foreach (var item in modifiedOrNewEmpList)
                {
                    if (!DB.ProjectEmployee.Any(x => x.ProjectID == EPL.ProjectID && x.EmployeeID == item.EmployeeID))
                    {
                        EmployeeModel refRole = DB.Employee.FirstOrDefault(x => x.EmployeeID == item.EmployeeID);
                        List <EmployeeProjectList> GetDetails2 = DB.Database.SqlQuery <EmployeeProjectList>(
                            @"exec " + Constants.P_InsertProjectEmployee + " @ProjectId,@EmployeeID,@CheckRole,@InvPercentage,@RefRole,@StartDate,@EndDate,@Grant,@IsActive,@CreatedBy",
                            new object[] {
                            new SqlParameter("@ProjectId", EPL.ProjectID),
                            new SqlParameter("@EmployeeID", item.EmployeeID),
                            new SqlParameter("@CheckRole", item.IsManager),
                            new SqlParameter("@InvPercentage", item.InvPercentage),
                            new SqlParameter("@RefRole", EPL.IsRDProject == 1 ? (refRole.RoleID ?? 0) : 0),
                            new SqlParameter("@StartDate", item.StartDate),
                            new SqlParameter("@EndDate", item.EndDate),
                            new SqlParameter("@Grant", Convert.ToInt64(EPL.ProjectGrant)),
                            new SqlParameter("@IsActive", 1),
                            new SqlParameter("@CreatedBy", Session["EmployeeId"].ToString())
                        }).ToList();

                        if (EPL.IsRDProject == 1 && refRole.RoleID == null)
                        {
                            ViewBag.Message = ViewBag.Message + $"line Employee { SCTimeSheet.Models.Common.GetName(refRole.EmpFirstName, refRole.EmpLastName, refRole.EmpMiddleName) } Role is blank, please modify manually or contact administrator";
                        }

                        if (!string.IsNullOrEmpty(refRole.Email))
                        {
                            if (!DB.User.Any(x => x.Email == refRole.Email))
                            {
                                UserModel user = new UserModel
                                {
                                    Email       = refRole.Email,
                                    CreatedBy   = 1,
                                    CreatedDate = DateTime.Now,
                                    IsActive    = true,
                                    Password    = "******",
                                    RoleID      = item.IsManager ? Convert.ToInt64(ReadConfig.GetValue("RolePM")) : Convert.ToInt64(ReadConfig.GetValue("RoleEmployee"))
                                };
                                DB.User.Add(user);
                                DB.SaveChanges();

                                refRole.UserID = user.UserID;
                                DB.Employee.Attach(refRole);
                                DB.Entry(refRole).State = System.Data.Entity.EntityState.Modified;
                                DB.SaveChanges();
                            }
                        }
                        else
                        {
                            ViewBag.Message = ViewBag.Message + $"line Employee { SCTimeSheet.Models.Common.GetName(refRole.EmpFirstName, refRole.EmpLastName, refRole.EmpMiddleName) } email is blank, please contact administrator";
                        }
                    }
                    else
                    {
                        var emp = DB.ProjectEmployee.FirstOrDefault(x => x.ProjectID == EPL.ProjectID && x.EmployeeID == item.EmployeeID);
                        emp.InvPercentage   = item.InvPercentage;
                        emp.StartDate       = item.StartDate;
                        emp.EndDate         = item.EndDate;
                        emp.CheckRole       = item.IsManager;
                        emp.RefRole         = item.EmpRole;
                        DB.Entry(emp).State = System.Data.Entity.EntityState.Modified;
                        DB.SaveChanges();
                    }
                }
                // return RedirectToAction("Index", "ProjectMain");
                ViewBag.Message = ViewBag.Message + $"line {EPL.ProjectName } is updated successfully";

                GetDefaults();
                ViewBag.ProjectId = EPL.ProjectID;
                ViewBag.GrantID   = EPL.ProjectGrant;

                ViewBag.ReasearchID = EPL.ResearchArea;
                ViewBag.TypeID      = EPL.TypeofResearch;

                //EPL.ProjectMembers = string.Join(",", empPercentageStatus.Select(x => x.Key.Key));
                //EPL.ProjectMembersNames = string.Join(",", empPercentageStatus.Select(x => x.Key.Value));
                EPL.EmpSearchText = "";
                return(View("ProjectEdit", EPL));
            }
            catch (Exception ex)
            {
                LogHelper.ErrorLog(ex);
                throw ex;
            }
        }
 public static void InviteToChat(EmployeeModel employee, ChatRoomModel chatRoom)
 {
     throw new NotImplementedException();
 }
        public ActionResult Save(ProjectMasterModelNew model)
        {
            try
            {
                GetDefaults();
                JavaScriptSerializer json_serializer = new JavaScriptSerializer();
                var modifiedOrNewEmpList             = json_serializer.Deserialize <EmployeeProjectList[]>(model.EmployeeProjectList);

                ModelState.Remove("ProjectID");
                // model.ValidateModel(ModelState);
                model.MemberProjectGrant = model.ProjectGrant;

                Session["ProjectGrant"] = model.ProjectGrant;
                model.IsActive          = true;
                if (model.Theme.HasValue)
                {
                    var eligibleThemeGrants = ConfigurationManager.AppSettings["ThemeGrandCodes"].ToString().Split(',').ToList();
                    var themeMstType        = Convert.ToInt32(ConfigurationManager.AppSettings["TypeGrant"]);
                    var themes = DB.MasterData.Where(x => x.MstTypeID == themeMstType && eligibleThemeGrants.Contains(x.MstCode)).Select(x => x.MstID);
                    if (!themes.Contains(model.ProjectGrant))
                    {
                        model.Theme = null;
                    }
                }
                ProjectMasterModel newModel = new ProjectMasterModel
                {
                    ProjectID       = model.ProjectID,
                    ProjectCode     = model.ProjectCode,
                    ProjectName     = model.ProjectName,
                    ProjectDesc     = model.ProjectDesc,
                    InternalOrder   = model.InternalOrder,
                    CostCentre      = model.CostCentre,
                    ProjectGrant    = model.ProjectGrant,
                    ResearchArea    = model.ResearchArea,
                    TypeofResearch  = model.TypeofResearch,
                    StartDate       = model.StartDate,
                    EndDate         = model.EndDate,
                    ProjectDuration = model.ProjectDuration,
                    IsActive        = true,
                    IsRDProject     = model.IsRDProject,
                    Theme           = model.Theme
                };
                DB.ProjectMaster.Add(newModel);
                DB.SaveChanges();

                long   projectId   = DB.ProjectMaster.Where(x => x.ProjectCode == model.ProjectCode).Select(x => x.ProjectID).FirstOrDefault();
                string projectName = DB.ProjectMaster.Where(x => x.ProjectCode == model.ProjectCode).Select(x => x.ProjectName).FirstOrDefault();
                Session["pId"]        = projectId;
                Session["pName"]      = projectName;
                TempData["projectid"] = 1;

                TempData["Success"] = ResourceMessage.NewProjectAdd;

                Session["ProjectGrant"] = model.ProjectGrant;

                if (modifiedOrNewEmpList.Any())
                {
                    model.ProjectID = projectId;

                    model.IsActive = true;

                    foreach (var item in modifiedOrNewEmpList)
                    {
                        EmployeeModel refRole = DB.Employee.FirstOrDefault(x => x.EmployeeID == item.EmployeeID);
                        List <EmployeeProjectList> GetDetails = DB.Database.SqlQuery <EmployeeProjectList>(
                            @"exec " + Constants.P_InsertProjectEmployee + " @ProjectId,@EmployeeID,@CheckRole,@InvPercentage,@RefRole,@StartDate,@EndDate,@Grant,@IsActive,@CreatedBy",
                            new object[] {
                            new SqlParameter("@ProjectId", model.ProjectID),
                            new SqlParameter("@EmployeeID", item.EmployeeID),
                            new SqlParameter("@CheckRole", item.IsManager),
                            new SqlParameter("@InvPercentage", item.InvPercentage),
                            new SqlParameter("@RefRole", model.IsRDProject == 1 ? (refRole.RoleID ?? 0) : 0),
                            new SqlParameter("@StartDate", item.StartDate),
                            new SqlParameter("@EndDate", item.EndDate),
                            new SqlParameter("@Grant", model.ProjectGrant),
                            new SqlParameter("@IsActive", model.IsActive),
                            new SqlParameter("@CreatedBy", Session["EmployeeId"].ToString())
                        }).ToList();

                        if (model.IsRDProject == 1 && refRole.RoleID == null)
                        {
                            ViewBag.Message = ViewBag.Message + $"line Employee { SCTimeSheet.Models.Common.GetName(refRole.EmpFirstName, refRole.EmpLastName, refRole.EmpMiddleName) } Role is blank, please modify manually or contact administrator";
                        }

                        if (!string.IsNullOrEmpty(refRole.Email))
                        {
                            if (!DB.User.Any(x => x.Email == refRole.Email))
                            {
                                UserModel user = new UserModel
                                {
                                    Email       = refRole.Email,
                                    CreatedBy   = 1,
                                    CreatedDate = DateTime.Now,
                                    IsActive    = true,
                                    Password    = "******",
                                    RoleID      = item.IsManager ? Convert.ToInt64(ReadConfig.GetValue("RolePM")) : Convert.ToInt64(ReadConfig.GetValue("RoleEmployee"))
                                };
                                DB.User.Add(user);
                                DB.SaveChanges();

                                refRole.UserID = user.UserID;
                                DB.Employee.Attach(refRole);
                                DB.Entry(refRole).State = System.Data.Entity.EntityState.Modified;
                                DB.SaveChanges();
                            }
                        }
                        else
                        {
                            ViewBag.Message = ViewBag.Message + $"line Employee { SCTimeSheet.Models.Common.GetName(refRole.EmpFirstName, refRole.EmpLastName, refRole.EmpMiddleName) } email is blank, please contact administrator";
                        }
                    }
                }
                TempData.Add("ProjectCreated", $"{model.ProjectName } is created successfully");
                return(RedirectToAction("Index", "ProjectMain"));
            }
            catch (Exception ex)
            {
                TempData["Error"] = ex.ToString();
                LogHelper.ErrorLog(ex);
            }
            return(View("Index", model));
        }
 private void BuildEmployeeModel(EmployeeModel employeeModel)
 {
     employeeModel.ActionMethod        = ActionMethod.Edit;
     employeeModel.DepartmentModelList = _departmentService.GetAll().Select(x => _mapper.Map <Department, DepartmentModel>(x)).ToList();
 }
Пример #56
0
 public void RemoveEmployee(EmployeeModel focusedEmployee)
 {
     this.Employees.Remove(focusedEmployee);
 }
Пример #57
0
 public void SetEmployee(EmployeeModel employee)
 {
     this.CurrentEmployee = employee;
 }
 public EmployeeViewModel(EmployeeModel model)
 {
     Model     = model;
     IsChecked = model.IsChecked;
     EmpName   = model.EmpName;
 }
Пример #59
0
 private void EmployeeDataBind(string strPK)
 {
     try
     {
         this.dbo = new DB_OPT();
         this.dbo.Open();
         this.em = new EmployeeDal();
         DataSet list = new DataSet();
         list = this.em.GetList(" pk_corp='" + strPK + "'", this.dbo);
         if ((list != null) && (list.Tables[0].Rows.Count > 0))
         {
             this.gv_Employee.DataSource = list;
             this.gv_Employee.DataBind();
         }
         else
         {
             DataTable table = new DataTable();
             table = list.Tables[0];
             DataRow row = table.NewRow();
             table.Rows.Add(row);
             this.gv_Employee.DataSource = table.DefaultView;
             this.gv_Employee.DataBind();
         }
     }
     catch (Exception exception)
     {
         this.el = new ExceptionLog.ExceptionLog();
         this.el.ErrClassName = base.GetType().ToString();
         this.el.ErrMessage = exception.Message.ToString();
         this.el.ErrMethod = "EmployeeDataBind()";
         this.el.WriteExceptionLog(true);
         Const.OpenErrorPage("获取数据失败,请联系系统管理员!", this.Page);
     }
     finally
     {
         if (this.dbo != null)
         {
             this.dbo.Close();
         }
     }
 }
Пример #60
0
        public async Task <IActionResult> Edit([FromForm] EmployeeModel model)
        {
            if (!ModelState.IsValid)
            {
                PartialView();
            }

            // Map model to resource
            var resource = mapper.Map <EmployeeResource>(model);

            // save resource to Json
            var resourceDocument = JsonConvert.SerializeObject(resource);

            using (var content = new StringContent(resourceDocument, Encoding.UTF8, "application/json"))
            {
                using (var client = restClient.CreateClient(User))
                {
                    // determen call update or insert
                    Upsert upsert = client.PutAsync;

                    // no RowVersion indicates insert
                    if (model.RowVersion.IsNullOrEmpty())
                    {
                        upsert = client.PostAsync;
                    }

                    using (var response = await upsert(apiUrl, content))
                    {
                        // init result
                        var result = new ResourceResult <EmployeeResource>(resource);

                        // read result from RESTful service
                        var responseDocument = await response.Content.ReadAsStringAsync();

                        if (response.StatusCode == HttpStatusCode.OK ||
                            response.StatusCode == HttpStatusCode.Created)
                        {
                            // Fetch created or updated resource from response
                            result.Resource = JsonConvert.DeserializeObject <EmployeeResource>(responseDocument);;
                        }
                        else
                        {
                            // fetch errors and or exceptions
                            result = JsonConvert.DeserializeObject <ResourceResult <EmployeeResource> >(responseDocument);
                        }

                        // Set error message for concurrency error
                        if (response.StatusCode == HttpStatusCode.Conflict)
                        {
                            result.Errors.Clear();
                            result.Errors.Add(new ValidationError("This record is modified by another user"));
                            result.Errors.Add(new ValidationError("Your work is not saved and replaced with new content"));
                            result.Errors.Add(new ValidationError("Please review the new content and if required edit and save again"));
                        }

                        if (response.StatusCode.IsInSet(HttpStatusCode.OK, HttpStatusCode.Created, HttpStatusCode.Conflict))
                        {
                            return(StatusCode(response.StatusCode.ToInt32(), result));
                        }

                        // copy errors so they will be rendered in edit form
                        foreach (var error in result.Errors)
                        {
                            ModelState.AddModelError(error.MemberName ?? "", error.Message);
                        }

                        // Update model with Beautify effect(s) and make it visible in the partial view
                        IEnumerable <PropertyInfo> properties = model.GetType().GetTypeInfo().GetProperties(BindingFlags.Public | BindingFlags.Instance);

                        foreach (var property in properties)
                        {
                            var rawValue       = property.GetValue(model);
                            var attemptedValue = rawValue == null ? "" : Convert.ToString(rawValue, CultureInfo.InvariantCulture);

                            ModelState.SetModelValue(property.Name, rawValue, attemptedValue);
                        }

                        // No need to specify model here, it has no effect on the render process :-(
                        return(PartialView());
                    }
                }
            }
        }