Exemplo n.º 1
0
        public HttpResponseMessage HarvestPond([FromBody] HarvestDTO uDto)
        {
            string key;
            var    ur        = new AppUserRepository();
            var    companyId = 0;
            var    UserId    = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (UserId > 0 && aur.IsInRole(UserId, "Chowtime"))
            {
                var hr     = new HarvestRepository();
                var harv   = new Harvest();
                var errors = ValidateDtoData(uDto, harv);
                if (errors.Any())
                {
                    return(ProcessValidationErrors(Request, errors, key));
                }

                return(ProcessNewHarvestRecord(Request, uDto, key, companyId, UserId));


                //  no idea what this is
                var msg = "invalid data structure submitted";
                return(Request.CreateResponse(HttpStatusCode.BadRequest, msg));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
Exemplo n.º 2
0
 public UnitOfWork(XdContext context)
 {
     _context            = context;
     AddressInformations = new AddressInformationRepository(_context);
     AppUsers            = new AppUserRepository(_context);
     AppUserRoles        = new AppUserRoleRepository(_context);
     Contacts            = new ContactRepository(_context);
     Credentials         = new CredentialsRepository(_context);
     DbTypes             = new DbTypeRepository(_context);
     Entities            = new EntityRepository(_context);
     EntityTypes         = new EntityTypeRepository(_context);
     Fields = new FieldRepository(_context);
     FieldRequirementLevels = new FieldRequirementLevelRepository(_context);
     FieldTypes             = new FieldTypeRepository(_context);
     Forms           = new FormRepository(_context);
     FormTypes       = new FormTypeRepository(_context);
     Genders         = new GenderRepository(_context);
     MaritalStatuses = new MaritalStatusRepository(_context);
     MenuItems       = new MenuItemRepository(_context);
     Roles           = new RoleRepository(_context);
     Tabs            = new TabRepository(_context);
     Titles          = new TitleRepository(_context);
     Views           = new ViewRepository(_context);
     ViewTypes       = new ViewTypeRepository(_context);
 }
        public HttpResponseMessage ChangeFarmStatus([FromBody] FarmDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var companyId = 0;
            var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (UserId > 0 && aur.IsInRole(UserId, "Admin"))
            {
                var Farm = new Farm();
                var errors = ValidateDtoData(uDto, Farm);
                if (errors.Any())
                {
                    return ProcessValidationErrors(Request, errors, key);
                }
                var NEFarmId = 0;
                if (int.TryParse(uDto.FarmId, out NEFarmId))
                {
                    if (NEFarmId != -1)
                    {

                        return ChangeThisFarmStatus(Request, uDto, NEFarmId, key, companyId, UserId);
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return Request.CreateResponse(HttpStatusCode.BadRequest, msg);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
Exemplo n.º 4
0
        public HttpResponseMessage ChangePondFeedStatus([FromBody] PondDTO uDto)
        {
            string key;
            var    ur                 = new AppUserRepository();
            var    companyId          = 0;
            var    UserId             = ur.ValidateUser(uDto.Key, out key, ref companyId);
            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (UserId > 0 && aur.IsInRole(UserId, "Admin"))
            {
                var Pond   = new Pond();
                var errors = ValidateDtoData(uDto, Pond);
                if (errors.Any())
                {
                    return(ProcessValidationErrors(Request, errors, key));
                }
                var NEPondId = 0;
                if (int.TryParse(uDto.PondId, out NEPondId))
                {
                    //  editing existing Pond record
                    return(ChangePondFeedStatus(Request, uDto, NEPondId, key, companyId, UserId));
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return(Request.CreateResponse(HttpStatusCode.BadRequest, msg));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
        public HttpResponseMessage ChangePondFeedStatus([FromBody] PondDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var companyId = 0;
            var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);
            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (UserId > 0 && aur.IsInRole(UserId, "Admin"))
            {
                var Pond = new Pond();
                var errors = ValidateDtoData(uDto, Pond);
                if (errors.Any())
                {
                    return ProcessValidationErrors(Request, errors, key);
                }
                var NEPondId = 0;
                if (int.TryParse(uDto.PondId, out NEPondId))
                {

                    //  editing existing Pond record
                    return ChangePondFeedStatus(Request, uDto, NEPondId, key, companyId, UserId);

                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return Request.CreateResponse(HttpStatusCode.BadRequest, msg);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
Exemplo n.º 6
0
        public HttpResponseMessage PondMortalityLast7Mortalities([FromBody] PondDTO uDto)
        {
            string key;
            var    ur        = new AppUserRepository();
            var    companyId = 0;
            var    UserId    = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (UserId > 0 && aur.IsInRole(UserId, "Chowtime"))
            {
                var      pr        = new PondRepository();
                var      ponddata  = pr.GetById(int.Parse(uDto.PondId));
                DateTime startdate = DateTime.Now;

                int i             = 0;
                int j             = 0;
                int pondDataCount = 0;

                var col = new Collection <Dictionary <string, string> >();
                while (pondDataCount < 7 && j < 10)
                {
                    var      db        = new AppEntities();
                    string   datepart  = startdate.AddDays(i).ToShortDateString();
                    DateTime begindate = DateTime.Parse(datepart);
                    DateTime enddate   = begindate.AddDays(1);
                    var      data      = db.Mortalities.Where(x => x.PondId == ponddata.PondId && x.MortalityDate >= begindate && x.MortalityDate < enddate).FirstOrDefault();
                    if (data != null)
                    {
                        var dic = new Dictionary <string, string>();

                        dic.Add("PondId", data.PondId.ToString());
                        dic.Add("MortalityId", data.MortalityId.ToString());
                        dic.Add("MortalityDate", data.MortalityDate.ToString());
                        dic.Add("MortalityPounds", data.MortalityPounds.ToString());
                        col.Add(dic);
                        pondDataCount++;
                        // reset j - haven't hit null territory yet
                        j = 0;
                    }
                    else
                    {
                        j++;
                    }
                    i--;
                }
                var retVal = new GenericDTO
                {
                    Key        = key,
                    ReturnData = col
                };
                return(Request.CreateResponse(HttpStatusCode.OK, retVal));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
        public HttpResponseMessage ShiftEndAddOrEdit([FromBody] ShiftEndDTO uDto)
        {
            string key;
            var    ur         = new AppUserRepository();
            var    ShiftEndId = 0;
            var    userId     = ur.ValidateUser(uDto.Key, out key, ref ShiftEndId);

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (userId > 0 && aur.IsInRole(userId, "Data Entry"))
            {
                var ShiftEnd = new ShiftEnd();
                uDto.DayFinishedFreezing   = uDto.DayFinishedFreezing == "" ? null : uDto.DayFinishedFreezing;
                uDto.RegEmpLate            = uDto.RegEmpLate == "" ? null : uDto.RegEmpLate;
                uDto.RegEmpOut             = uDto.RegEmpOut == "" ? null : uDto.RegEmpOut;
                uDto.RegEmplLeftEarly      = uDto.RegEmplLeftEarly == "" ? null : uDto.RegEmplLeftEarly;
                uDto.TempEmpOut            = uDto.TempEmpOut == "" ? null : uDto.TempEmpOut;
                uDto.InmateLeftEarly       = uDto.InmateLeftEarly == "" ? null : uDto.InmateLeftEarly;
                uDto.FinishedKill          = uDto.FinishedKill == "" ? null : uDto.FinishedKill;
                uDto.FinishedFillet        = uDto.FinishedFillet == "" ? null : uDto.FinishedFillet;
                uDto.FinishedSkinning      = uDto.FinishedSkinning == "" ? null : uDto.FinishedSkinning;
                uDto.DayFinishedFreezing   = uDto.DayFinishedFreezing == "" ? null : uDto.DayFinishedFreezing;
                uDto.NightFinishedFreezing = uDto.NightFinishedFreezing == "" ? null : uDto.NightFinishedFreezing;
                uDto.DayShiftFroze         = uDto.DayShiftFroze == "" ? null : uDto.DayShiftFroze;
                uDto.NightShiftFroze       = uDto.NightShiftFroze == "" ? null : uDto.NightShiftFroze;
                uDto.FilletScaleReading    = uDto.FilletScaleReading == "" ? null : uDto.FilletScaleReading;
                uDto.DowntimeMinutes       = uDto.DowntimeMinutes == "" ? null : uDto.DowntimeMinutes;
                uDto.InLateOut             = uDto.InLateOut == "" ? null : uDto.InLateOut;
                uDto.EmployeesOnVacation   = uDto.EmployeesOnVacation == "" ? null : uDto.EmployeesOnVacation;
                var errors = ValidateDtoData(uDto, ShiftEnd);
                if (errors.Any())
                {
                    return(ProcessValidationErrors(Request, errors, key));
                }
                var NEUserId = 0;
                if (int.TryParse(uDto.ShiftEndID, out NEUserId))
                {
                    if (NEUserId == -1)
                    {
                        //  creating new User record
                        return(ProcessNewShiftEndRecord(Request, uDto, key, ShiftEndId, userId));
                    }
                    else
                    {
                        //  editing existing User record
                        return(ProcessExistingShiftEndRecord(Request, uDto, NEUserId, key, ShiftEndId, userId));
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return(Request.CreateResponse(HttpStatusCode.BadRequest, msg));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
Exemplo n.º 8
0
        public HttpResponseMessage WeekDataAddOrEdit([FromBody] WeekDataDTO uDto)
        {
            string key;
            var    ur        = new AppUserRepository();
            var    AbsenceId = 0;
            var    userId    = ur.ValidateUser(uDto.Key, out key, ref AbsenceId);

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (userId > 0)
            {
                var wer         = new AD_WeekDataRepository();
                var WeekEndDate = DateTime.Parse(uDto.AD_WeekEnd);

                var data = wer.GetByDate(WeekEndDate);
                if (data.Count == 0)
                {
                    var prodData = wer.GetAllProducts();
                    foreach (var prod in prodData)
                    {
                        var wkData = new AD_WeekData();
                        wkData.AD_ProductID = prod;
                        wkData.AD_WeekEnd   = WeekEndDate;
                        wer.Save(wkData);
                    }
                    data = wer.GetByDate(WeekEndDate);
                }
                var col = new Collection <Dictionary <string, string> >();
                data = data.OrderBy(x => x.AD_Products.AD_GroupID).ToList();

                foreach (var wd in data)
                {
                    var dic = new Dictionary <string, string>();
                    dic.Add("AD_ProductID", wd.AD_ProductID.ToString());
                    dic.Add("ProductName", wd.AD_Products.AD_ProductName);
                    dic.Add("BudgetLbs", wd.AD_BudgetLbs != null ? wd.AD_BudgetLbs.ToString() : "0");
                    dic.Add("BudgetDollars", wd.AD_BudgetDollars != null ? wd.AD_BudgetDollars.ToString() : "0");
                    dic.Add("ActualLbs", wd.AD_ActualLbs != null ? wd.AD_ActualLbs.ToString() : "0");
                    dic.Add("ActualDollars", wd.AD_ActualDollars != null ? wd.AD_ActualDollars.ToString() : "0");
                    dic.Add("AD_WeekDataID", wd.AD_WeekDataID.ToString());
                    col.Add(dic);
                }
                var retVal = new GenericDTO
                {
                    Key        = key,
                    ReturnData = col
                };
                return(Request.CreateResponse(HttpStatusCode.OK, retVal));
            }



            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
Exemplo n.º 9
0
        private HttpResponseMessage ProcessExistingUserRecord(HttpRequestMessage request, UserDTO cqDto, int contactId, string key, int companyId, int userId)
        {
            var ur = new UserRepository();
            //var userRepository = new AppUserRepository();
            var user = new User();

            user = ur.GetById(contactId);
            //int? companyIdx = -1;
            //  is the user eligible to update the prospect?
            bool newfromsetup;

            if (cqDto.CompanyId == null)
            {
                cqDto.CompanyId = companyId.ToString();
                newfromsetup    = false;
            }
            else
            {
                newfromsetup = true;
            }

            var validationErrors = GetValidationErrors(ur, user, cqDto, companyId, userId);

            if (validationErrors.Any())
            {
                return(ProcessValidationErrors(request, validationErrors, key));
            }
            //  no validation errors...
            //if (cqDto.Password != "sg")
            //{
            //    user.Password = SecurityUtils.GetBinaryPassword(cqDto.Password.ToString());
            //}
            //else
            //{
            //    SGApp.Models.EF.User userexist = userRepository.GetUser(cqDto.EmailAddress, SecurityUtils.GetBinaryPassword(cqDto.Password), ref companyIdx);
            //    user.Password = userexist.Password;
            //}

            ur.Save(user);
            if (newfromsetup)
            {
                var rr    = new RoleRepository();
                var roles = rr.GetRoles();
                foreach (Role role in roles)
                {
                    var aur   = new AppUserRoleRepository();
                    var urole = new UserRole();
                    //ur = aur.GetByUserAndRoleIds(contactId, int.Parse(cqDto.RoleID));
                    urole.UserId = user.UserId;
                    urole.RoleId = role.RoleId;
                    aur.Save(urole);
                }
            }
            cqDto.Key = key;
            return(request.CreateResponse(HttpStatusCode.Accepted, cqDto));
        }
Exemplo n.º 10
0
        private HttpResponseMessage RemoveUserRole(HttpRequestMessage request, UserRoleDTO cqDto, int contactId, string key, int companyId, int userId)
        {
            var aur = new AppUserRoleRepository();
            var ur  = new UserRole();

            ur = aur.GetByUserAndRoleIds(contactId, int.Parse(cqDto.RoleID));
            aur.Delete(ur);
            cqDto.Key = key;
            return(request.CreateResponse(HttpStatusCode.Accepted, cqDto));
        }
Exemplo n.º 11
0
        public HttpResponseMessage O2AddOrEdit([FromBody] O2ReadingDTO uDto)
        {
            string key;
            var    ur        = new AppUserRepository();
            var    companyId = 0;
            var    UserId    = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (UserId > 0 && aur.IsInRole(UserId, "Airtime"))
            {
                var thisuser    = ur.GetById(UserId);
                var pr          = new PondRepository();
                int thisfarm    = pr.GetById(int.Parse(uDto.PondId)).FarmId;
                int UsersFarmId = thisuser.UserFarms.Where(x => x.FarmId == thisfarm).SingleOrDefault().UserFarmId;
                uDto.UsersFarmId = UsersFarmId.ToString();
                string dayperiod;
                if (DateTime.Parse(uDto.ReadingDate).Hour < 12)
                {
                    dayperiod = DateTime.Parse(uDto.ReadingDate).AddDays(-1).ToShortDateString();
                }
                else
                {
                    dayperiod = DateTime.Parse(uDto.ReadingDate).ToShortDateString();
                }
                uDto.DayPeriod = dayperiod;
                var Pond   = new Pond();
                var errors = ValidateDtoData(uDto, Pond);
                if (errors.Any())
                {
                    return(ProcessValidationErrors(Request, errors, key));
                }
                var NEReadingId = 0;
                if (int.TryParse(uDto.ReadingId, out NEReadingId))
                {
                    if (NEReadingId == -1)
                    {
                        //  creating new Pond record
                        return(ProcessNewO2Record(Request, uDto, key, companyId, UserId));
                    }
                    else
                    {
                        //  editing existing Pond record
                        return(ProcessExistingO2Record(Request, uDto, NEReadingId, key, companyId, UserId));
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return(Request.CreateResponse(HttpStatusCode.BadRequest, msg));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
        public HttpResponseMessage ShiftEndAddOrEdit([FromBody] ShiftEndDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var ShiftEndId = 0;
            var userId = ur.ValidateUser(uDto.Key, out key, ref ShiftEndId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (userId > 0 && aur.IsInRole(userId, "Data Entry"))
            {
                var ShiftEnd = new ShiftEnd();
                uDto.DayFinishedFreezing = uDto.DayFinishedFreezing == "" ? null : uDto.DayFinishedFreezing;
                uDto.RegEmpLate = uDto.RegEmpLate == "" ? null : uDto.RegEmpLate;
                uDto.RegEmpOut = uDto.RegEmpOut == "" ? null : uDto.RegEmpOut;
                uDto.RegEmplLeftEarly = uDto.RegEmplLeftEarly == "" ? null : uDto.RegEmplLeftEarly;
                uDto.TempEmpOut = uDto.TempEmpOut == "" ? null : uDto.TempEmpOut;
                uDto.InmateLeftEarly = uDto.InmateLeftEarly == "" ? null : uDto.InmateLeftEarly;
                uDto.FinishedKill = uDto.FinishedKill == "" ? null : uDto.FinishedKill;
                uDto.FinishedFillet = uDto.FinishedFillet == "" ? null : uDto.FinishedFillet;
                uDto.FinishedSkinning = uDto.FinishedSkinning == "" ? null : uDto.FinishedSkinning;
                uDto.DayFinishedFreezing = uDto.DayFinishedFreezing == "" ? null : uDto.DayFinishedFreezing;
                uDto.NightFinishedFreezing = uDto.NightFinishedFreezing == "" ? null : uDto.NightFinishedFreezing;
                uDto.DayShiftFroze = uDto.DayShiftFroze == "" ? null : uDto.DayShiftFroze;
                uDto.NightShiftFroze = uDto.NightShiftFroze == "" ? null : uDto.NightShiftFroze;
                uDto.FilletScaleReading = uDto.FilletScaleReading == "" ? null : uDto.FilletScaleReading;
                uDto.DowntimeMinutes = uDto.DowntimeMinutes == "" ? null : uDto.DowntimeMinutes;
                uDto.InLateOut = uDto.InLateOut == "" ? null : uDto.InLateOut;
                uDto.EmployeesOnVacation = uDto.EmployeesOnVacation == "" ? null : uDto.EmployeesOnVacation;
                var errors = ValidateDtoData(uDto, ShiftEnd);
                if (errors.Any())
                {
                    return ProcessValidationErrors(Request, errors, key);
                }
                var NEUserId = 0;
                if (int.TryParse(uDto.ShiftEndID, out NEUserId))
                {
                    if (NEUserId == -1)
                    {
                        //  creating new User record
                        return ProcessNewShiftEndRecord(Request, uDto, key, ShiftEndId, userId);
                    }
                    else
                    {
                        //  editing existing User record
                        return ProcessExistingShiftEndRecord(Request, uDto, NEUserId, key, ShiftEndId, userId);
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return Request.CreateResponse(HttpStatusCode.BadRequest, msg);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
Exemplo n.º 13
0
        public HttpResponseMessage ValidateLogin([FromBody] LoginDTO data)
        {
            var userName = data.UserName;
            var password = data.Password;

            var userDomain = new AppUserDomain();
            //Validate if user exist in the system
            int?companyId = -1;

            if (userDomain.ValidateLogin(userName, password, ref companyId))
            {
                //Create repositories
                var userRepository = new AppUserRepository();
                var roleRepository = new AppUserRoleRepository();

                //Get user
                SGApp.Models.EF.User user = userRepository.GetUser(userName, SecurityUtils.GetBinaryPassword(password), ref companyId);


                //Get user roles
                IList <SGApp.Models.EF.UserRole> userRoles = roleRepository.GetUserRoles(user.UserId);

                var dic = new List <Dictionary <string, string> >();
                foreach (var item in userRoles)
                {
                    var d = new Dictionary <string, string>();
                    d.Add("RoleID", item.RoleId.ToString());
                    d.Add("RoleDescription", item.Role.RoleName);
                    dic.Add(d);
                }
                int compid = (int)companyId;
                var retVal = new KeyDTO {
                    UserID    = user.UserId.ToString(),
                    CompanyId = user.CompanyId.ToString(),
                    UserRoles = dic,
                    Key       = SecurityUtils.CreateUserSecurityKey(userName, password, compid)/*,
                                                                                                * UserRoles = userRoles*/
                };
                return(Request.CreateResponse(HttpStatusCode.OK, retVal));
                //return Request.CreateResponse(HttpStatusCode.OK, JsonConvert.SerializeObject(
                //            retVal,
                //            Formatting.Indented,
                //            new JsonSerializerSettings() {
                //                PreserveReferencesHandling = PreserveReferencesHandling.Objects,
                //                ReferenceLoopHandling = ReferenceLoopHandling.Serialize
                //            }
                //        ));
            }
            else
            {
                var message = "Invalid user name and/or password";
                return(Request.CreateResponse(HttpStatusCode.NotFound, message));
            }
        }
Exemplo n.º 14
0
        public HttpResponseMessage PondO2ByDate([FromBody] O2ReadingDTO uDto)
        {
            string key;
            var    ur        = new AppUserRepository();
            var    companyId = 0;
            var    UserId    = ur.ValidateUser(uDto.Key, out key, ref companyId);
            //string dayperiod;
            //if (DateTime.Parse(uDto.ReadingDate).Hour < 12)
            //{
            //    dayperiod = DateTime.Parse(uDto.ReadingDate).AddDays(-1).ToShortDateString();
            //}
            //else
            //{
            //    dayperiod = DateTime.Parse(uDto.ReadingDate).ToShortDateString();
            //}
            //uDto.DayPeriod = dayperiod;

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (UserId > 0 && aur.IsInRole(UserId, "Airtime"))
            {
                var O2r = new O2ReadingRepository();
                var u   = new O2Reading();
                //var predicate = O2r.GetPredicate(uDto, u, companyId);
                var data = O2r.GetPondO2ReadingsByDate(int.Parse(uDto.PondId), DateTime.Parse(uDto.ReadingDate));
                var col  = new Collection <Dictionary <string, string> >();

                foreach (var item in data)
                {
                    var dic = new Dictionary <string, string>();

                    dic.Add("PondId", item.PondId.ToString());
                    dic.Add("ReadingId", item.ReadingId.ToString());
                    dic.Add("ReadingDate", item.ReadingDate.ToString());
                    dic.Add("O2Level", item.O2Level.ToString());
                    dic.Add("StaticCount", item.StaticCount.ToString());
                    dic.Add("PortableCount", item.PortableCount.ToString());
                    dic.Add("Note", item.Note);
                    dic.Add("PondStatus", item.Pond.HealthStatus.ToString());
                    col.Add(dic);
                }

                var retVal = new GenericDTO
                {
                    Key        = key,
                    ReturnData = col
                };
                return(Request.CreateResponse(HttpStatusCode.OK, retVal));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
        public HttpResponseMessage AbsenceAddOrEdit([FromBody] AbsenceDTO uDto)
        {
            string key;
            var    ur        = new AppUserRepository();
            var    AbsenceId = 0;
            var    userId    = ur.ValidateUser(uDto.Key, out key, ref AbsenceId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            uDto.RegEmpLate          = uDto.RegEmpLate == "" ? null : uDto.RegEmpLate;
            uDto.RegEmpLeftEarly     = uDto.RegEmpLeftEarly == "" ? null : uDto.RegEmpLeftEarly;
            uDto.RegEmpOut           = uDto.RegEmpOut == "" ? null : uDto.RegEmpOut;
            uDto.TempEmpLate         = uDto.TempEmpLate == "" ? null : uDto.TempEmpLate;
            uDto.TempEmpLeftEarly    = uDto.TempEmpLeftEarly == "" ? null : uDto.TempEmpLeftEarly;
            uDto.TempEmpOut          = uDto.TempEmpOut == "" ? null : uDto.TempEmpOut;
            uDto.InmateLeftEarly     = uDto.InmateLeftEarly == "" ? null : uDto.InmateLeftEarly;
            uDto.InmateOut           = uDto.InmateOut == "" ? null : uDto.InmateOut;
            uDto.EmployeesOnVacation = uDto.EmployeesOnVacation == "" ? null : uDto.EmployeesOnVacation;

            if (userId > 0 && aur.IsInRole(userId, "Data Entry"))
            {
                var Absence = new Absence();
                var errors  = ValidateDtoData(uDto, Absence);
                if (errors.Any())
                {
                    return(ProcessValidationErrors(Request, errors, key));
                }
                var NEUserId = 0;


                if (int.TryParse(uDto.AbsenceID, out NEUserId))
                {
                    if (NEUserId == -1)
                    {
                        //  creating new User record
                        return(ProcessNewAbsenceRecord(Request, uDto, key, AbsenceId, userId));
                    }
                    else
                    {
                        //  editing existing User record
                        return(ProcessExistingAbsenceRecord(Request, uDto, NEUserId, key, AbsenceId, userId));
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return(Request.CreateResponse(HttpStatusCode.BadRequest, msg));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
        public HttpResponseMessage WeighBackAddOrEdit([FromBody] WeighBackDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var WeighBackId = 0;
            var userId = ur.ValidateUser(uDto.Key, out key, ref WeighBackId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (userId > 0 && aur.IsInRole(userId, "Data Entry"))
            {
                var WeighBack = new WeighBack();
                var errors = ValidateDtoData(uDto, WeighBack);
                if (errors.Any())
                {
                    return ProcessValidationErrors(Request, errors, key);
                }
                var NEUserId = 0;
                uDto.Turtle = uDto.Turtle == "" ? null : uDto.Turtle;
                uDto.Trash = uDto.Trash == "" ? null : uDto.Trash;
                uDto.Shad = uDto.Shad == "" ? null : uDto.Shad;
                uDto.Carp = uDto.Carp == "" ? null : uDto.Carp;
                uDto.Bream = uDto.Bream == "" ? null : uDto.Bream;
                uDto.LiveDisease = uDto.LiveDisease == "" ? null : uDto.LiveDisease;
                uDto.DressedDisease = uDto.DressedDisease == "" ? null : uDto.DressedDisease;
                uDto.Backs = uDto.Backs == "" ? null : uDto.Backs;
                uDto.RedFillet = uDto.RedFillet == "" ? null : uDto.RedFillet;
                uDto.BigFish = uDto.BigFish == "" ? null : uDto.BigFish;
                uDto.DOAs = uDto.DOAs == "" ? null : uDto.DOAs;
                uDto.DressedDiseasePct = ".6";
                uDto.RedFilletPct = ".36";
                if (int.TryParse(uDto.WeightBackID, out NEUserId))
                {
                    if (NEUserId == -1)
                    {
                        //  creating new User record
                        return ProcessNewWeighBackRecord(Request, uDto, key, WeighBackId, userId);
                    }
                    else
                    {
                        //  editing existing User record
                        return ProcessExistingWeighBackRecord(Request, uDto, NEUserId, key, WeighBackId, userId);
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return Request.CreateResponse(HttpStatusCode.BadRequest, msg);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
        public List <FunctionalityType> GetPermissions(int userId)
        {
            List <FunctionalityType> result;

            if (AppUserRoleRepository.CheckIfIsAdmin(userId))
            {
                result = EnumHelpers.GetEnumList <FunctionalityType>();
            }
            else
            {
                result = AppUserRoleRepository.GetUserFunctionalities(userId);
            }
            return(result);
        }
        public void AddUserToRole(int userId, int roleId)
        {
            if (IsUserInRole(userId, roleId))
            {
                return;
            }
            AppUserRole crmUserRole = new AppUserRole()
            {
                AppUserId = userId,
                AppRoleId = roleId
            };

            AppUserRoleRepository.Add(crmUserRole);
        }
        public HttpResponseMessage ValidateLogin([FromBody] LoginDTO data)
        {
            var userName = data.UserName;
            var password = data.Password;

            var userDomain = new AppUserDomain();
            //Validate if user exist in the system
            int? companyId = -1;
            if (userDomain.ValidateLogin(userName, password, ref companyId)) {

                //Create repositories
                var userRepository = new AppUserRepository();
                var roleRepository = new AppUserRoleRepository();

                //Get user
                SGApp.Models.EF.User user = userRepository.GetUser(userName, SecurityUtils.GetBinaryPassword(password), ref companyId);

                //Get user roles
                IList<SGApp.Models.EF.UserRole> userRoles = roleRepository.GetUserRoles(user.UserId);

                var dic = new List<Dictionary<string, string>>();
                foreach (var item in userRoles) {
                    var d = new Dictionary<string, string>();
                    d.Add("RoleID", item.RoleId.ToString());
                    d.Add("RoleDescription", item.Role.RoleName);
                    dic.Add(d);
                }
                int compid = (int)companyId;
                var retVal = new KeyDTO {
                    UserID = user.UserId.ToString(),
                    CompanyId = user.CompanyId.ToString(),
                    UserRoles = dic,
                    Key = SecurityUtils.CreateUserSecurityKey(userName, password, compid)/*,
                    UserRoles = userRoles*/
                };
                return Request.CreateResponse(HttpStatusCode.OK, retVal);
                //return Request.CreateResponse(HttpStatusCode.OK, JsonConvert.SerializeObject(
                //            retVal,
                //            Formatting.Indented,
                //            new JsonSerializerSettings() {
                //                PreserveReferencesHandling = PreserveReferencesHandling.Objects,
                //                ReferenceLoopHandling = ReferenceLoopHandling.Serialize
                //            }
                //        ));
            } else {
                var message = "Invalid user name and/or password";
                return Request.CreateResponse(HttpStatusCode.NotFound, message);
            }
        }
        public HttpResponseMessage AbsenceAddOrEdit([FromBody] AbsenceDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var AbsenceId = 0;
            var userId = ur.ValidateUser(uDto.Key, out key, ref AbsenceId);

            AppUserRoleRepository aur = new AppUserRoleRepository();
            uDto.RegEmpLate = uDto.RegEmpLate == "" ? null : uDto.RegEmpLate;
            uDto.RegEmpLeftEarly = uDto.RegEmpLeftEarly == "" ? null : uDto.RegEmpLeftEarly;
            uDto.RegEmpOut = uDto.RegEmpOut == "" ? null : uDto.RegEmpOut;
            uDto.TempEmpLate = uDto.TempEmpLate == "" ? null : uDto.TempEmpLate;
            uDto.TempEmpLeftEarly = uDto.TempEmpLeftEarly == "" ? null : uDto.TempEmpLeftEarly;
            uDto.TempEmpOut = uDto.TempEmpOut == "" ? null : uDto.TempEmpOut;
            uDto.InmateLeftEarly = uDto.InmateLeftEarly == "" ? null : uDto.InmateLeftEarly;
            uDto.InmateOut = uDto.InmateOut == "" ? null : uDto.InmateOut;
            uDto.EmployeesOnVacation = uDto.EmployeesOnVacation == "" ? null : uDto.EmployeesOnVacation;

            if (userId > 0 && aur.IsInRole(userId, "Data Entry"))
            {
                var Absence = new Absence();
                var errors = ValidateDtoData(uDto, Absence);
                if (errors.Any())
                {
                    return ProcessValidationErrors(Request, errors, key);
                }
                var NEUserId = 0;

                if (int.TryParse(uDto.AbsenceID, out NEUserId))
                {
                    if (NEUserId == -1)
                    {
                        //  creating new User record
                        return ProcessNewAbsenceRecord(Request, uDto, key, AbsenceId, userId);
                    }
                    else
                    {
                        //  editing existing User record
                        return ProcessExistingAbsenceRecord(Request, uDto, NEUserId, key, AbsenceId, userId);
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return Request.CreateResponse(HttpStatusCode.BadRequest, msg);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
Exemplo n.º 21
0
        public HttpResponseMessage FeedAddOrEdit([FromBody] FeedingDTO uDto)
        {
            string key;
            var    ur        = new AppUserRepository();
            var    companyId = 0;
            var    UserId    = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (UserId > 0 && aur.IsInRole(UserId, "Chowtime"))
            {
                var thisuser    = ur.GetById(UserId);
                var pr          = new PondRepository();
                int thisfarm    = pr.GetById(int.Parse(uDto.PondId)).FarmId;
                int UsersFarmId = thisuser.UserFarms.Where(x => x.FarmId == thisfarm).SingleOrDefault().UserFarmId;
                uDto.UsersFarmId = UsersFarmId.ToString();
                uDto.FarmID      = thisfarm;

                var feed   = new Feeding();
                var errors = ValidateDtoData(uDto, feed);
                if (errors.Any())
                {
                    return(ProcessValidationErrors(Request, errors, key));
                }
                var NEFeedingId = 0;
                if (int.TryParse(uDto.FeedingId, out NEFeedingId))
                {
                    if (NEFeedingId == -1)
                    {
                        //  creating new Feeding record
                        return(ProcessNewFeedRecord(Request, uDto, key, companyId, UserId));
                    }
                    else
                    {
                        //  editing existing Feeding record
                        return(ProcessExistingFeedRecord(Request, uDto, NEFeedingId, key, companyId, UserId));
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return(Request.CreateResponse(HttpStatusCode.BadRequest, msg));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
Exemplo n.º 22
0
        public void Delete(int id)
        {
            AppUser appUser = AppUserRepository.GetSingle(x => x.Id == id);

            if (appUser == null)
            {
                throw new BussinesException(1002, ErrorResource.NoData);
            }
            AppUserRole appUserRole = AppUserRoleRepository.GetSingle(x => x.AppUserId == id);

            if (appUserRole == null)
            {
                throw new BussinesException(1003, ErrorResource.NoData);
            }
            AppUserRoleRepository.Delete(appUserRole);
            AppUserRepository.Delete(appUser);
        }
Exemplo n.º 23
0
        public HttpResponseMessage PondFeedLast7Days([FromBody] PondDTO uDto)
        {
            string key;
            var    ur        = new AppUserRepository();
            var    companyId = 0;
            var    UserId    = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (UserId > 0 && aur.IsInRole(UserId, "Chowtime"))
            {
                var      pr        = new PondRepository();
                var      ponddata  = pr.GetById(int.Parse(uDto.PondId));
                DateTime startdate = DateTime.Now;

                int i   = 0;
                var col = new Collection <Dictionary <string, string> >();
                while (i > -7)
                {
                    var fr   = new FeedingRepository();
                    var data = fr.GetPondFeedingsByDate(ponddata.PondId, startdate.AddDays(i));
                    if (data != null)
                    {
                        var dic = new Dictionary <string, string>();

                        dic.Add("PondId", data.PondId.ToString());
                        dic.Add("FeedingId", data.FeedingId.ToString());
                        dic.Add("FeedDate", data.FeedDate.ToString());
                        dic.Add("PoundsFed", data.PoundsFed.ToString());
                        col.Add(dic);
                    }

                    i--;
                }
                var retVal = new GenericDTO
                {
                    Key        = key,
                    ReturnData = col
                };
                return(Request.CreateResponse(HttpStatusCode.OK, retVal));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
        public HttpResponseMessage FeedAddOrEdit([FromBody] FeedingDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var companyId = 0;
            var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (UserId > 0 && aur.IsInRole(UserId, "Chowtime"))
            {
                var thisuser = ur.GetById(UserId);
                var pr = new PondRepository();
                int thisfarm = pr.GetById(int.Parse(uDto.PondId)).FarmId;
                int UsersFarmId = thisuser.UserFarms.Where(x => x.FarmId == thisfarm).SingleOrDefault().UserFarmId;
                uDto.UsersFarmId = UsersFarmId.ToString();

                var feed = new Feeding();
                var errors = ValidateDtoData(uDto, feed);
                if (errors.Any())
                {
                    return ProcessValidationErrors(Request, errors, key);
                }
                var NEFeedingId = 0;
                if (int.TryParse(uDto.FeedingId, out NEFeedingId))
                {
                    if (NEFeedingId == -1)
                    {
                        //  creating new Pond record
                        return ProcessNewFeedRecord(Request, uDto, key, companyId, UserId);
                    }
                    else
                    {
                        //  editing existing Pond record
                        return ProcessExistingFeedRecord(Request, uDto, NEFeedingId, key, companyId, UserId);
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return Request.CreateResponse(HttpStatusCode.BadRequest, msg);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
        public HttpResponseMessage FarmYieldAddOrEdit([FromBody] FarmYieldDTO uDto)
        {
            string key;
            var    ur          = new AppUserRepository();
            var    FarmYieldId = 0;
            var    userId      = ur.ValidateUser(uDto.Key, out key, ref FarmYieldId);

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (userId > 0 && aur.IsInRole(userId, "Data Entry"))
            {
                var FarmYield = new FarmYield();
                var errors    = ValidateDtoData(uDto, FarmYield);
                if (errors.Any())
                {
                    return(ProcessValidationErrors(Request, errors, key));
                }
                var NEUserId = 0;
                uDto.PercentYield  = uDto.PercentYield == "" ? null : uDto.PercentYield;
                uDto.PercentYield2 = uDto.PercentYield2 == "" ? null : uDto.PercentYield2;
                uDto.PoundsHeaded  = uDto.PoundsHeaded == "" ? null : uDto.PoundsHeaded;
                uDto.PoundsYielded = uDto.PoundsYielded == "" ? "0" : uDto.PoundsYielded;
                if (int.TryParse(uDto.YieldID, out NEUserId))
                {
                    if (NEUserId == -1)
                    {
                        //  creating new User record
                        return(ProcessNewFarmYieldRecord(Request, uDto, key, FarmYieldId, userId));
                    }
                    else
                    {
                        //  editing existing User record
                        return(ProcessExistingFarmYieldRecord(Request, uDto, NEUserId, key, FarmYieldId, userId));
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return(Request.CreateResponse(HttpStatusCode.BadRequest, msg));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
Exemplo n.º 26
0
        public HttpResponseMessage DownTimeAddOrEdit([FromBody] DownTimeDTO uDto)
        {
            string key;
            var    ur         = new AppUserRepository();
            var    DownTimeId = 0;
            var    userId     = ur.ValidateUser(uDto.Key, out key, ref DownTimeId);

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (userId > 0 && aur.IsInRole(userId, "Data Entry"))
            {
                var DownTime = new DownTime();
                var errors   = ValidateDtoData(uDto, DownTime);
                if (errors.Any())
                {
                    return(ProcessValidationErrors(Request, errors, key));
                }
                var NEUserId = 0;
                uDto.DownTimeNote = uDto.DownTimeNote == "" ? null : uDto.DownTimeNote;
                uDto.Minutes      = uDto.Minutes == "" ? null : uDto.Minutes;

                if (int.TryParse(uDto.DownTimeID, out NEUserId))
                {
                    if (NEUserId == -1)
                    {
                        //  creating new User record
                        return(ProcessNewDownTimeRecord(Request, uDto, key, DownTimeId, userId));
                    }
                    else
                    {
                        //  editing existing User record
                        return(ProcessExistingDownTimeRecord(Request, uDto, NEUserId, key, DownTimeId, userId));
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return(Request.CreateResponse(HttpStatusCode.BadRequest, msg));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
Exemplo n.º 27
0
        public HttpResponseMessage GetLastPondReading([FromBody] O2ReadingDTO uDto)
        {
            string key;
            var    ur        = new AppUserRepository();
            var    companyId = 0;
            var    UserId    = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (UserId > 0 && aur.IsInRole(UserId, "Airtime"))
            {
                var O2r = new O2ReadingRepository();
                var u   = new O2Reading();
                //var predicate = O2r.GetPredicate(uDto, u, companyId);
                var data = O2r.GetLastPondReadingByPond(int.Parse(uDto.PondId));
                var col  = new Collection <Dictionary <string, string> >();


                var dic = new Dictionary <string, string>();

                dic.Add("PondId", data.PondId.ToString());
                dic.Add("ReadingId", data.ReadingId.ToString());
                dic.Add("ReadingDate", data.ReadingDate.ToString());
                dic.Add("O2Level", data.O2Level.ToString());
                dic.Add("StaticCount", data.StaticCount.ToString());
                dic.Add("PortableCount", data.PortableCount.ToString());
                dic.Add("Note", data.Note);
                col.Add(dic);



                var retVal = new GenericDTO
                {
                    Key        = key,
                    ReturnData = col
                };
                return(Request.CreateResponse(HttpStatusCode.OK, retVal));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
        public HttpResponseMessage FarmYieldAddOrEdit([FromBody] FarmYieldDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var FarmYieldId = 0;
            var userId = ur.ValidateUser(uDto.Key, out key, ref FarmYieldId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (userId > 0 && aur.IsInRole(userId, "Data Entry"))
            {
                var FarmYield = new FarmYield();
                var errors = ValidateDtoData(uDto, FarmYield);
                if (errors.Any())
                {
                    return ProcessValidationErrors(Request, errors, key);
                }
                var NEUserId = 0;
                uDto.PercentYield = uDto.PercentYield == "" ? null : uDto.PercentYield;
                uDto.PercentYield2 = uDto.PercentYield2 == "" ? null : uDto.PercentYield2;
                uDto.PoundsHeaded = uDto.PoundsHeaded == "" ? null : uDto.PoundsHeaded;
                uDto.PoundsYielded = uDto.PoundsYielded == "" ? "0" : uDto.PoundsYielded;
                if (int.TryParse(uDto.YieldID, out NEUserId))
                {
                    if (NEUserId == -1)
                    {
                        //  creating new User record
                        return ProcessNewFarmYieldRecord(Request, uDto, key, FarmYieldId, userId);
                    }
                    else
                    {
                        //  editing existing User record
                        return ProcessExistingFarmYieldRecord(Request, uDto, NEUserId, key, FarmYieldId, userId);
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return Request.CreateResponse(HttpStatusCode.BadRequest, msg);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
        public HttpResponseMessage FilletScaleReadingAddOrEdit([FromBody] FilletScaleReadingDTO uDto)
        {
            string key;
            var    ur = new AppUserRepository();
            var    FilletScaleReadingId = 0;
            var    userId = ur.ValidateUser(uDto.Key, out key, ref FilletScaleReadingId);

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (userId > 0 && aur.IsInRole(userId, "Data Entry"))
            {
                var FilletScaleReading = new FilletScaleReading();
                var errors             = ValidateDtoData(uDto, FilletScaleReading);
                if (errors.Any())
                {
                    return(ProcessValidationErrors(Request, errors, key));
                }
                var NEUserId = 0;


                if (int.TryParse(uDto.FilletScaleReadingID, out NEUserId))
                {
                    if (NEUserId == -1)
                    {
                        //  creating new User record
                        return(ProcessNewFilletScaleReadingRecord(Request, uDto, key, FilletScaleReadingId, userId));
                    }
                    else
                    {
                        //  editing existing User record
                        return(ProcessExistingFilletScaleReadingRecord(Request, uDto, NEUserId, key, FilletScaleReadingId, userId));
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return(Request.CreateResponse(HttpStatusCode.BadRequest, msg));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
        public HttpResponseMessage PlantPondWeightAddOrEdit([FromBody] PlantPondWeightDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var PlantPondWeightId = 0;
            var userId = ur.ValidateUser(uDto.Key, out key, ref PlantPondWeightId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (userId > 0 && aur.IsInRole(userId, "Data Entry"))
            {
                var PlantPondWeight = new PlantPondWeight();
                var errors = ValidateDtoData(uDto, PlantPondWeight);
                if (errors.Any())
                {
                    return ProcessValidationErrors(Request, errors, key);
                }
                var NEUserId = 0;
                uDto.PlantWeight = uDto.PlantWeight == "" ? null : uDto.PlantWeight;
                uDto.PondWeight = uDto.PondWeight == "" ? null : uDto.PondWeight;

                if (int.TryParse(uDto.PlantPondWeightID, out NEUserId))
                {
                    if (NEUserId == -1)
                    {
                        //  creating new User record
                        return ProcessNewPlantPondWeightRecord(Request, uDto, key, PlantPondWeightId, userId);
                    }
                    else
                    {
                        //  editing existing User record
                        return ProcessExistingPlantPondWeightRecord(Request, uDto, NEUserId, key, PlantPondWeightId, userId);
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return Request.CreateResponse(HttpStatusCode.BadRequest, msg);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
        public HttpResponseMessage DeleteEmail([FromBody] EmailDTO uDto)
        {
            string key;
            var    ur      = new AppUserRepository();
            var    EmailId = 0;
            var    userId  = ur.ValidateUser(uDto.Key, out key, ref EmailId);

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (userId > 0 && aur.IsInRole(userId, "Admin"))
            {
                var Email  = new Email();
                var errors = ValidateDtoData(uDto, Email);
                if (errors.Any())
                {
                    return(ProcessValidationErrors(Request, errors, key));
                }
                var NEUserId = 0;
                if (int.TryParse(uDto.EmailID, out NEUserId))
                {
                    if (NEUserId == -1)
                    {
                        //  creating new User record
                        return(ProcessNewEmailRecord(Request, uDto, key, EmailId, userId));
                    }
                    else
                    {
                        //  editing existing User record
                        return(DeleteEmailRecord(Request, uDto, NEUserId, key, EmailId, userId));
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return(Request.CreateResponse(HttpStatusCode.BadRequest, msg));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
Exemplo n.º 32
0
        public HttpResponseMessage ChangeWeekDataProperty(HttpRequestMessage request, WeekDataDTO cqDTO)
        {
            string key;
            var    ur        = new AppUserRepository();
            var    CompanyId = 0;
            var    userId    = ur.ValidateUser(cqDTO.Key, out key, ref CompanyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (userId > 0)
            {
                var sor = new AD_WeekDataRepository();

                var data = sor.GetById(int.Parse(cqDTO.AD_WeekDataID));
                if (cqDTO.AD_BudgetLbs != null)
                {
                    data.AD_BudgetLbs = int.Parse(cqDTO.AD_BudgetLbs);
                }
                if (cqDTO.AD_BudgetDollars != null)
                {
                    data.AD_BudgetDollars = decimal.Parse(cqDTO.AD_BudgetDollars);
                }
                if (cqDTO.AD_ActualLbs != null)
                {
                    data.AD_ActualLbs = int.Parse(cqDTO.AD_ActualLbs);
                }

                if (cqDTO.AD_ActualDollars != null)
                {
                    data.AD_ActualDollars = decimal.Parse(cqDTO.AD_ActualDollars);
                }
                sor.Save(data);

                return(Request.CreateResponse(HttpStatusCode.OK, "Success"));
            }//}
            var message = "validation failed";

            return(request.CreateResponse(HttpStatusCode.NotFound, message));
        }
        public HttpResponseMessage FinishTimeAddOrEdit([FromBody] FinishTimeDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var FinishTimeId = 0;
            var userId = ur.ValidateUser(uDto.Key, out key, ref FinishTimeId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (userId > 0 && aur.IsInRole(userId, "Data Entry"))
            {
                var FinishTime = new FinishTime();
                var errors = ValidateDtoData(uDto, FinishTime);
                if (errors.Any())
                {
                    return ProcessValidationErrors(Request, errors, key);
                }
                var NEUserId = 0;

                uDto.FinishDateTime = uDto.FinishDateTime + " " + uDto.FinishTime;
                if (int.TryParse(uDto.FinishTimeID, out NEUserId))
                {
                    if (NEUserId == -1)
                    {
                        //  creating new User record
                        return ProcessNewFinishTimeRecord(Request, uDto, key, FinishTimeId, userId);
                    }
                    else
                    {
                        //  editing existing User record
                        return ProcessExistingFinishTimeRecord(Request, uDto, NEUserId, key, FinishTimeId, userId);
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return Request.CreateResponse(HttpStatusCode.BadRequest, msg);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
        public HttpResponseMessage EmailAddOrEdit([FromBody] EmailDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var EmailId = 0;
            var userId = ur.ValidateUser(uDto.Key, out key, ref EmailId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (userId > 0 && aur.IsInRole(userId, "Admin"))
            {
                var Email = new Email();
                var errors = ValidateDtoData(uDto, Email);
                if (errors.Any())
                {
                    return ProcessValidationErrors(Request, errors, key);
                }
                var NEUserId = 0;
                if (int.TryParse(uDto.EmailID, out NEUserId))
                {
                    if (NEUserId == -1)
                    {
                        //  creating new User record
                        return ProcessNewEmailRecord(Request, uDto, key, EmailId, userId);
                    }
                    else
                    {
                        //  editing existing User record
                        return ProcessExistingEmailRecord(Request, uDto, NEUserId, key, EmailId, userId);
                    }
                }
                //  no idea what this is
                var msg = "invalid data structure submitted";
                return Request.CreateResponse(HttpStatusCode.BadRequest, msg);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
Exemplo n.º 35
0
        public void Add(AppUserAddVM model)
        {
            if (AppUserRepository.Any(x => x.Login == model.Login))
            {
                throw new BussinesException(1000, ErrorResource.UserAlreadyAdded);
            }
            Language language = LanguageRepository.GetSingle(x => x.CultureSymbol == "pl-PL");
            AppUser  user     = new AppUser()
            {
                CreatedById = MainContext.PersonId,
                CreatedDate = DateTime.Now,
                IsActive    = model.IsActive,
                LastName    = model.LastName,
                FirstName   = model.FirstName,
                Login       = model.Login,
                LanguageId  = language.Id,
            };

            AppUserRepository.Add(user);
            AppUserRepository.Save();

            if (model.Role == AppRoleType.Administrator)
            {
                AppRole admin = AppRoleRepository.GetSingle(x => x.AppRoleType == AppRoleType.Administrator);
                if (admin == null)
                {
                    admin = AppRoleService.AddRole(AppRoleType.Administrator, "Administratorzy", "Grupa administratorów systemu");
                }
                AppUserRole appUserRole = new AppUserRole()
                {
                    AppRoleId = admin.Id,
                    AppUserId = user.Id,
                };
                AppUserRoleRepository.Add(appUserRole);
            }
            AppUserRoleRepository.Save();
        }
Exemplo n.º 36
0
        public HttpResponseMessage MortalityById([FromBody] MortalityDTO uDto)
        {
            string key;
            var    ur                 = new AppUserRepository();
            var    companyId          = 0;
            var    UserId             = ur.ValidateUser(uDto.Key, out key, ref companyId);
            AppUserRoleRepository aur = new AppUserRoleRepository();


            if (UserId > 0 && aur.IsInRole(UserId, "Chowtime"))
            {
                var O2r  = new AppEntities();
                var data = O2r.Mortalities.Find(int.Parse(uDto.MortalityId));
                var col  = new Collection <Dictionary <string, string> >();


                var dic = new Dictionary <string, string>();

                dic.Add("PondId", data.PondId.ToString());
                dic.Add("MortalityId", data.MortalityId.ToString());
                dic.Add("MortalityDate", data.MortalityDate.ToString());
                dic.Add("MortalityPoundsd", data.MortalityPounds.ToString());
                col.Add(dic);


                var retVal = new GenericDTO
                {
                    Key        = key,
                    ReturnData = col
                };
                return(Request.CreateResponse(HttpStatusCode.OK, retVal));
            }
            var message = "validation failed";

            return(Request.CreateResponse(HttpStatusCode.NotFound, message));
        }
Exemplo n.º 37
0
        public void Edit(AppUserEditVM model)
        {
            AppUser appUser = AppUserRepository.GetSingle(x => x.Id == model.Id);

            if (appUser == null)
            {
                throw new BussinesException(1001, ErrorResource.NoData);
            }
            appUser = AppUserConverter.FromAppUserEditVM(model, appUser);
            AppUserRepository.Edit(appUser);


            AppRole appRole = AppRoleRepository.GetSingle(x => x.AppRoleType == model.Role);

            if (appRole == null)
            {
                if (model.Role == AppRoleType.Administrator)
                {
                    appRole = AppRoleService.AddRole(AppRoleType.Administrator, "Administratorzy", "Grupa administratorów systemu");
                }
            }
            AppUserRole appUserRole = AppUserRoleRepository.GetSingle(x => x.AppUserId == model.Id);

            if (appUserRole == null)
            {
                appUserRole = new AppUserRole()
                {
                    AppRoleId = appRole.Id,
                    AppUserId = appUser.Id
                };
                AppUserRoleRepository.Add(appUserRole);
                AppUserRoleRepository.Save();
            }
            appUserRole = AppUserRoleConverter.FromAppUserEditVM(appUserRole, appRole);
            AppUserRoleRepository.Edit(appUserRole);
        }
        public HttpResponseMessage FarmO2Last7Days([FromBody] FarmDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var companyId = 0;
            var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (UserId > 0 && aur.IsInRole(UserId, "Airtime"))
            {
                var pr = new PondRepository();
                var ponddata = pr.GetActivePondsForO2(int.Parse(uDto.FarmId));
                DateTime startdate = DateTime.Parse(uDto.CurrentTime);
                var pondcol = new Dictionary<string, Dictionary<string, Collection<Dictionary<string, string>>>>();
                foreach (Pond ponditem in ponddata)
                {
                    var datecol = new Dictionary<string, Collection<Dictionary<string, string>>>();

                        var O2r = new O2ReadingRepository();
                        var data = O2r.GetPondO2Readings7Days(ponditem.PondId, startdate);
                        var col = new Collection<Dictionary<string, string>>();
                        foreach (var item in data)
                        {

                            var dic = new Dictionary<string, string>();

                            dic.Add("PondId", item.PondId.ToString());
                            dic.Add("ReadingId", item.ReadingId.ToString());
                            dic.Add("ReadingDate", item.ReadingDate.ToString());
                            dic.Add("O2Level", item.O2Level.ToString());

                            col.Add(dic);

                        }
                        datecol.Add(startdate.ToShortDateString(), col);

                    pondcol.Add(ponditem.PondId.ToString(), datecol);
                }

                var retVal = new FarmO2DTO
                {
                    Key = key,
                    ReturnData = pondcol
                };
                return Request.CreateResponse(HttpStatusCode.OK, retVal);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
        public HttpResponseMessage FarmLast7Feeds([FromBody] FarmDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var companyId = 0;
            var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (UserId > 0 && aur.IsInRole(UserId, "Chowtime"))
            {
                var pr = new PondRepository();
                var ponddata = pr.GetActivePonds(int.Parse(uDto.FarmId));
                DateTime startdate = DateTime.Parse(uDto.CurrentTime);
                var pondcol = new Dictionary<string, Collection<Dictionary<string, string>>>();
                foreach (Pond ponditem in ponddata)
                {

                    var col = new Collection<Dictionary<string, string>>();

                        var fr = new FeedingRepository();
                        var data = fr.GetPondLast7Feedings(ponditem.PondId);
                        foreach (var item in data)
                        {

                            if (item != null)
                            {
                                var dic = new Dictionary<string, string>();

                                dic.Add("PondId", item.PondId.ToString());
                                dic.Add("FeedingId", item.FeedingId.ToString());
                                dic.Add("FeedDate", item.FeedDate.ToString());
                                dic.Add("PoundsFed", item.PoundsFed.ToString());
                                col.Add(dic);
                            }

                        }
                    pondcol.Add(ponditem.PondId.ToString(), col);
                }

                var retVal = new FarmFeedDTO
                {
                    Key = key,
                    ReturnData = pondcol
                };
                return Request.CreateResponse(HttpStatusCode.OK, retVal);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
        public HttpResponseMessage FarmFeedLast7FeedsTotals([FromBody] FarmDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var companyId = 0;
            var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (UserId > 0 && aur.IsInRole(UserId, "Chowtime"))
            {

                DateTime startdate = DateTime.Parse(uDto.CurrentTime);
                var fr = new FeedingRepository();
                var dates = fr.GetFarmFeedingsLast7Dates(int.Parse(uDto.FarmId));
                var col = new Collection<Dictionary<string, string>>();
                foreach (Feeding f in dates)
                {
                    var data = fr.GetFarmFeedingsByDate(int.Parse(uDto.FarmId), f.FeedDate);

                    if (data != null)
                    {
                        var dic = new Dictionary<string, string>();
                        int totalfeed = data.Sum(x => x.PoundsFed);
                        int totalfeedcount = data.Count();
                        if (totalfeedcount > 0)
                        {

                            decimal totalacres = data.Sum(x => x.Pond.Size);
                            decimal averagefeed = totalfeed / totalacres;
                            averagefeed = Math.Round(averagefeed, 0);
                            dic.Add("FeedDate", f.FeedDate.ToShortDateString());
                            dic.Add("TotalPoundsFed", totalfeed.ToString());
                            dic.Add("TotalFeeds", totalfeedcount.ToString());
                            dic.Add("AveragePoundsFed", averagefeed.ToString());
                            col.Add(dic);
                        }
                    }

                }

                var retVal = new GenericDTO
                {
                    Key = key,
                    ReturnData = col
                };
                return Request.CreateResponse(HttpStatusCode.OK, retVal);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
 public object GetUserRoles(DataSourceLoadOptionsBase loadOptions, int userId)
 {
     return(AppUserRoleRepository.GetUserRoles(loadOptions, userId));
 }
 public object GetRoleUsers(DataSourceLoadOptionsBase loadOptions, int roleId)
 {
     return(AppUserRoleRepository.GetRoleUsers(loadOptions, roleId));
 }
        private HttpResponseMessage ProcessNewUserRecord(HttpRequestMessage request, UserDTO uDto, string key, int companyId, int userId)
        {
            var ur = new UserRepository();

            //var userRepository = new AppUserRepository();
            var user = new User();
            bool newfromsetup;
            if (uDto.CompanyId == null)
            {
                uDto.CompanyId = companyId.ToString();
                newfromsetup = false;
            }
            else
            {
                newfromsetup = true;
            }
            //int? companyIdx = -1;
            if (ur.GetByEmail(uDto.EmailAddress) != null)
            {

                var msg = "Unable to add new user.  Email Address already Exists.";
                return Request.CreateResponse(HttpStatusCode.BadRequest, msg);
            }
            var validationErrors = GetValidationErrors(ur, user, uDto, companyId, userId);

            if (validationErrors.Any())
            {
                return ProcessValidationErrors(request, validationErrors, key);
            }
            //  no validation errors...
            //if (uDto.Password != "sg")
            //{
            //    user.Password = SecurityUtils.GetBinaryPassword(uDto.Password.ToString());
            //}
            //else
            //{
            //    SGApp.Models.EF.User userexist = userRepository.GetUser(uDto.EmailAddress, SecurityUtils.GetBinaryPassword(uDto.Password), ref companyIdx);
            //    user.Password = userexist.Password;
            //}
            //user.CompanyId = companyId;
            //user.UserId = null;
            user = ur.Save(user);
            if (newfromsetup)
            {
                var rr = new RoleRepository();
                var roles = rr.GetRoles();
                foreach (Role role in roles)
                {
                    var aur = new AppUserRoleRepository();
                    var urole = new UserRole();
                    //ur = aur.GetByUserAndRoleIds(contactId, int.Parse(cqDto.RoleID));
                    urole.UserId = user.UserId;
                    urole.RoleId = role.RoleId;
                    aur.Save(urole);
                }
            }
            uDto.Key = key;
            uDto.UserId = user.UserId.ToString();
            var response = request.CreateResponse(HttpStatusCode.Created, uDto);
            response.Headers.Location = new Uri(Url.Link("Default", new
            {
                id = user.UserId
            }));
            return response;
        }
        public HttpResponseMessage HarvestPond([FromBody] HarvestDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var companyId = 0;
            var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (UserId > 0 && aur.IsInRole(UserId, "Chowtime"))
            {
                var hr = new HarvestRepository();
                var harv = new Harvest();
                var errors = ValidateDtoData(uDto, harv);
                if (errors.Any())
                {
                    return ProcessValidationErrors(Request, errors, key);
                }

                        return ProcessNewHarvestRecord(Request, uDto, key, companyId, UserId);

                //  no idea what this is
                var msg = "invalid data structure submitted";
                return Request.CreateResponse(HttpStatusCode.BadRequest, msg);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
        internal HttpResponseMessage Farms(HttpRequestMessage request, FarmDTO cqDTO)
        {
            string key;
            var aur = new AppUserRepository();
            var companyId = 0;
            var UserId = aur.ValidateUser(cqDTO.Key, out key, ref companyId);
            AppUserRoleRepository aur1 = new AppUserRoleRepository();

            if (UserId > 0 && aur1.IsInRole(UserId, "User"))
            {
                var ur = new FarmRepository();
                var u = new Farm();
                cqDTO.CompanyId = companyId.ToString();
                var predicate = ur.GetPredicate(cqDTO, u, companyId);
                var data = ur.GetByPredicate(predicate);
                var col = new Collection<Dictionary<string, string>>();

                foreach (var item in data)
                {

                    var dic = new Dictionary<string, string>();

                    dic.Add("FarmId", item.FarmId.ToString());
                    dic.Add("FarmName", item.FarmName);
                    dic.Add("StatusId", item.StatusId.ToString());
                    col.Add(dic);

                }

                var retVal = new GenericDTO
                {
                    Key = key,
                    ReturnData = col
                };
                return Request.CreateResponse(HttpStatusCode.OK, retVal);
            }
            var message = "validation failed";
            return request.CreateResponse(HttpStatusCode.NotFound, message);
        }
        internal HttpResponseMessage Ponds(HttpRequestMessage request, PondDTO cqDTO)
        {
            string key;
            var aur = new AppUserRepository();
            var companyId = 0;
            var UserId = aur.ValidateUser(cqDTO.Key, out key, ref companyId);
            AppUserRoleRepository aur1 = new AppUserRoleRepository();

            if (UserId > 0 && aur1.IsInRole(UserId, "User"))
            {
                var ur = new PondRepository();
                var u = new Pond();
                var predicate = ur.GetPredicate(cqDTO, u, companyId);
                var data = ur.GetByPredicate(predicate);
                var col = new Collection<Dictionary<string, string>>();

                foreach (var item in data)
                {

                    var dic = new Dictionary<string, string>();

                    dic.Add("PondId", item.PondId.ToString());
                    dic.Add("PondName", item.PondName);
                    dic.Add("StatusId", item.StatusId.ToString());
                    dic.Add("Size", item.Size.ToString());
                    dic.Add("NoFeed", item.NoFeed.ToString());
                    int poundsfedsinceharvest = 0;
                    if (item.Harvests.OrderByDescending(x => x.HarvestDate).FirstOrDefault() != null)
                    {
                        dic.Add("LastHarvest", item.Harvests.OrderByDescending(x => x.HarvestDate).FirstOrDefault().HarvestDate.ToString());
                        poundsfedsinceharvest = item.Feedings.Where(x => x.FeedDate > item.Harvests.OrderByDescending(y => y.HarvestDate).FirstOrDefault().HarvestDate).Sum(x => x.PoundsFed);

                    }
                    else
                    {
                        dic.Add("LastHarvest", "");
                        poundsfedsinceharvest = item.Feedings.Sum(x => x.PoundsFed);
                    }
                    int salepounds = poundsfedsinceharvest / 2;
                    dic.Add("PoundsFedSinceHarvest", poundsfedsinceharvest.ToString());
                    dic.Add("SalesPoundsSinceHarvest", salepounds.ToString());
                    dic.Add("HealthStatus", item.HealthStatus.ToString());
                    col.Add(dic);

                }

                var retVal = new GenericDTO
                {
                    Key = key,
                    ReturnData = col
                };
                return Request.CreateResponse(HttpStatusCode.OK, retVal);
            }
            var message = "validation failed";
            return request.CreateResponse(HttpStatusCode.NotFound, message);
        }
        public HttpResponseMessage PondO2ByDate([FromBody] O2ReadingDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var companyId = 0;
            var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);
            //string dayperiod;
            //if (DateTime.Parse(uDto.ReadingDate).Hour < 12)
            //{
            //    dayperiod = DateTime.Parse(uDto.ReadingDate).AddDays(-1).ToShortDateString();
            //}
            //else
            //{
            //    dayperiod = DateTime.Parse(uDto.ReadingDate).ToShortDateString();
            //}
            //uDto.DayPeriod = dayperiod;

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (UserId > 0 && aur.IsInRole(UserId, "Airtime"))
            {
                var O2r = new O2ReadingRepository();
                var u = new O2Reading();
                //var predicate = O2r.GetPredicate(uDto, u, companyId);
                var data = O2r.GetPondO2ReadingsByDate(int.Parse(uDto.PondId), DateTime.Parse(uDto.ReadingDate));
                var col = new Collection<Dictionary<string, string>>();

                foreach (var item in data)
                {

                    var dic = new Dictionary<string, string>();

                    dic.Add("PondId", item.PondId.ToString());
                    dic.Add("ReadingId", item.ReadingId.ToString());
                    dic.Add("ReadingDate", item.ReadingDate.ToString());
                    dic.Add("O2Level", item.O2Level.ToString());
                    dic.Add("StaticCount", item.StaticCount.ToString());
                    dic.Add("PortableCount", item.PortableCount.ToString());
                    dic.Add("Note", item.Note);
                    dic.Add("PondStatus", item.Pond.HealthStatus.ToString());
                    col.Add(dic);

                }

                var retVal = new GenericDTO
                {
                    Key = key,
                    ReturnData = col
                };
                return Request.CreateResponse(HttpStatusCode.OK, retVal);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
        public HttpResponseMessage PondFeedLast7Feeds([FromBody] PondDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var companyId = 0;
            var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (UserId > 0 && aur.IsInRole(UserId, "Chowtime"))
            {
                var pr = new PondRepository();
                var ponddata = pr.GetById(int.Parse(uDto.PondId));
                DateTime startdate = DateTime.Now;

                int i = 0;
                int j = 0;
                int pondDataCount = 0;

                var col = new Collection<Dictionary<string, string>>();
                while (pondDataCount < 7 && j < 10)
                {
                    var fr = new FeedingRepository();
                    var data = fr.GetPondFeedingsByDate(ponddata.PondId, startdate.AddDays(i));
                    if (data != null)
                    {

                        var dic = new Dictionary<string, string>();

                        dic.Add("PondId", data.PondId.ToString());
                        dic.Add("FeedingId", data.FeedingId.ToString());
                        dic.Add("FeedDate", data.FeedDate.ToString());
                        dic.Add("PoundsFed", data.PoundsFed.ToString());
                        col.Add(dic);
                        pondDataCount++;
                        // reset j - haven't hit null territory yet
                        j = 0;
                    }
                    else { j++; }
                    i--;
                }
                var retVal = new GenericDTO
                {
                    Key = key,
                    ReturnData = col
                };
                return Request.CreateResponse(HttpStatusCode.OK, retVal);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
        public HttpResponseMessage FeedById([FromBody] FeedingDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var companyId = 0;
            var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);
            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (UserId > 0 && aur.IsInRole(UserId, "Chowtime"))
            {
                var O2r = new FeedingRepository();
                var data = O2r.GetById(int.Parse(uDto.FeedingId));
                var col = new Collection<Dictionary<string, string>>();

                    var dic = new Dictionary<string, string>();

                    dic.Add("PondId", data.PondId.ToString());
                    dic.Add("FeedingId", data.FeedingId.ToString());
                    dic.Add("FeedDate", data.FeedDate.ToString());
                    dic.Add("PoundsFed", data.PoundsFed.ToString());
                    col.Add(dic);

                var retVal = new GenericDTO
                {
                    Key = key,
                    ReturnData = col
                };
                return Request.CreateResponse(HttpStatusCode.OK, retVal);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
        public HttpResponseMessage GetLastPondReading([FromBody] O2ReadingDTO uDto)
        {
            string key;
            var ur = new AppUserRepository();
            var companyId = 0;
            var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);

            AppUserRoleRepository aur = new AppUserRoleRepository();

            if (UserId > 0 && aur.IsInRole(UserId, "Airtime"))
            {
                var O2r = new O2ReadingRepository();
                var u = new O2Reading();
                //var predicate = O2r.GetPredicate(uDto, u, companyId);
                var data = O2r.GetLastPondReadingByPond(int.Parse(uDto.PondId));
                var col = new Collection<Dictionary<string, string>>();

                    var dic = new Dictionary<string, string>();

                    dic.Add("PondId", data.PondId.ToString());
                    dic.Add("ReadingId", data.ReadingId.ToString());
                    dic.Add("ReadingDate", data.ReadingDate.ToString());
                    dic.Add("O2Level", data.O2Level.ToString());
                    dic.Add("StaticCount", data.StaticCount.ToString());
                    dic.Add("PortableCount", data.PortableCount.ToString());
                    dic.Add("Note", data.Note);
                    col.Add(dic);

                var retVal = new GenericDTO
                {
                    Key = key,
                    ReturnData = col
                };
                return Request.CreateResponse(HttpStatusCode.OK, retVal);
            }
            var message = "validation failed";
            return Request.CreateResponse(HttpStatusCode.NotFound, message);
        }
 private HttpResponseMessage RemoveUserRole(HttpRequestMessage request, UserRoleDTO cqDto, int contactId, string key, int companyId, int userId)
 {
     var aur = new AppUserRoleRepository();
     var ur = new UserRole();
     ur = aur.GetByUserAndRoleIds(contactId, int.Parse(cqDto.RoleID));
     aur.Delete(ur);
     cqDto.Key = key;
     return request.CreateResponse(HttpStatusCode.Accepted, cqDto);
 }
 public bool IsUserInRole(int userId, int roleId)
 {
     return(AppUserRoleRepository.Any(x => x.AppUserId == userId && x.AppRoleId == roleId));
 }
        private HttpResponseMessage ProcessExistingUserRecord(HttpRequestMessage request, UserDTO cqDto, int contactId, string key, int companyId, int userId)
        {
            var ur = new UserRepository();
            //var userRepository = new AppUserRepository();
            var user = new User();
            user = ur.GetById(contactId);
            //int? companyIdx = -1;
            //  is the user eligible to update the prospect?
            bool newfromsetup;
            if (cqDto.CompanyId == null)
            {
                cqDto.CompanyId = companyId.ToString();
                newfromsetup = false;
            }
            else
            {
                newfromsetup = true;
            }

                var validationErrors = GetValidationErrors(ur, user, cqDto, companyId, userId);
                if (validationErrors.Any())
                {
                    return ProcessValidationErrors(request, validationErrors, key);
                }
                //  no validation errors...
                //if (cqDto.Password != "sg")
                //{
                //    user.Password = SecurityUtils.GetBinaryPassword(cqDto.Password.ToString());
                //}
                //else
                //{
                //    SGApp.Models.EF.User userexist = userRepository.GetUser(cqDto.EmailAddress, SecurityUtils.GetBinaryPassword(cqDto.Password), ref companyIdx);
                //    user.Password = userexist.Password;
                //}

                ur.Save(user);
                if (newfromsetup)
                {
                    var rr = new RoleRepository();
                    var roles = rr.GetRoles();
                    foreach (Role role in roles)
                    {
                        var aur = new AppUserRoleRepository();
                        var urole = new UserRole();
                        //ur = aur.GetByUserAndRoleIds(contactId, int.Parse(cqDto.RoleID));
                        urole.UserId = user.UserId;
                        urole.RoleId = role.RoleId;
                        aur.Save(urole);
                    }
                }
                cqDto.Key = key;
                return request.CreateResponse(HttpStatusCode.Accepted, cqDto);
        }
Exemplo n.º 54
0
        private HttpResponseMessage ProcessNewUserRecord(HttpRequestMessage request, UserDTO uDto, string key, int companyId, int userId)
        {
            var ur = new UserRepository();

            //var userRepository = new AppUserRepository();
            var  user = new User();
            bool newfromsetup;

            if (uDto.CompanyId == null)
            {
                uDto.CompanyId = companyId.ToString();
                newfromsetup   = false;
            }
            else
            {
                newfromsetup = true;
            }
            //int? companyIdx = -1;
            if (ur.GetByEmail(uDto.EmailAddress) != null)
            {
                var msg = "Unable to add new user.  Email Address already Exists.";
                return(Request.CreateResponse(HttpStatusCode.BadRequest, msg));
            }
            var validationErrors = GetValidationErrors(ur, user, uDto, companyId, userId);

            if (validationErrors.Any())
            {
                return(ProcessValidationErrors(request, validationErrors, key));
            }
            //  no validation errors...
            //if (uDto.Password != "sg")
            //{
            //    user.Password = SecurityUtils.GetBinaryPassword(uDto.Password.ToString());
            //}
            //else
            //{
            //    SGApp.Models.EF.User userexist = userRepository.GetUser(uDto.EmailAddress, SecurityUtils.GetBinaryPassword(uDto.Password), ref companyIdx);
            //    user.Password = userexist.Password;
            //}
            //user.CompanyId = companyId;
            //user.UserId = null;
            user = ur.Save(user);
            if (newfromsetup)
            {
                var rr    = new RoleRepository();
                var roles = rr.GetRoles();
                foreach (Role role in roles)
                {
                    var aur   = new AppUserRoleRepository();
                    var urole = new UserRole();
                    //ur = aur.GetByUserAndRoleIds(contactId, int.Parse(cqDto.RoleID));
                    urole.UserId = user.UserId;
                    urole.RoleId = role.RoleId;
                    aur.Save(urole);
                }
            }
            uDto.Key    = key;
            uDto.UserId = user.UserId.ToString();
            var response = request.CreateResponse(HttpStatusCode.Created, uDto);

            response.Headers.Location = new Uri(Url.Link("Default", new
            {
                id = user.UserId
            }));
            return(response);
        }