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);
}
