public CategoryEntity AddOrUpdateCategory(CategoryEntity entityObject) { string sqlStatement = ""; //if insert if (entityObject.CategoryId > 0) { sqlStatement += "UPDATE Category SET " + Environment.NewLine + "Description=@Description," + Environment.NewLine + "Deleted=@Deleted" + Environment.NewLine + "WHERE CategoryId=@CategoryId " + Environment.NewLine + "SELECT @CategoryId AS CategoryId " + Environment.NewLine; } else { sqlStatement += "INSERT INTO Category( " + Environment.NewLine + "Description," + Environment.NewLine + "Deleted)" + Environment.NewLine + "VALUES (" + Environment.NewLine + "@Description," + Environment.NewLine + "@Deleted)" + Environment.NewLine + "SELECT SCOPE_IDENTITY() AS CategoryId" + Environment.NewLine; } //execute entityObject.CategoryId = Connection.ExecuteScalar<int>(sqlStatement, new { CategoryId = entityObject.CategoryId, Description = entityObject.Description, Deleted = (entityObject.Deleted ? 1 : 0) }, Transaction); return entityObject; }
public bool DeleteCategory(CategoryEntity entityObject) { string sqlStatement = "UPDATE Category SET Deleted=1 WHERE CategoryId=@CategoryId " + Environment.NewLine; //execute Connection.Execute(sqlStatement, new { CategoryId = entityObject.CategoryId }, Transaction); return true; }
public bool DeleteCategory(CategoryEntity entityObject) { //execute using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance()) { try { db.OpenConnection(); return db.Resolve<ICategoryDB>().DeleteCategory(entityObject); } finally { db.CloseConnection(); } } }
private void LoadData() { List<CategoryEntity> list = Factory.Resolve<IBaseDataDS>().SearchCategories(new CategorySearchEntity() { SearchText = "" }); if (list != null && list.Count > 0) { source.DataSource = list; GridCategory.DataSource = source; } else { List<CategoryEntity> lst = new List<CategoryEntity>(); CategoryEntity it = new CategoryEntity(); it.Description = ""; lst.Add(it); source.DataSource = lst; GridCategory.DataSource = source; } }
private void CopyRow() { try { List<CategoryEntity> lst = (List<CategoryEntity>)source.DataSource; int index = -1; index = this.gvCategory.FocusedRowHandle; CategoryEntity b = (CategoryEntity)gvCategory.GetFocusedRow(); if (b != null) { source = (BindingSource)GridCategory.DataSource; List<CategoryEntity> list = (List<CategoryEntity>)source.DataSource; if (list != null && list.Count > 0) { CategoryEntity a = new CategoryEntity(); ApplicationHelper.TranferProperiesEx(b, a); a.CategoryId = 0; list.Add(a); } source.DataSource = list; GridCategory.DataSource = source; gvCategory.RefreshData(); } } catch (Exception e) { Log.WriteLog(this, System.Reflection.MethodBase.GetCurrentMethod().Name, e.Message); } }
public bool DeleteCategory(CategoryEntity entityObject) { return Factory.Resolve<ICategoryBL>().DeleteCategory(entityObject); }
public CategoryEntity AddOrUpdateCategory(CategoryEntity entityObject) { return Factory.Resolve<ICategoryBL>().AddOrUpdateCategory(entityObject); }
public void Save(CategoryEntity entityObject) { System.Threading.ThreadPool.QueueUserWorkItem(delegate { try { ShowLoading(StringResources.captionInformation, StringResources.msgLoading); var updatedEntity = Factory.Resolve<IBaseDataDS>().AddOrUpdateCategory(entityObject); HideLoading(); //display to UI Application.Current.Dispatcher.Invoke(new Action(() => { AddOrUpdateCategory(updatedEntity); })); } catch (Exception ex) { HideLoading(); ShowMessageBox(StringResources.captionError, ex.ToString(), MessageBoxButton.OK); } }); }
public void DeleteCategory(CategoryEntity newEntity) { CategoryEntity oldEntity = CategoryList.FirstOrDefault<CategoryEntity>(p => p.CategoryId == newEntity.CategoryId); if (oldEntity != null) { CategoryList.Remove(oldEntity); } CategoryList = new List<CategoryEntity>(_categoryList); }
public void AddOrUpdateCategory(CategoryEntity newEntity) { CategoryEntity oldEntity = CategoryList.FirstOrDefault<CategoryEntity>(p => p.Description == newEntity.Description); if (oldEntity == null) { CategoryList.Insert(0, newEntity); } else { int index = CategoryList.IndexOf(oldEntity); CategoryList.Remove(oldEntity); CategoryList.Insert(index, newEntity); } CategoryList = new List<CategoryEntity>(_categoryList); }
public void Add() { var newEntity = new CategoryEntity() { Deleted = false, Description = "", CategoryId=-1 }; CategoryList.Add(newEntity); CategoryList = new List<CategoryEntity>(_categoryList); }