public IndustryEntity AddOrUpdateIndustry(IndustryEntity entityObject) { string sqlStatement = ""; //if insert if (entityObject.IndustryId > 0) { sqlStatement += "UPDATE Industry SET " + Environment.NewLine + "Description=@Description," + Environment.NewLine + "Deleted=@Deleted" + Environment.NewLine + "WHERE IndustryId=@IndustryId " + Environment.NewLine + "SELECT @IndustryId AS IndustryId " + Environment.NewLine; } else { sqlStatement += "INSERT INTO Industry( " + Environment.NewLine + "Description," + Environment.NewLine + "Deleted)" + Environment.NewLine + "VALUES (" + Environment.NewLine + "@Description," + Environment.NewLine + "@Deleted)" + Environment.NewLine + "SELECT SCOPE_IDENTITY() AS IndustryId" + Environment.NewLine; } //execute entityObject.IndustryId = Connection.ExecuteScalar<int>(sqlStatement, new { IndustryId = entityObject.IndustryId, Description = entityObject.Description, Deleted = (entityObject.Deleted ? 1 : 0) }, Transaction); return entityObject; }
public bool DeleteIndustry(IndustryEntity entityObject) { string sqlStatement = "UPDATE Industry SET Deleted=1 WHERE IndustryId=@IndustryId " + Environment.NewLine; //execute Connection.Execute(sqlStatement, new { IndustryId = entityObject.IndustryId }, Transaction); return true; }
public bool DeleteIndustry(IndustryEntity entityObject) { //execute using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance()) { try { db.OpenConnection(); return db.Resolve<IIndustryDB>().DeleteIndustry(entityObject); } finally { db.CloseConnection(); } } }
public void Save(IndustryEntity entityObject) { System.Threading.ThreadPool.QueueUserWorkItem(delegate { try { ShowLoading(StringResources.captionInformation, StringResources.msgLoading); var updatedEntity = Factory.Resolve<IBaseDataDS>().AddOrUpdateIndustry(entityObject); HideLoading(); //display to UI Application.Current.Dispatcher.Invoke(new Action(() => { AddOrUpdateIndustry(updatedEntity); })); } catch (Exception ex) { HideLoading(); ShowMessageBox(StringResources.captionError, ex.ToString(), MessageBoxButton.OK); } }); }
public void DeleteIndustry(IndustryEntity newEntity) { IndustryEntity oldEntity = IndustryList.FirstOrDefault<IndustryEntity>(p => p.IndustryId == newEntity.IndustryId); if (oldEntity != null) { IndustryList.Remove(oldEntity); } IndustryList = new List<IndustryEntity>(_industryList); }
public void AddOrUpdateIndustry(IndustryEntity newEntity) { IndustryEntity oldEntity = IndustryList.FirstOrDefault<IndustryEntity>(p => p.Description == newEntity.Description); if (oldEntity == null) { IndustryList.Insert(0, newEntity); } else { int index = IndustryList.IndexOf(oldEntity); IndustryList.Remove(oldEntity); IndustryList.Insert(index, newEntity); } IndustryList = new List<IndustryEntity>(_industryList); }
public void Add() { var newEntity = new IndustryEntity() { Deleted = false, Description = "", IndustryId=-1 }; IndustryList.Add(newEntity); IndustryList = new List<IndustryEntity>(_industryList); }
private void LoadData() { List<IndustryEntity> list = Factory.Resolve<IBaseDataDS>().SearchIndustry(new IndustrySearchEntity() { SearchText = "" }); if (list != null && list.Count > 0) { source.DataSource = list; GridIndustry.DataSource = source; } else { List<IndustryEntity> lst = new List<IndustryEntity>(); IndustryEntity it = new IndustryEntity(); it.Description = ""; lst.Add(it); source.DataSource = lst; GridIndustry.DataSource = source; } }
private void CopyRow() { try { List<IndustryEntity> lst = (List<IndustryEntity>)source.DataSource; int index = -1; index = this.gvIndustry.FocusedRowHandle; IndustryEntity b = (IndustryEntity)gvIndustry.GetFocusedRow(); if (b != null) { source = (BindingSource)GridIndustry.DataSource; List<IndustryEntity> list = (List<IndustryEntity>)source.DataSource; if (list != null && list.Count > 0) { IndustryEntity a = new IndustryEntity(); ApplicationHelper.TranferProperiesEx(b, a); a.IndustryId = 0; list.Add(a); } source.DataSource = list; GridIndustry.DataSource = source; gvIndustry.RefreshData(); } } catch (Exception e) { Log.WriteLog(this, System.Reflection.MethodBase.GetCurrentMethod().Name, e.Message); } }
public void Reload() { System.Threading.ThreadPool.QueueUserWorkItem(delegate { try { ShowLoading(StringResources.captionInformation, StringResources.msgLoading); var _obusinessList = Factory.Resolve<IBaseDataDS>().SearchBusiness(new BusinessSearchEntity() { SearchText = "" }); var _oindustryList = Factory.Resolve<IBaseDataDS>().SearchIndustry(new IndustrySearchEntity() { SearchText = "" }); HideLoading(); //display to UI Application.Current.Dispatcher.Invoke(new Action(() => { BusinessEntity itbs = new BusinessEntity() { BusinessId = 0, Description = "" }; BusinessList = _obusinessList; BusinessList.Insert(0, itbs); SelectedBusiness = BusinessList.FirstOrDefault(); IndustryEntity itin = new IndustryEntity() { IndustryId = 0, Description = "" }; IndustryList = _oindustryList; IndustryList.Insert(0, itin); SelectedIndustry = IndustryList.FirstOrDefault(); })); } catch (Exception ex) { HideLoading(); ShowMessageBox(StringResources.captionError, ex.ToString(), MessageBoxButton.OK); } }); //ShowDialog<uvCompanyDetailViewModel>(new uvCompanyDetailViewModel() { // OriginalCompany = SelectCompany //}); }
public bool DeleteIndustry(IndustryEntity entityObject) { return Factory.Resolve<IIndustryBL>().DeleteIndustry(entityObject); }
public IndustryEntity AddOrUpdateIndustry(IndustryEntity entityObject) { return Factory.Resolve<IIndustryBL>().AddOrUpdateIndustry(entityObject); }