public IHttpActionResult GetUserDiveLog(int i_UserId) { LogControllerEntring("getuserlog"); IHttpActionResult result = Ok(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_GetUserDiveLogs_Result> serverResult = MyDiveDB.stp_GetUserDiveLogs(i_UserId); List <DiveLogModel> userDiveLog = new List <DiveLogModel>(); foreach (stp_GetUserDiveLogs_Result res in serverResult) { userDiveLog.Add(new DiveLogModel { BottomType = res.BottomType, Description = res.Description, DiveType = res.Type, MaxDepth = res.MaxDepth, Salinity = res.Salinity, SiteName = res.Name, WaterType = res.WaterType }); } result = Ok(userDiveLog.Count > 0 ? userDiveLog : null); } } catch (Exception ex) { result = LogException(ex, null); } return(result); }
public PictureModel GetUserProfilePicture(int i_UserId) { List <PictureModel> profilePicture = new List <PictureModel>(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { var serverAnswer = MyDiveDB.stp_GetUserProfilePicture(i_UserId); foreach (stp_GetUserProfilePicture_Result res in serverAnswer) { profilePicture.Add(new PictureModel { Picture = res.Picture, PictureType = (ePictureType)res.PictureType }); } } } catch (Exception ex) { Logger.Instance.Notify(ex.StackTrace, eLogType.Error, i_UserId.ToString()); } return(profilePicture.Count == 1 ? profilePicture[0] : null); }
public List <BottomTypeModel> GetBottomTypes() { List <BottomTypeModel> bottomTypes = null; try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_GetBottomType_Result> serverResult = MyDiveDB.stp_GetBottomType(); bottomTypes = new List <BottomTypeModel>(); foreach (stp_GetBottomType_Result res in serverResult) { bottomTypes.Add(new BottomTypeModel { BottomTypeID = res.BottomTypeID, BottomTypeName = res.BottomType }); } } } catch (Exception ex) { bottomTypes = null; } return(bottomTypes.Count > 0 ? bottomTypes : null); }
public eErrors ChangeRole(ChangeRoleModel i_Model) { eErrors error = eErrors.None; using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <int?> serverResult = MyDiveDB.stp_GetUserRole(i_Model.AdminId); List <int> result = new List <int>(); foreach (int res in serverResult) { result.Add(res); } if (result.Count > 0) { if (result[0] == 1) { MyDiveDB.stp_ChangeUserRole(i_Model.UserId, (int)i_Model.Role); } else { error = eErrors.UserIsNotAdmin; } } else { error = eErrors.AdminNotExist; } } return(error); }
public List <AssociationModel> GetAssociation() { List <AssociationModel> assosiations = null; try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_GetAssociations_Result> serverResult = MyDiveDB.stp_GetAssociations(); assosiations = new List <AssociationModel>(); foreach (stp_GetAssociations_Result res in serverResult) { assosiations.Add(new AssociationModel { AssociationID = res.AssociationID, AssociationName = res.AssociationName }); } } } catch (Exception ex) { assosiations = null; } return(assosiations.Count > 0 ? assosiations : null); }
public eErrors CheckPasswordValidation(UpdatePasswordModel i_Model) { eErrors error = eErrors.None; try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <string> serverResult = MyDiveDB.stp_GetUserPassword(i_Model.UserId); List <string> userPass = serverResult.ToList(); if (userPass.Count > 0) { if (!userPass[0].Equals(i_Model.OldPassword)) { error = eErrors.PasswordAreNotEqual; } } } } catch (Exception ex) { Logger.Instance.Notify(ex.StackTrace, eLogType.Error, JsonConvert.SerializeObject(i_Model)); } return(error); }
public IHttpActionResult AddNewIssue([FromBody] IssueModel i_Issue) { LogControllerEntring("add"); IHttpActionResult result = Ok(); if (IssueLogic.CheckIsValidInfo(i_Issue)) { try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { int?issueId = -1; issueId = MyDiveDB.stp_CreateIssue(i_Issue.Subject, i_Issue.Email, i_Issue.Description); LogData(string.Format("add issue: '{0}'", i_Issue.Subject), i_Issue); result = Ok(issueId != -1 ? issueId : null); } } catch (Exception ex) { result = LogException(ex, null); } } else { Logger.Instance.Notify("issue info in insufficient", eLogType.Error, JsonConvert.SerializeObject(i_Issue)); result = BadRequest(); } return(result); }
public List <SiteModel> GetSitesByKeyword(string i_Keyword) { List <SiteModel> sites = new List <SiteModel>(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_GetSitesByKeywors_Result> sitesResult = MyDiveDB.stp_GetSitesByKeywors(i_Keyword); foreach (stp_GetSitesByKeywors_Result site in sitesResult) { ObjectResult <stp_GetSiteCoordinates_Result> coordinates = MyDiveDB.stp_GetSiteCoordinates(site.SiteID); sites.Add(new SiteModel { SiteID = site.SiteID, Name = site.Name, Rating = site.Rating, Coordinates = getCoordinates(coordinates) }); } Logger.Instance.Notify("Fetch sites", eLogType.Info, i_Keyword); } } catch (Exception ex) { Logger.Instance.Notify(ex.StackTrace, eLogType.Error, i_Keyword); } return(sites); }
public List <CityModel> GetCities(int i_CountryId) { List <CityModel> cities = null; try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_GetAllCitiesByCountryId_Result> serverResult = MyDiveDB.stp_GetAllCitiesByCountryId(i_CountryId); cities = new List <CityModel>(); foreach (stp_GetAllCitiesByCountryId_Result res in serverResult) { cities.Add(new CityModel { CityID = res.CityID, CityName = res.CityName }); } Logger.Instance.Notify("Get all cities", eLogType.Info, null); } } catch (Exception ex) { cities = null; } return(cities); }
public IHttpActionResult CreateDiveLog([FromBody] DiveLogModel i_Dive) { LogControllerEntring("create"); IHttpActionResult result = Ok(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { int?diveID = -1; diveID = MyDiveDB.stp_CreateDiveLog (i_Dive.SiteID, i_Dive.MaxDepth, i_Dive.Description, i_Dive.DiveTypeID, i_Dive.UserID, i_Dive.BottomTypeID, i_Dive.SalinityID, i_Dive.WaterTypeID); LogData("Dive log created", i_Dive); result = Ok(diveID != -1 ? diveID : null); } } catch (Exception ex) { result = LogException(ex, null); } return(result); }
public IHttpActionResult EditUserProfile([FromBody] UserModel i_User) { LogControllerEntring("editprofile"); IHttpActionResult result = Ok(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { i_User.FirstName = i_User.FirstName != null ? i_User.FirstName : ""; i_User.LastName = i_User.LastName != null ? i_User.LastName : ""; int userID = MyDiveDB.stp_EditUserProfile( i_User.UserID, i_User.FirstName, i_User.LastName, i_User.LicenseTypeID); result = Ok(userID); LogData("user edited", i_User); } } catch (Exception ex) { result = LogException(ex, JsonConvert.SerializeObject(i_User)); } return(result); }
public List <WaterTypeModel> GetWaterTypes() { List <WaterTypeModel> waterTypes = null; try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_GetWaterTypes_Result> serverResult = MyDiveDB.stp_GetWaterTypes(); waterTypes = new List <WaterTypeModel>(); foreach (stp_GetWaterTypes_Result res in serverResult) { waterTypes.Add(new WaterTypeModel { WaterTypeID = res.WaterTypeID, WaterTypeName = res.WaterType }); } } } catch (Exception ex) { waterTypes = null; } return(waterTypes.Count > 0 ? waterTypes : null); }
public void Notify(string i_Msg, eLogType i_LogType, string i_LogData) { MyDiveEntities MyDiveDB = null; try { DateTime d = DateTime.Now.Date; MyDiveDB = new MyDiveEntities(); MyDiveDB.stp_InsertLog( (int)i_LogType, i_Msg, DateTime.Now.Date, i_LogData); } catch (Exception ex) { throw ex; } finally { if (MyDiveDB != null) { MyDiveDB.Dispose(); } } }
public List <LicenseTypeModel> GetLicenseTypes() { List <LicenseTypeModel> licenseTypes = null; try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_GetLicenseTypes_Result> serverResult = MyDiveDB.stp_GetLicenseTypes(); licenseTypes = new List <LicenseTypeModel>(); foreach (stp_GetLicenseTypes_Result res in serverResult) { licenseTypes.Add(new LicenseTypeModel { Id = res.LicenseTypeID, Type = res.LicenseType }); } } } catch (Exception ex) { licenseTypes = null; } return(licenseTypes.Count > 0 ? licenseTypes : null); }
public IHttpActionResult GetCountries() { LogControllerEntring("getcountries"); IHttpActionResult result = Ok(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_GetAllCountries_Result> countriesResult = MyDiveDB.stp_GetAllCountries(); List <CountryModel> countries = new List <CountryModel>(); foreach (stp_GetAllCountries_Result country in countriesResult) { countries.Add(new CountryModel { CountryID = country.CountryID, CountryName = country.CountryName }); } LogData("Fetch all countries", null); result = Ok(countries.Count > 0 ? countries : null); } } catch (Exception ex) { result = LogException(ex, null); } return(result); }
public IHttpActionResult GetClubPictures(int i_ClubId) { LogControllerEntring("pictures"); IHttpActionResult result = Ok(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { var serverAnswer = MyDiveDB.stp_GetClubPictures(i_ClubId); List <PictureModel> clubPictures = new List <PictureModel>(); foreach (stp_GetClubPictures_Result res in serverAnswer) { clubPictures.Add(new PictureModel { Picture = res.Picture, PictureType = (ePictureType)res.PictureType }); } LogData("Fetch club pictures", i_ClubId); result = Ok(clubPictures.Count > 0 ? clubPictures : null); } } catch (Exception ex) { result = LogException(ex, null); } return(result); }
public List <DiveTypeModel> GetDiveTypes() { List <DiveTypeModel> DiveTypes = null; try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_GetDiveTypes_Result> serverResult = MyDiveDB.stp_GetDiveTypes(); DiveTypes = new List <DiveTypeModel>(); foreach (stp_GetDiveTypes_Result res in serverResult) { DiveTypes.Add(new DiveTypeModel { DiveTypeID = res.DiveTypeID, Type = res.Type }); } } } catch (Exception ex) { DiveTypes = null; } return(DiveTypes.Count > 0 ? DiveTypes : null); }
public IHttpActionResult GetProfilePictures(int i_UserId) { LogControllerEntring("profilepicture"); IHttpActionResult result = Ok(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { var serverAnswer = MyDiveDB.stp_GetUserProfilePicture(i_UserId); List <PictureModel> profilePicture = new List <PictureModel>(); foreach (stp_GetUserProfilePicture_Result res in serverAnswer) { profilePicture.Add(new PictureModel { Picture = res.Picture, PictureType = (ePictureType)res.PictureType }); } LogData("Fetch user profile picture", i_UserId); result = Ok(profilePicture.Count > 0 ? profilePicture : null); } } catch (Exception ex) { result = LogException(ex, null); } return(result); }
public List <SalinityTypeModel> GetSalinityTypes() { List <SalinityTypeModel> salinityTypes = null; try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_GetSalinityTypes_Result> serverResult = MyDiveDB.stp_GetSalinityTypes(); salinityTypes = new List <SalinityTypeModel>(); foreach (stp_GetSalinityTypes_Result res in serverResult) { salinityTypes.Add(new SalinityTypeModel { SalinityID = res.SalinityID, Salinity = res.Salinity }); } } } catch (Exception ex) { salinityTypes = null; } return(salinityTypes.Count > 0 ? salinityTypes : null); }
public IHttpActionResult AuthenticateLogin([FromBody] UserLoginModel i_UserLoginInfo) { LogControllerEntring("login"); IHttpActionResult result = Ok(); if (m_Logic.CheckUserLoginValidation(i_UserLoginInfo)) { try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_AuthenticateLogin_Result> serverAnswer; List <AuthenticationResultModel> userToReturn = new List <AuthenticationResultModel>(); serverAnswer = MyDiveDB.stp_AuthenticateLogin(i_UserLoginInfo.Username, i_UserLoginInfo.Password); foreach (stp_AuthenticateLogin_Result res in serverAnswer) { userToReturn.Add(new AuthenticationResultModel { UserID = res.UserID, Error = eErrors.None, HasError = false, UserRole = (eUserRole)res.UserRole }); } if (userToReturn.Count == 0 || userToReturn.Count > 1) { LogData( string.Format("user {0} were unable to login", i_UserLoginInfo.Username), i_UserLoginInfo); result = BadRequest(JsonConvert.SerializeObject(new AuthenticationResultModel { Error = eErrors.WrongPasswordOrUsername, HasError = true })); } else { LogData(string.Format("user {0} is logged in", i_UserLoginInfo.Username), i_UserLoginInfo); result = Ok(userToReturn[0]); } } } catch (Exception ex) { result = LogException(ex, JsonConvert.SerializeObject(i_UserLoginInfo)); } } else { LogError("user info in insufficient", JsonConvert.SerializeObject(i_UserLoginInfo)); result = BadRequest(JsonConvert.SerializeObject(new AuthenticationResultModel { Error = eErrors.UserInfoInsufficient, HasError = true })); } return(result); }
public IHttpActionResult ClearLog() { IHttpActionResult result = Ok(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { MyDiveDB.stp_ClearLog(); } } catch (Exception ex) { result = LogException(ex, null); } return(result); }
public IHttpActionResult GetClubsByCuntryID(int i_CuntryID) { LogControllerEntring("getclubs"); IHttpActionResult result = Ok(); List <ClubModel> clubs; try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_GetAllClubsByCountryId_Result> clubsResult = MyDiveDB.stp_GetAllClubsByCountryId(i_CuntryID); clubs = new List <ClubModel>(); foreach (stp_GetAllClubsByCountryId_Result club in clubsResult) { clubs.Add(new ClubModel { ClubID = club.ClubID, Name = club.Name, Phone = club.Phone, Email = club.Email, Address = club.Address, Rating = club.Rating, SiteURL = club.SiteURL, Coordinates = new LocationModel { Lat = club.Lat, Long = club.Long } }); } LogData("Fetch all clubs", i_CuntryID.ToString()); result = Ok(clubs.Count > 0 ? clubs : null); } } catch (Exception ex) { clubs = null; result = LogException(ex, null); } return(result); }
public IHttpActionResult GetUserWishList(int i_UserId) { LogControllerEntring("getuserwish"); IHttpActionResult result = Ok(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_GetUserWishList_Result> serverResult = MyDiveDB.stp_GetUserWishList(i_UserId); List <UserWishListModel> userWishList = new List <UserWishListModel>(); foreach (stp_GetUserWishList_Result res in serverResult) { userWishList.Add(new UserWishListModel { WishID = res.WishID, SiteID = res.SiteID, UserID = res.UserID, City = res.CityName, Country = res.CountryName, SiteInfo = new SiteModel { Name = res.Name, Rating = res.Rating, SiteID = res.SiteID, Coordinates = SiteLogic.getCoordinates(MyDiveDB.stp_GetSiteCoordinates(res.SiteID)) } }); } LogData("fetch user wish list", i_UserId); result = Ok(userWishList.Count > 0 ? userWishList : null); } } catch (Exception ex) { result = LogException(ex, null); } return(result); }
private IHttpActionResult Get(int i_Type) { LogControllerEntring(i_Type.ToString()); IHttpActionResult result = Ok(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { var Log = MyDiveDB.stp_GetLog(i_Type); LogData(string.Format("Retrive {0} log", i_Type.ToString()), null); result = Ok(convertToList(Log)); } } catch (Exception ex) { result = LogException(ex, null); } return(result); }
public IHttpActionResult RemoveWish([FromBody] WishModel i_Wish) { LogControllerEntring("remove"); IHttpActionResult result = Ok(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { int?wishID = -1; wishID = MyDiveDB.stp_RemoveFromWishList(i_Wish.UserID, i_Wish.SiteID); LogData("remove wish", i_Wish); result = Ok(wishID != -1 ? wishID : null); } } catch (Exception ex) { result = LogException(ex, null); } return(result); }
public AuthenticationResultModel CreateUser(UserModel i_Model) { AuthenticationResultModel registerResult = new AuthenticationResultModel { Error = eErrors.None, HasError = false, UserRole = eUserRole.RegularUser }; if (CheckUserRegistrationValidation(i_Model)) { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { int userID = MyDiveDB.stp_CreateUser( i_Model.Username, i_Model.Password, i_Model.Email, i_Model.FirstName, i_Model.LastName, i_Model.Association, i_Model.UserLicenseNumber, i_Model.LicenseTypeID, i_Model.Birthday, (int)eUserRole.RegularUser, i_Model.ProfilePicture.Picture, (int)ePictureType.ProfilePicture); registerResult.UserID = userID; } } else { Logger.Instance.Notify("user info in insufficient", eLogType.Error, JsonConvert.SerializeObject(i_Model)); registerResult.Error = eErrors.InsufficientData; registerResult.HasError = true; } return(registerResult); }
public IHttpActionResult RateClub([FromBody] RatingModel i_Rate) { LogControllerEntring("rate"); IHttpActionResult result = Ok(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { int?rateID = -1; rateID = MyDiveDB.stp_RateClub(i_Rate.EntityID, i_Rate.Rate, i_Rate.Comment); LogData("rete club", i_Rate); result = Ok(rateID != -1 ? rateID : null); } } catch (Exception ex) { result = LogException(ex, null); } return(result); }
public IHttpActionResult UpdatePassword([FromBody] UpdatePasswordModel i_NewPassword) { LogControllerEntring("changepassword"); IHttpActionResult result = Ok(); try { eErrors error = m_PasswordLogic.CheckPasswordValidation(i_NewPassword); if (error == eErrors.None) { error = m_PasswordLogic.CheckIfPasswordsAreEquals(i_NewPassword); if (error == eErrors.None) { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { MyDiveDB.stp_UpdateUserPassword(i_NewPassword.UserId, i_NewPassword.NewPassword); LogData("password was changed", i_NewPassword); } } else { result = LogInternalError(error, JsonConvert.SerializeObject(i_NewPassword)); } } else { result = LogInternalError(error, JsonConvert.SerializeObject(i_NewPassword)); } } catch (Exception ex) { result = LogException(ex, JsonConvert.SerializeObject(i_NewPassword)); } return(result); }
public IHttpActionResult GetUser(int i_UserId) { LogControllerEntring("getuser"); IHttpActionResult result = Ok(); try { using (MyDiveEntities MyDiveDB = new MyDiveEntities()) { ObjectResult <stp_GetUser_Result> userResult = MyDiveDB.stp_GetUser(i_UserId); UserModel userToReturn = new UserModel(); foreach (stp_GetUser_Result user in userResult) { userToReturn.UserID = user.UserID; userToReturn.Username = user.Username; userToReturn.Email = user.Email; userToReturn.FirstName = user.FirstName; userToReturn.LastName = user.LastName; userToReturn.Association = user.AssociationID; userToReturn.UserLicenseNumber = user.UserLicenceNumber; userToReturn.LicenseTypeID = user.LicenseTypeID; userToReturn.Birthday = user.Birthday; userToReturn.ProfilePicture = m_Logic.GetUserProfilePicture(i_UserId); } result = Ok(userToReturn); } } catch (Exception ex) { result = LogException(ex, JsonConvert.SerializeObject(i_UserId)); } return(result); }