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