/// <summary> /// Insert into DB a category object /// </summary> /// <param name="machineCategory"></param> /// <returns></returns> public Task <int> InsertMachineCategory(MachineCategoryModel machineCategory) { string procName = "Company.MachineCategoryInsert"; var res = _db.SaveDataAsync <MachineCategoryModel, int>(procName, machineCategory); return(res); }
/// <summary> /// Update specific category from db /// </summary> /// <param name="machineCategory">Model to update</param> /// <returns></returns> public Task UpdateMachineCategory(MachineCategoryModel machineCategory) { string procName = "Company.MachineCategoryUpdate"; return(_db.UpdateDataAsync(procName, machineCategory)); }
/// <summary> /// Get all the categories from db based on category object params /// </summary> /// <param name="machineCategory">Model to search for. Params must be initialized with '%' for search</param> /// <returns></returns> public Task <List <MachineCategoryModel> > GetMachineCategoryList(MachineCategoryModel machineCategory) { string procName = "Company.MachineCategorySelect"; return(_db.GetDataAsync <MachineCategoryModel, dynamic>(procName, machineCategory)); }