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