Beispiel #1
0
        public static bool InsertOrganisationComm(EvolutionRepository.Models.OrganisationComm newOrgCom)
        {
            var Result = false;

            try
            {
                using (var ctx = new EvolutionRepository.Models.EvolutionDBContext())
                {
                    var orgCom = new EvolutionRepository.Models.OrganisationComm();
                    orgCom.OrganisationCommTypeID = newOrgCom.OrganisationCommTypeID;
                    orgCom.OrganisationID         = newOrgCom.OrganisationID;
                    orgCom.Address        = newOrgCom.Address;
                    orgCom.AddressPrefix  = newOrgCom.AddressPrefix;
                    orgCom.CommsHoneymoon = newOrgCom.CommsHoneymoon;
                    ctx.OrganisationComms.Add(orgCom);
                    ctx.SaveChanges();

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

            return(Result);
        }
Beispiel #2
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);
        }
Beispiel #3
0
        public static bool EditOrganisationComm(EvolutionRepository.Models.OrganisationComm updatedOrgCom)
        {
            var Result = false;

            try
            {
                using (var ctx = new EvolutionRepository.Models.EvolutionDBContext())
                {
                    var orgCom = ctx.OrganisationComms.FirstOrDefault(x => x.OrganisationCommID == updatedOrgCom.OrganisationCommID);
                    orgCom.OrganisationCommTypeID = updatedOrgCom.OrganisationCommTypeID;
                    orgCom.OrganisationID         = updatedOrgCom.OrganisationID;
                    orgCom.Address        = updatedOrgCom.Address;
                    orgCom.AddressPrefix  = updatedOrgCom.AddressPrefix;
                    orgCom.CommsHoneymoon = updatedOrgCom.CommsHoneymoon;

                    ctx.SaveChanges();

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

            return(Result);
        }
Beispiel #4
0
        public static bool AddArea(EvolutionRepository.Models.Area newArea)
        {
            var Result = false;

            try
            {
                using (var ctx = new EvolutionRepository.Models.EvolutionDBContext())
                {
                    var DBArea = ctx.Areas.FirstOrDefault(x => x.AreaID == newArea.AreaID);
                    if (DBArea == null)
                    {
                        DBArea                           = new EvolutionRepository.Models.Area();// ctx.Areas;
                        DBArea.AreaName                  = newArea.AreaName;
                        DBArea.Mobile                    = newArea.Mobile;
                        DBArea.OrganisationID            = newArea.OrganisationID;
                        DBArea.Telephone                 = newArea.Telephone;
                        DBArea.Total_Engineers_Allocated = newArea.Total_Engineers_Allocated;
                        DBArea.Total_staff_Allocted      = newArea.Total_staff_Allocted;
                        DBArea.Total_Vehicles_Allocated  = newArea.Total_Vehicles_Allocated;
                        DBArea.EmployeeID                = newArea.EmployeeID;
                        DBArea.EmergencyNumber           = newArea.EmergencyNumber;

                        ctx.Areas.Add(DBArea);
                        ctx.SaveChanges();
                    }
                    Result = true;
                }
            }
            catch (Exception)
            {
                Result = false;
            }

            return(Result);
        }
Beispiel #5
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);
        }
Beispiel #6
0
        public static bool DeleteOrganisationComm(int organisationCommID)
        {
            var Result = false;

            try
            {
                using (var ctx = new EvolutionRepository.Models.EvolutionDBContext())
                {
                    var orgCom = ctx.OrganisationComms.FirstOrDefault(x => x.OrganisationCommID == organisationCommID);
                    ctx.OrganisationComms.Remove(orgCom);
                    ctx.SaveChanges();

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

            return(Result);
        }
Beispiel #7
0
        public static bool DeleteArea(int areaID) //EvolutionRepository.Models.Area AddArea)
        {
            var Result = false;

            try
            {
                using (var ctx = new EvolutionRepository.Models.EvolutionDBContext())
                {
                    var DBArea = ctx.Areas.FirstOrDefault(x => x.AreaID == areaID);
                    if (DBArea != null)
                    {
                        ctx.Areas.Remove(DBArea);
                        ctx.SaveChanges();
                    }
                    Result = true;
                }
            }
            catch (Exception)
            {
                Result = false;
            }

            return(Result);
        }