public void fncLoadDetail(ArticleEntity art)
{
try
{
txtMahang.Text = art.ArticleNo ?? "";
txtTenhang.Text = art.Description ?? "";
txtDVT.Text = art.Unit ?? "";
slkLoaihang.EditValue = art.CategoryId;
lblID.Text = art.ArticleId.ToString();
//load chi tiet
List<ArticleRelationEntity> lst = new List<ArticleRelationEntity>();
if (art != null)
lst = Factory.Resolve<IBaseDataDS>().GetArticleRelationsForArticle(art);
if (lst != null && lst.Count > 0)
{
source.DataSource = lst;
GridArticleRelation.DataSource = source;
}
else
{
source.DataSource = null;
GridArticleRelation.DataSource = source;
}
}
catch (Exception ex)
{
Log.WriteLog(this, MethodBase.GetCurrentMethod().Name, ex.Message);
}
}
public bool DeleteArticle(ArticleEntity entityObject)
{
//execute
using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance())
{
try
{
db.OpenConnection();
return db.Resolve<IArticleDB>().DeleteArticle(entityObject);
}
finally
{
db.CloseConnection();
}
}
}
public ArticleEntity AddOrUpdateArticle(ArticleEntity entityObject)
{
string sqlStatement = "";
//if insert
if (entityObject.ArticleId > 0)
{
sqlStatement += "UPDATE Article SET " + Environment.NewLine +
"ArticleNo=@ArticleNo," + Environment.NewLine +
"CategoryId=@CategoryId," + Environment.NewLine +
"Description=@Description," + Environment.NewLine +
"Unit=@Unit," + Environment.NewLine +
"Deleted=@Deleted" + Environment.NewLine +
"WHERE ArticleId=@ArticleId " + Environment.NewLine +
"SELECT @ArticleId AS ArticleId " + Environment.NewLine;
}
else
{
sqlStatement += "INSERT INTO Article( " + Environment.NewLine +
"ArticleNo," + Environment.NewLine +
"CategoryId," + Environment.NewLine +
"Description," + Environment.NewLine +
"Unit," + Environment.NewLine +
"Deleted)" + Environment.NewLine +
"VALUES (" + Environment.NewLine +
"@ArticleNo," + Environment.NewLine +
"@CategoryId," + Environment.NewLine +
"@Description," + Environment.NewLine +
"@Unit," + Environment.NewLine +
"@Deleted)" + Environment.NewLine +
"SELECT SCOPE_IDENTITY() AS ArticleId" + Environment.NewLine;
}
//execute
entityObject.ArticleId = Connection.ExecuteScalar<int>(sqlStatement, new
{
ArticleId = entityObject.ArticleId,
ArticleNo = entityObject.ArticleNo,
CategoryId = entityObject.CategoryId,
Description = entityObject.Description,
Unit = entityObject.Unit,
Deleted = (entityObject.Deleted ? 1 : 0)
}, Transaction);
return entityObject;
}
//public void Delete()
//{
// if (ShowMessageBox(StringResources.captionConfirm, StringResources.msgConfirmDelete, MessageBoxButton.YesNo) == MessageBoxResult.Yes)
// {
// System.Threading.ThreadPool.QueueUserWorkItem(delegate
// {
// try
// {
// ShowLoading(StringResources.captionInformation, StringResources.msgLoading);
// var updatedEntity = Factory.Resolve<IBaseDataDS>().DeleteArticle(SelectedArticle);
// HideLoading();
// //display to UI
// Application.Current.Dispatcher.Invoke(new Action(() =>
// {
// DeleteArticleFromList(SelectedArticle);
// SelectedArticle = null;
// }));
// }
// catch (Exception ex)
// {
// HideLoading();
// ShowMessageBox(StringResources.captionError, ex.ToString(), MessageBoxButton.OK);
// }
// });
// }
//}
public void Save(ArticleEntity entityObject)
{
System.Threading.ThreadPool.QueueUserWorkItem(delegate
{
try
{
ShowLoading(StringResources.captionInformation, StringResources.msgLoading);
var updatedEntity = Factory.Resolve<IBaseDataDS>().AddOrUpdateArticle(entityObject);
HideLoading();
//display to UI
Application.Current.Dispatcher.Invoke(new Action(() =>
{
SelectedArticle = updatedEntity;
AddOrUpdateArticle(SelectedArticle);
}));
}
catch (Exception ex)
{
HideLoading();
ShowMessageBox(StringResources.captionError, ex.ToString(), MessageBoxButton.OK);
}
});
}
public void DeleteArticleFromList(ArticleEntity newEntity)
{
ArticleEntity oldEntity = ArticleList.FirstOrDefault<ArticleEntity>(p => p.ArticleId == newEntity.ArticleId);
if (oldEntity != null)
{
ArticleList.Remove(oldEntity);
}
ArticleList = new List<ArticleEntity>(_articleList);
}
public void Delete(ArticleEntity entityObject)
{
if (ShowMessageBox(StringResources.captionConfirm, StringResources.msgConfirmDelete, MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
System.Threading.ThreadPool.QueueUserWorkItem(delegate
{
try
{
ShowLoading(StringResources.captionInformation, StringResources.msgLoading);
var updatedEntity = Factory.Resolve<IBaseDataDS>().DeleteArticle(entityObject);
HideLoading();
//display to UI
Application.Current.Dispatcher.Invoke(new Action(() =>
{
DeleteArticleFromList(entityObject);
SelectedArticle = null;
}));
}
catch (Exception ex)
{
HideLoading();
ShowMessageBox(StringResources.captionError, ex.ToString(), MessageBoxButton.OK);
}
});
}
}
public void AddOrUpdateArticle(ArticleEntity newEntity)
{
ArticleEntity oldEntity = ArticleList.FirstOrDefault<ArticleEntity>(p => p.ArticleNo == newEntity.ArticleNo);
if (oldEntity == null)
{
ArticleList.Insert(0, newEntity);
}
else
{
int index = ArticleList.IndexOf(oldEntity);
ArticleList.Remove(oldEntity);
ArticleList.Insert(index, newEntity);
}
ArticleList = new List<ArticleEntity>(_articleList);
}
public void Add()
{
var newEntity = new ArticleEntity()
{
Deleted = false,
Description = "",
ArticleNo="",
CategoryId=-1,
ArticleId=-1
};
SelectedArticle = newEntity;
ArticleList.Add(newEntity);
ArticleList = new List<ArticleEntity>(_articleList);
}
private bool SaveAction()
{
try
{
if (!fncCheckControl()) return false;
ArticleEntity art = new ArticleEntity();
art.ArticleNo = txtMahang.Text.Trim();
art.Description = txtTenhang.Text.Trim();
art.Unit = txtDVT.Text.Trim();
art.CategoryId = int.Parse(slkLoaihang.EditValue.ToString());
ArticleEntity artID = Factory.Resolve<IBaseDataDS>().AddOrUpdateArticle(art);
if (artID.ArticleId > 0)
{
ID = artID.ArticleId;
lblID.Text = ID.ToString();
//insert chi tiet
gvArticleRelation.MoveNext();
gvArticleRelation.UpdateCurrentRow();
source = (BindingSource)GridArticleRelation.DataSource;
if (source.DataSource != null && ((List<ArticleRelationEntity>)source.DataSource).Count > 0)
{
foreach (ArticleRelationEntity dr in source)
{
if (dr.ArticleId>0)
{
dr.RelatedArticleId = ID;
Factory.Resolve<IBaseDataDS>().AddOrUpdateArticleRelation(dr);
}
}
}
DeleteList();
OnloadData();
XtraMessageBox.Show("Thêm mặt hàng thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return true;
}
else
{
XtraMessageBox.Show("Thêm mặt hàng thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return false;
}
}
catch (Exception ex)
{
Log.WriteLog(this, MethodBase.GetCurrentMethod().Name, ex.Message);
XtraMessageBox.Show("Vui lòng nhập đầy đủ thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return false;
}
}
public List<ArticleRelationEntity> GetArticleRelationsForArticle(ArticleEntity searchObject)
{
return Factory.Resolve<IArticleBL>().GetArticleRelationsForArticle(searchObject);
}
public bool DeleteArticle(ArticleEntity entityObject)
{
return Factory.Resolve<IArticleBL>().DeleteArticle(entityObject);
}
public ArticleEntity AddOrUpdateArticle(ArticleEntity entityObject)
{
return Factory.Resolve<IArticleBL>().AddOrUpdateArticle(entityObject);
}
public List<ArticleRelationEntity> GetArticleRelationsForArticle(ArticleEntity searchObject)
{
List<ArticleRelationEntity> result = null;
string sqlStatement = "SELECT " + Environment.NewLine +
"ArticleRelation.ArticleRelationId," + Environment.NewLine +
"ArticleRelation.Comment," + Environment.NewLine +
"Article.ArticleId," + Environment.NewLine +
"Article.CategoryId," + Environment.NewLine +
"Article.ArticleNo," + Environment.NewLine +
"Article.Description," + Environment.NewLine +
"Article.Unit," + Environment.NewLine +
"Article.Deleted" + Environment.NewLine +
"FROM Article JOIN ArticleRelation ON Article.ArticleId=ArticleRelation.RelatedArticleId " + Environment.NewLine +
"WHERE Deleted=0 AND ArticleRelation.ArticleId=@ArticleId" + Environment.NewLine;
//execute
result = Connection.Query<ArticleRelationEntity>(sqlStatement, new { ArticleId = searchObject.ArticleId }, Transaction).ToList();
return result;
}
public bool DeleteArticle(ArticleEntity entityObject)
{
string sqlStatement = "UPDATE Article SET Deleted=1 WHERE ArticleId=@ArticleId " + Environment.NewLine;
//execute
Connection.Execute(sqlStatement, new { ArticleId = entityObject.ArticleId }, Transaction);
return true;
}
public List<ArticleRelationEntity> GetArticleRelationsForArticle(ArticleEntity searchObject)
{
//execute
using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance())
{
try
{
db.OpenConnection();
return db.Resolve<IArticleDB>().GetArticleRelationsForArticle(searchObject);
}
finally
{
db.CloseConnection();
}
}
}
