public int AddGenre(string name) { IDictionary <string, object> conditions = new Dictionary <string, object>(); conditions["GenreName"] = name; return(CrudFunctions.Create("GID", conditions, genre)); }
public int AddLanguage(string name) { IDictionary <string, object> conditions = new Dictionary <string, object>(); conditions["LanguageName"] = name; return(CrudFunctions.Create("LID", conditions, language)); }
public int AddDirector(string name) { IDictionary <string, object> conditions = new Dictionary <string, object>(); conditions["DirectorName"] = name; return(CrudFunctions.Create("DID", conditions, director)); }
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)); }
/// <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 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); }