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