public static User UpdateUser(User user) { var parameters = new List <SqlParameter> { new SqlParameter { ParameterName = "UserId", Value = user.UserId }, new SqlParameter { ParameterName = "Email", Value = user.Email }, new SqlParameter { ParameterName = "Password", Value = user.Password }, new SqlParameter { ParameterName = "FirstName", Value = user.FirstName }, new SqlParameter { ParameterName = "Surname", Value = user.Surname } }; var dataTable = DatabaseCommon.PerformAction("UpdateUser", parameters); return(DatabaseCommon.ConvertRow(dataTable, PopulateUser)); }
public static Transaction CreateTransaction(int userId, int points, TransactionType transactionTypeId) { var parameters = new List <SqlParameter> { new SqlParameter { ParameterName = "userId", Value = userId }, new SqlParameter { ParameterName = "points", Value = points }, new SqlParameter { ParameterName = "transactionTypeId", Value = transactionTypeId } }; var dataTable = DatabaseCommon.PerformAction("AddTransaction", parameters); return(DatabaseCommon.ConvertRow(dataTable, PopulateTransaction)); }
public static Hire RetrieveSingleHire(int hireId) { var parameters = new List <SqlParameter> { new SqlParameter("hireId", hireId) }; var dataTable = DatabaseCommon.PerformAction("GetSingleHireForHireId", parameters); return(DatabaseCommon.ConvertRow(dataTable, Hire.FromDataRow)); }
public static Hire RetrieveSingleHire(string bookingReference) { var parameters = new List <SqlParameter> { new SqlParameter("bookingReference", bookingReference) }; var dataTable = DatabaseCommon.PerformAction("GetSingleHireForBookingReference", parameters); return(DatabaseCommon.ConvertRow(dataTable, Hire.FromDataRow)); }
public static User RetrieveUser(int userId) { var parameters = new List <SqlParameter> { new SqlParameter("userId", userId) }; var dt = DatabaseCommon.PerformAction("GetUserForUserId", parameters); return(DatabaseCommon.ConvertRow(dt, PopulateUser)); }
public static int RetrieveUserRanking(int userId) { var parameters = new List <SqlParameter> { new SqlParameter("userId", userId) }; var dataTable = DatabaseCommon.PerformAction("GetUserRanking", parameters); return(DatabaseCommon.ConvertRow(dataTable, (row) => row.Field <int>("Ranking"))); }
public static Session RetrieveSession(Guid sessionId) { var parameters = new List <SqlParameter> { new SqlParameter("sessionId", sessionId) }; var dataTable = DatabaseCommon.PerformAction("GetSessionForId", parameters); return(DatabaseCommon.ConvertRow(dataTable, PopulateSession)); }
public static Hire SetEndMileage(int hireId, int endMileage) { var parameters = new List <SqlParameter> { new SqlParameter("hireId", hireId), new SqlParameter("mileage", endMileage) }; var dt = DatabaseCommon.PerformAction("UpdateHireFinalMileage", parameters); return(DatabaseCommon.ConvertRow(dt, Hire.FromDataRow)); }
public static User UpdatePassword(int userId, string userPassword) { var parameters = new List <SqlParameter> { new SqlParameter("userId", userId), new SqlParameter("password", userPassword) }; var dt = DatabaseCommon.PerformAction("UpdateUserPassword", parameters); return(DatabaseCommon.ConvertRow(dt, PopulateUser)); }
public static User CreateUser(string emailAddress, string firstName, string surname) { var parameters = new List <SqlParameter> { new SqlParameter("emailAddress", emailAddress), new SqlParameter("firstName", firstName), new SqlParameter("surname", surname) }; var dt = DatabaseCommon.PerformAction("CreateNewUser", parameters); return(DatabaseCommon.ConvertRow(dt, PopulateUser)); }
public static Hire CreateHire(int userId, string bookingReference, DateTime hireEndDate, int startMileage) { var parameters = new List <SqlParameter> { new SqlParameter("userId", userId), new SqlParameter("bookingReference", bookingReference), new SqlParameter("hireEndDate", hireEndDate == DateTime.MinValue ? DBNull.Value : (object)hireEndDate), new SqlParameter("startMileage", startMileage) }; var dt = DatabaseCommon.PerformAction("CreateNewHire", parameters); return(DatabaseCommon.ConvertRow(dt, Hire.FromDataRow)); }
public static User RetrieveUser(string email) { var parameters = new List <SqlParameter> { new SqlParameter { ParameterName = "email", Value = email } }; var dataTable = DatabaseCommon.PerformAction("GetUserForEmail", parameters); return(DatabaseCommon.ConvertRow(dataTable, PopulateUser)); }
public static User RetrieveUser(Guid sessionId) { var parameters = new List <SqlParameter> { new SqlParameter { ParameterName = "SessionId", Value = sessionId } }; var dataTable = DatabaseCommon.PerformAction("GetUserForSessionId", parameters); return(DatabaseCommon.ConvertRow(dataTable, PopulateUser)); }
public static Session CreateSession(int userId) { var parameters = new List <SqlParameter> { new SqlParameter { ParameterName = "UserId", Value = userId } }; var dataTable = DatabaseCommon.PerformAction("AddSession", parameters); return(DatabaseCommon.ConvertRow(dataTable, PopulateSession)); }