public static string getQueryUpdateCategory(Category category) { return string.Format("UPDATE {0} SET {1}='{2}', {3}='{4}',{5}='{6}',{7}='{8}'WHERE {9}='{10}'", ID_TABLE_CATEGORY, ID_SUPERCATEGORY_CATEGORY,category.SuperCategory.Id, ID_DESCRIPTION_CATEGORY, category.Description, ID_UPDATETIME_CATEGORY, category.UpdateLocalDateTime.ToString(DATETIMEFORMATINSERT_CATEGORY), ID_UPDATEUSER_CATEGORY, category.UpdateUser, ID_ID_CATEGORY, category.Id ); }
public static string getQuerySaveCategory(Category category) { return string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}','{4}','{5}','{6}','{7}')", ID_TABLE_CATEGORY, category.Id, category.SuperCategory.Id, category.Description, category.LocalInsertTime.ToString(DATETIMEFORMATINSERT_CATEGORY), category.InsertUser, category.UpdateLocalDateTime.ToString(DATETIMEFORMATINSERT_CATEGORY), category.UpdateUser); }
public void Update(Category category) { _repositoryHelper.UpdateCategory(category); }
public void Save(Category category) { _repositoryHelper.SaveCategory(category); }
public bool Exists(Category category) { return Get(category.Id) != null; }
internal void UpdateCategory(Category category) { string query = CategoryQuery.getQueryUpdateCategory(category); CategoryQuery.ParseDataSetToCategory(_provider.queryExecute(query,UPDATE_TYPE)); }
internal void SaveCategory(Category category) { string query = CategoryQuery.getQuerySaveCategory(category); CategoryQuery.ParseDataSetToCategory(_provider.queryExecute(query,INSERT_TYPE)); }
public static IList<Category> ParseDataSetToCategory(DataTable dataTable) { IList<Category> categoryList = new List<Category>(); foreach (DataRow row in dataTable.Rows) { Category category = new Category() { Id = row[POSITION_ID_CATEGORY].ToString(), SuperCategory= new SuperCategory(row[POSITION_SUPERCATEGORY_CATEGORY].ToString()), Description = row[POSITION_DESCRIPTION_CATEGORY].ToString(), LocalInsertTime = getDateTime(row[POSITION_INSERTTIME_CATEGORY].ToString(),DATETIMEFORMATINSERT_CATEGORY), InsertUser = row[POSITION_INSERTUSER_CATEGORY].ToString(), UpdateLocalDateTime = getDateTime(row[POSITION_UPDATETIME_CATEGORY].ToString(),DATETIMEFORMATINSERT_CATEGORY), UpdateUser = row[POSITION_UPDATEUSER_CATEGORY].ToString() }; categoryList.Add(category); } return categoryList; }