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