public bool DeleteReserved(int iD)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions["RID"] = iD;
return(CrudFunctions.Delete(reserved, conditions) > 0);
}
public IList <MediaDTO> Search(string title = null, string genre = null, string director = null, string language = null, int?year = null)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
if (title != null)
{
conditions["Title"] = title;
}
if (genre != null)
{
conditions["GenreName"] = genre;
}
if (director != null)
{
conditions["DirectorName"] = director;
}
if (language != null)
{
conditions["LanguageName"] = language;
}
if (year != null)
{
if (year > 0)
{
conditions["PublishYear"] = year;
}
}
return(Translate(CrudFunctions.Read(view, conditions, true)));
}
public int AddLanguage(string name)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions["LanguageName"] = name;
return(CrudFunctions.Create("LID", conditions, language));
}
public int AddGenre(string name)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions["GenreName"] = name;
return(CrudFunctions.Create("GID", conditions, genre));
}
public bool DeleteGenre(int iD)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions["GID"] = iD;
return(CrudFunctions.Delete(genre, conditions) > 0);
}
public int AddDirector(string name)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions["DirectorName"] = name;
return(CrudFunctions.Create("DID", conditions, director));
}
public bool DeleteLanguage(int iD)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions["LID"] = iD;
return(CrudFunctions.Delete(language, conditions) > 0);
}
public bool DeleteDirector(int iD)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions["DID"] = iD;
return(CrudFunctions.Delete(director, conditions) > 0);
}
public bool DeleteBorrowed(int iD)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions["BID"] = iD;
return(CrudFunctions.Delete(borrow, conditions) > 0);
}
private static bool Exists(string field, string value)
{
IDictionary <string, object> Parameters = new Dictionary <string, object>();
Parameters[field] = value;
return(CrudFunctions.Read(table, Parameters).Rows.Count > 0);
}
public bool DeleteRecord(MediaDTO record)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions["MediaID"] = record.MediaID;
return(CrudFunctions.Delete(table, conditions) > 0);
}
public bool UpdatePassword(UserDTO user, string newPassword)
{
IDictionary <string, object> Parameters = new Dictionary <string, object>();
Parameters["Password"] = user.Password;
Parameters["UserName"] = user.UserName;
return(CrudFunctions.UpdateField(table, "Password", newPassword, Parameters));
}
public bool ChangeRecord(MediaDTO record, string Field, object Value)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions["MediaID"] = record.MediaID;
CrudFunctions.UpdateField(table, Field, Value, conditions);
return(true);
}
public bool DeleteUser(string username, string password)
{
IDictionary <string, object> Parameters = new Dictionary <string, object>();
Parameters["Password"] = username;
Parameters["UserName"] = password;
return(CrudFunctions.Delete(table, Parameters) > 0);
}
public int AddBorrowed(BorrowDTO record)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions["UID"] = record.UID;
conditions["MediaID"] = record.MediaID;
conditions["BorrowDate"] = record.BorrowDate;
conditions["ReturnDate"] = record.ReturnDate;
return(CrudFunctions.Create("BID", conditions, borrow));
}
public MediaDTO FindByID(int iD)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
conditions["MediaID"] = iD;
IList <MediaDTO> results = Translate(CrudFunctions.Read(view, conditions));
return(results[0]);
}
/// <summary>
/// INSERT INTO TabReserved (UID, MediaID, ReservedDate) Values ( 1, 1, '2019-06-22 12:12:12.000')
/// </summary>
/// <param name="record"></param>
/// <returns></returns>
public MediaDTO AddRecord(MediaDTO record)
{
IDictionary <string, object> values = new Dictionary <string, object>();
values["Title"] = record.Title;
values["Genre"] = record.Genre.GID;
values["Director"] = record.Director.DID;
values["Language"] = record.Language.LID;
values["PublishYear"] = record.Year;
values["Budget"] = record.Budget;
record.MediaID = CrudFunctions.Create("MediaID", values, table);
return(record);
}
public IList <UserDTO> ListUsers(int?id = null)
{
IDictionary <string, object> Parameters = new Dictionary <string, object>();
if (id != null)
{
Parameters["UID"] = id;
}
else
{
Parameters["1"] = 1;
}
return(Translate(CrudFunctions.Read(table, Parameters)));
}
public IList <GenreDTO> GetGenres(int?iD = null)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
if (iD != null)
{
conditions["GID"] = iD;
}
else
{
conditions["1"] = 1;
}
return((IList <GenreDTO>)TranslateGenre(CrudFunctions.Read(genre, conditions)));
}
public IList <DirectorDTO> GetDirectors(int?iD = null)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
if (iD != null)
{
conditions["DID"] = iD;
}
else
{
conditions["1"] = 1;
}
return((IList <DirectorDTO>)TranslateDirector(CrudFunctions.Read(director, conditions)));
}
public IList <LanguageDTO> GetLanguages(int?iD = null)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
if (iD != null)
{
conditions["LID"] = iD;
}
else
{
conditions["1"] = 1;
}
return((IList <LanguageDTO>)TranslateLanguage(CrudFunctions.Read(language, conditions)));
}
public UserDTO ValidateUser(string username, string password)
{
IDictionary <string, object> Parameters = new Dictionary <string, object>();
Parameters["UserName"] = username;
Parameters["Password"] = password;
DataTable Results = CrudFunctions.Read(table, Parameters);
if (Results.Rows.Count > 0)
{
return(Translate(Results.Rows[0]));
}
else
{
throw new Exceptions.ValidationException("Username or Password was incorrect");
}
}
public UserDTO RegisterUser(UserDTO userDetales)
{
if (UserNameExists(userDetales.UserName))
{
throw new Exceptions.ValidationException("Username Already Exists");
}
if (EmailExists(userDetales.UserEmail))
{
throw new Exceptions.ValidationException("Email Already Exists");
}
IDictionary <string, object> values = new Dictionary <string, object>();
values["Password"] = userDetales.Password;
values["UserName"] = userDetales.UserName;
values["UserLevel"] = userDetales.UserLevel;
values["UserEmail"] = userDetales.UserEmail;
userDetales.UID = CrudFunctions.Create("UID", values, table);
return(userDetales);
}
public IList <BorrowDTO> GetBorrowed(int?bID = null, int?uID = null, int?MediaID = null)
{
IDictionary <string, object> conditions = new Dictionary <string, object>();
if (bID != null)
{
conditions["BID"] = bID;
}
if (uID != null)
{
conditions["UID"] = uID;
}
if (MediaID != null)
{
conditions["MediaID"] = MediaID;
}
if (conditions.Count <= 0)
{
conditions["1"] = 1;
}
return((IList <BorrowDTO>)TranslateBorrowed(CrudFunctions.Read(borrow, conditions)));
}
