public void SaveOrUpdate(RefillProductTypeDataEntity p_type) { using(var session = NHibernateHelper.OpenSession()) { using(var transaction = session.BeginTransaction()) { try { session.SaveOrUpdate(p_type); transaction.Commit(); } catch(Exception ex) { transaction.Rollback(); throw ex; } } } }
public void DeleteProductType(RefillProductTypeDataEntity productType) { m_productTypeDao.Delete(productType); }
private List<RefillProductTypeDataEntity> GetProductTypeDataValueChange(List<int> rowIndexChange, out string errorMessage) { List<RefillProductTypeDataEntity> productTypes = new List<RefillProductTypeDataEntity>(); RefillProductTypeDataEntity productType = null; RefillProductTypeDataEntity newProduct = null; List<string> updatedProducts = new List<string>(); string errorMsg = string.Empty; string name = string.Empty; string description = string.Empty; decimal price = 0; bool isNameExists = true; foreach(int rowIndex in rowIndexChange) { productType = new RefillProductTypeDataEntity(); newProduct = new RefillProductTypeDataEntity(); name = this.dgvProductType.Rows[rowIndex].Cells["Name"].Value.ToString().Trim(); if(this.dgvProductType.Rows[rowIndex].Cells["Description"].Value != null) description = this.dgvProductType.Rows[rowIndex].Cells["Description"].Value.ToString().Trim(); price = Convert.ToDecimal(this.dgvProductType.Rows[rowIndex].Cells["Price"].Value.ToString()); newProduct = m_productTypeEntity.Find(m_productType => m_productType.Name.ToUpper() == name.ToUpper()); if(newProduct == null || newProduct.ProductTypeID == 0) isNameExists = false; if(rowIndex < productTypeMaxRowIndex) { int productTypeID = (int)this.dgvProductType.Rows[rowIndex].Cells["ProductTypeID"].Value; productType = m_productTypeEntity.Find(m_productType => m_productType.ProductTypeID == productTypeID); if(productType.Name.ToUpper().Equals(name.ToUpper())) { productType.Name = name; productType.Description = description; productType.Price = price; productTypes.Add(productType); } else if(!productType.Name.ToUpper().Equals(name.ToUpper()) && !isNameExists && !updatedProducts.Contains(name.ToUpper())) { productType.Name = name; productType.Description = description; productType.Price = price; productTypes.Add(productType); updatedProducts.Add(productType.Name.ToUpper()); } else { errorMsg += name + " , "; } } else { if(!isNameExists && !updatedProducts.Contains(name.ToUpper())) { productType.Name = name; productType.Description = description; productType.Price = price; updatedProducts.Add(productType.Name.ToUpper()); productTypes.Add(productType); } else { errorMsg += name + " , "; } } } errorMessage = errorMsg; return productTypes; }
void BtnDeleteProductClick(object sender, EventArgs e) { RefillProductTypeDataEntity productType = new RefillProductTypeDataEntity(); if(this.dgvProductType.SelectedRows.Count > 0) { if(MessageService.ShowYesNo("Are you sure to delete the selected Product Type?", "Delete Product Type")) { foreach(DataGridViewRow currentRow in this.dgvProductType.SelectedRows) { if(currentRow.Index < productTypeMaxRowIndex) { int productTypeID = (int)this.dgvProductType.Rows[currentRow.Index].Cells["ProductTypeID"].Value; productType = m_productTypeEntity.Find(m_productType => m_productType.ProductTypeID == productTypeID); m_presenter.DeleteProductType(productType); } if(!this.dgvProductType.Rows[currentRow.Index].IsNewRow) dgvProductType.Rows.Remove(this.dgvProductType.Rows[currentRow.Index]); } m_presenter.SetAllRefillProductType(); productTypeMaxRowIndex = this.dgvProductType.RowCount - 1; productTypeIndexChange.Clear(); } } }