public BusinessEntity AddOrUpdateBusiness(BusinessEntity entityObject)
{
string sqlStatement = "";
//if insert
if (entityObject.BusinessId > 0)
{
sqlStatement += "UPDATE Business SET " + Environment.NewLine +
"Description=@Description," + Environment.NewLine +
"Deleted=@Deleted" + Environment.NewLine +
"WHERE BusinessId=@BusinessId " + Environment.NewLine +
"SELECT @BusinessId AS BusinessId " + Environment.NewLine;
}
else
{
sqlStatement += "INSERT INTO Business( " + Environment.NewLine +
"Description," + Environment.NewLine +
"Deleted)" + Environment.NewLine +
"VALUES (" + Environment.NewLine +
"@Description," + Environment.NewLine +
"@Deleted)" + Environment.NewLine +
"SELECT SCOPE_IDENTITY() AS BusinessId" + Environment.NewLine;
}
//execute
entityObject.BusinessId = Connection.ExecuteScalar<int>(sqlStatement, new
{
BusinessId = entityObject.BusinessId,
Description = entityObject.Description,
Deleted = (entityObject.Deleted ? 1 : 0)
}, Transaction);
return entityObject;
}
public bool DeleteBusiness(BusinessEntity entityObject)
{
string sqlStatement = "UPDATE Business SET Deleted=1 WHERE BusinessId=@BusinessId " + Environment.NewLine;
//execute
Connection.Execute(sqlStatement, new { BusinessId = entityObject.BusinessId }, Transaction);
return true;
}
public bool DeleteBusiness(BusinessEntity entityObject)
{
//execute
using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance())
{
try
{
db.OpenConnection();
return db.Resolve<IBusinessDB>().DeleteBusiness(entityObject);
}
finally
{
db.CloseConnection();
}
}
}
private void LoadData()
{
List<BusinessEntity> list = Factory.Resolve<IBaseDataDS>().SearchBusiness(new BusinessSearchEntity()
{
SearchText = ""
});
if (list != null && list.Count > 0)
{
source.DataSource = list;
GridBusiness.DataSource = source;
}
else
{
List<BusinessEntity> lst = new List<BusinessEntity>();
BusinessEntity it = new BusinessEntity();
it.Description = "";
lst.Add(it);
source.DataSource = lst;
GridBusiness.DataSource = source;
}
}
private void CopyRow()
{
try
{
List<BusinessEntity> lst = (List<BusinessEntity>)source.DataSource;
int index = -1;
index = this.gvBusiness.FocusedRowHandle;
BusinessEntity b = (BusinessEntity)gvBusiness.GetFocusedRow();
if (b != null)
{
source = (BindingSource)GridBusiness.DataSource;
List<BusinessEntity> list = (List<BusinessEntity>)source.DataSource;
if (list != null && list.Count > 0)
{
BusinessEntity a = new BusinessEntity();
ApplicationHelper.TranferProperiesEx(b, a);
a.BusinessId = 0;
list.Add(a);
}
source.DataSource = list;
GridBusiness.DataSource = source;
gvBusiness.RefreshData();
}
}
catch (Exception e)
{
Log.WriteLog(this, System.Reflection.MethodBase.GetCurrentMethod().Name, e.Message);
}
}
public void Save(BusinessEntity entityObject)
{
System.Threading.ThreadPool.QueueUserWorkItem(delegate
{
try
{
ShowLoading(StringResources.captionInformation, StringResources.msgLoading);
var updatedEntity = Factory.Resolve<IBaseDataDS>().AddOrUpdateBusiness(entityObject);
HideLoading();
//display to UI
Application.Current.Dispatcher.Invoke(new Action(() =>
{
AddOrUpdateBusiness(updatedEntity);
}));
}
catch (Exception ex)
{
HideLoading();
ShowMessageBox(StringResources.captionError, ex.ToString(), MessageBoxButton.OK);
}
});
}
public void DeleteBusiness(BusinessEntity newEntity)
{
BusinessEntity oldEntity = BusinessList.FirstOrDefault<BusinessEntity>(p => p.BusinessId == newEntity.BusinessId);
if (oldEntity != null)
{
BusinessList.Remove(oldEntity);
}
BusinessList = new List<BusinessEntity>(_businessList);
}
public void AddOrUpdateBusiness(BusinessEntity newEntity)
{
BusinessEntity oldEntity = BusinessList.FirstOrDefault<BusinessEntity>(p => p.Description == newEntity.Description);
if (oldEntity == null)
{
BusinessList.Insert(0, newEntity);
}
else
{
int index = BusinessList.IndexOf(oldEntity);
BusinessList.Remove(oldEntity);
BusinessList.Insert(index, newEntity);
}
BusinessList = new List<BusinessEntity>(_businessList);
}
public void Add()
{
var newEntity = new BusinessEntity()
{
Deleted = false,
Description = "",
BusinessId=-1
};
BusinessList.Add(newEntity);
BusinessList = new List<BusinessEntity>(_businessList);
}
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 DeleteBusiness(BusinessEntity entityObject)
{
return Factory.Resolve<IBusinessBL>().DeleteBusiness(entityObject);
}
public BusinessEntity AddOrUpdateBusiness(BusinessEntity entityObject)
{
return Factory.Resolve<IBusinessBL>().AddOrUpdateBusiness(entityObject);
}
