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