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