Пример #1
0
        public static bool CreateEmployee(EvolutionRepository.Models.Employee CreateEmp)
        {
            var Result = false;

            try
            {
                using (var ctx = new EvolutionRepository.Models.EvolutionDBContext())
                {
                    if (Object.Equals(null, ctx.Employees.FirstOrDefault(x => x.EmployeeID == CreateEmp.EmployeeID)))
                    {
                        ctx.Employees.Add(CreateEmp);
                        ctx.SaveChanges();
                    }

                    Result = true;
                }
            }
            catch (DbEntityValidationException ex)
            {
                // Throw a new DbEntityValidationException with the improved exception message.
                throw new DbEntityValidationException(ErrorHandler.BuildDbEntityValidationErrorMessage(ex), ex.EntityValidationErrors);
            }
            catch (Exception ex)
            {
                Result = false;
                throw ex;
            }
            return(Result);
        }
Пример #2
0
        public static bool UpdateEmployee(EvolutionRepository.Models.Employee UpdateEmp)
        {
            var Result = false;

            try
            {
                using (var ctx = new EvolutionRepository.Models.EvolutionDBContext())
                {
                    var DBEmp = ctx.Employees.FirstOrDefault(x => x.EmployeeID == UpdateEmp.EmployeeID);
                    //DBEmp.BankAccountID = UpdateEmp.BankAccountID;
                    //DBEmp.CompanyNumber = UpdateEmp.CompanyNumber;
                    //DBEmp.ContactName = UpdateEmp.ContactName;
                    //DBEmp.EmailAddress = UpdateEmp.EmailAddress;
                    //DBEmp.FaxCode = UpdateEmp.FaxCode;
                    //DBEmp.FaxNumber = UpdateEmp.FaxNumber;
                    //DBEmp.JurisdictionID = UpdateEmp.JurisdictionID;
                    //DBEmp.Latitude = UpdateEmp.Latitude;
                    //DBEmp.Longitude = UpdateEmp.Longitude;
                    //DBEmp.MaximumMachines = UpdateEmp.MaximumMachines;
                    //DBEmp.EmployeeName = UpdateEmp.EmployeeName;
                    //DBEmp.EmployeeStatusID = UpdateEmp.EmployeeStatusID;
                    //DBEmp.EmployeeSubTypeID = UpdateEmp.EmployeeSubTypeID;
                    //DBEmp.EmployeeTypeID = UpdateEmp.EmployeeTypeID;
                    //DBEmp.ParentID = UpdateEmp.ParentID;
                    //DBEmp.TaxNumber = UpdateEmp.TaxNumber;
                    //DBEmp.TelephoneCode = UpdateEmp.TelephoneCode;
                    //DBEmp.TelephoneNumber = UpdateEmp.TelephoneNumber;
                    //DBEmp.Timestamp = System.Text.ASCIIEncoding.Unicode.GetBytes(DateTime.Now.ToString());
                    //DBEmp.WebSiteURL = UpdateEmp.WebSiteURL;
                    ctx.SaveChanges();

                    Result = true;
                }
            }
            catch (Exception ex)
            {
                Result = false;
                throw ex;
            }

            return(Result);
        }