public ArticleRelationEntity AddOrUpdateArticleRelation(ArticleRelationEntity entityObject) { string sqlStatement = ""; sqlStatement += "DECLARE @NewArticleRelationId INT " + Environment.NewLine; //if insert if (entityObject.ArticleRelationId > 0) { sqlStatement += "UPDATE ArticleRelation SET " + Environment.NewLine + "Comment=@Comment" + Environment.NewLine + "WHERE ArticleRelationId=@ArticleRelationId " + Environment.NewLine + "SET @NewArticleRelationId = @ArticleRelationId " + Environment.NewLine; } else { sqlStatement += "INSERT INTO ArticleRelation( " + Environment.NewLine + "ArticleId," + Environment.NewLine + "RelatedArticleId," + Environment.NewLine + "Comment)" + Environment.NewLine + "VALUES (" + Environment.NewLine + "@ArticleId," + Environment.NewLine + "@RelatedArticleId," + Environment.NewLine + "@Comment)" + Environment.NewLine + "SET @NewArticleRelationId = (SELECT SCOPE_IDENTITY()) " + Environment.NewLine; } 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.ArticleRelationId=@NewArticleRelationId" + Environment.NewLine; //execute var result = Connection.Query<ArticleRelationEntity>(sqlStatement, new { ArticleId = entityObject.ArticleId, RelatedArticleId = entityObject.RelatedArticleId, Comment = entityObject.Comment, ArticleRelationId = entityObject.ArticleRelationId }, Transaction).ToList(); if (result.Count > 0) entityObject = result[0]; else entityObject = null; return entityObject; }
public bool DeleteArticleRelation(ArticleRelationEntity entityObject) { //execute using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance()) { try { db.OpenConnection(); return db.Resolve<IArticleDB>().DeleteArticleRelation(entityObject); } finally { db.CloseConnection(); } } }
//public void Save() //{ // System.Threading.ThreadPool.QueueUserWorkItem(delegate // { // try // { // ShowLoading(StringResources.captionInformation, StringResources.msgLoading); // var updatedEntity = Factory.Resolve<IBaseDataDS>().AddOrUpdateArticle(SelectedArticle); // 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); // } // }); // //ShowDialog<uvCompanyDetailViewModel>(new uvCompanyDetailViewModel() { // // OriginalCompany = SelectCompany // //}); //} public void SaveArticleRelation() { if (SelectedArticle != null && SelectedArticle.ArticleId > 0 && RelatedArticle != null && RelatedArticle.ArticleId > 0) { System.Threading.ThreadPool.QueueUserWorkItem(delegate { try { ShowLoading(StringResources.captionInformation, StringResources.msgLoading); ArticleRelationEntity newEntity = new ArticleRelationEntity() { ArticleId = SelectedArticle.ArticleId, RelatedArticleId = RelatedArticle.ArticleId, Comment = "" }; var updatedEntity = Factory.Resolve<IBaseDataDS>().AddOrUpdateArticleRelation(newEntity); HideLoading(); //display to UI Application.Current.Dispatcher.Invoke(new Action(() => { AddOrUpdateArticleRelation(updatedEntity); })); } catch (Exception ex) { HideLoading(); ShowMessageBox(StringResources.captionError, ex.ToString(), MessageBoxButton.OK); } }); } }
public void DeleteArticleRelationFromList(ArticleRelationEntity newEntity) { ArticleRelationEntity oldEntity = ArticleRelationList.FirstOrDefault<ArticleRelationEntity>(p => p.ArticleRelationId == newEntity.ArticleRelationId); if (oldEntity != null) { ArticleRelationList.Remove(oldEntity); } ArticleRelationList = new List<ArticleRelationEntity>(_articleRelationList); }
public void DeleteArticleRelation(ArticleRelationEntity relationEntity) { if (ShowMessageBox(StringResources.captionConfirm, StringResources.msgConfirmDelete, MessageBoxButton.YesNo) == MessageBoxResult.Yes) { System.Threading.ThreadPool.QueueUserWorkItem(delegate { try { ShowLoading(StringResources.captionInformation, StringResources.msgLoading); var isSuccess = Factory.Resolve<IBaseDataDS>().DeleteArticleRelation(relationEntity); HideLoading(); //display to UI Application.Current.Dispatcher.Invoke(new Action(() => { if (isSuccess) { DeleteArticleRelationFromList(relationEntity); } })); } catch (Exception ex) { HideLoading(); ShowMessageBox(StringResources.captionError, ex.ToString(), MessageBoxButton.OK); } }); } }
public void AddOrUpdateArticleRelation(ArticleRelationEntity newEntity) { if (ArticleRelationList == null) ArticleRelationList = new List<ArticleRelationEntity>(); ArticleRelationEntity oldEntity = ArticleRelationList.FirstOrDefault<ArticleRelationEntity>(p => p.ArticleRelationId == newEntity.ArticleRelationId); if (oldEntity == null) { ArticleRelationList.Insert(0, newEntity); } else { int index = ArticleRelationList.IndexOf(oldEntity); ArticleRelationList.Remove(oldEntity); ArticleRelationList.Insert(index, newEntity); } ArticleRelationList = new List<ArticleRelationEntity>(_articleRelationList); }
private void CopyRow() { try { List<ArticleRelationEntity> lst = (List<ArticleRelationEntity>)source.DataSource; int index = -1; index = this.gvArticleRelation.FocusedRowHandle; ArticleRelationEntity b = (ArticleRelationEntity)gvArticleRelation.GetFocusedRow(); if (b != null) { source = (BindingSource)GridArticleRelation.DataSource; List<ArticleRelationEntity> list = (List<ArticleRelationEntity>)source.DataSource; if (list != null && list.Count > 0) { ArticleRelationEntity a = new ArticleRelationEntity(); ApplicationHelper.TranferProperiesEx(b, a); a.ArticleRelationId = 0; list.Add(a); } source.DataSource = list; GridArticleRelation.DataSource = source; gvArticleRelation.RefreshData(); } } catch (Exception e) { Log.WriteLog(this, System.Reflection.MethodBase.GetCurrentMethod().Name, e.Message); } }
private void Clear_Text() { txtMahang.Text = ""; txtTenhang.Text = ""; txtDVT.Text = ""; slkLoaihang.Text = ""; GridArticleRelation.DataSource = null; List<ArticleRelationEntity> lst = new List<ArticleRelationEntity>(); ArticleRelationEntity it = new ArticleRelationEntity(); it.Comment = ""; lst.Add(it); source.DataSource = lst; GridArticleRelation.DataSource = source; }
public bool DeleteArticleRelation(ArticleRelationEntity entityObject) { return Factory.Resolve<IArticleBL>().DeleteArticleRelation(entityObject); }
public ArticleRelationEntity AddOrUpdateArticleRelation(ArticleRelationEntity entityObject) { return Factory.Resolve<IArticleBL>().AddOrUpdateArticleRelation(entityObject); }
public bool DeleteArticleRelation(ArticleRelationEntity entityObject) { string sqlStatement = "DELETE FROM ArticleRelation WHERE ArticleRelationId=@ArticleRelationId " + Environment.NewLine; //execute Connection.Execute(sqlStatement, new { ArticleRelationId = entityObject.ArticleRelationId }, Transaction); return true; }