public bool DeleteCompany(CompanyEntity entityObject)
{
string sqlStatement = "UPDATE Company SET Deleted=1 WHERE CompanyId=@CompanyId " + Environment.NewLine;
//execute
Connection.Execute(sqlStatement, new { CompanyId = entityObject.CompanyId }, Transaction);
return true;
}
public List<VinaGerman.Entity.BusinessEntity.ContactEntity> GetContactForCompany(CompanyEntity Object)
{
//execute
using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance())
{
try
{
db.OpenConnection();
return db.Resolve<IContactDB>().GetContactForCompany(Object);
}
finally
{
db.CloseConnection();
}
}
}
public bool DeleteCompany(CompanyEntity entityObject)
{
//execute
using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance())
{
try
{
db.OpenConnection();
return db.Resolve<ICompanyDB>().DeleteCompany(entityObject);
}
finally
{
db.CloseConnection();
}
}
}
public CompanyEntity AddOrUpdateCompany(CompanyEntity entityObject)
{
string sqlStatement = "";
//if insert
if (entityObject.CompanyId > 0)
{
sqlStatement += "UPDATE Company SET " + Environment.NewLine +
"CompanyOwner=@CompanyOwner," + Environment.NewLine +
"Description=@Description," + Environment.NewLine +
"Deleted=@Deleted," + Environment.NewLine +
"Address=@Address," + Environment.NewLine +
"CompanyCode=@CompanyCode," + Environment.NewLine +
"TaxCode=@TaxCode," + Environment.NewLine +
"Website=@Website," + Environment.NewLine +
"Phone=@Phone," + Environment.NewLine +
"IsSupplier=@IsSupplier," + Environment.NewLine +
"IsCustomer=@IsCustomer" + Environment.NewLine +
"WHERE CompanyId=@CompanyId " + Environment.NewLine +
"SELECT @CompanyId AS CompanyId " + Environment.NewLine;
}
else
{
sqlStatement += "INSERT INTO Company( " + Environment.NewLine +
"CompanyOwner," + Environment.NewLine +
"Description," + Environment.NewLine +
"Deleted," + Environment.NewLine +
"Address," + Environment.NewLine +
"CompanyCode," + Environment.NewLine +
"TaxCode," + Environment.NewLine +
"Website," + Environment.NewLine +
"Phone," + Environment.NewLine +
"IsSupplier," + Environment.NewLine +
"IsCustomer)" + Environment.NewLine +
"VALUES (" + Environment.NewLine +
"@CompanyOwner," + Environment.NewLine +
"@Description," + Environment.NewLine +
"@Deleted," + Environment.NewLine +
"@Address," + Environment.NewLine +
"@CompanyCode," + Environment.NewLine +
"@TaxCode," + Environment.NewLine +
"@Website," + Environment.NewLine +
"@Phone," + Environment.NewLine +
"@IsSupplier," + Environment.NewLine +
"@IsCustomer)" + Environment.NewLine +
"SELECT SCOPE_IDENTITY() AS CompanyId" + Environment.NewLine;
}
//execute
entityObject.CompanyId = Connection.ExecuteScalar<int>(sqlStatement, new
{
Address = entityObject.Address,
CompanyCode = entityObject.CompanyCode,
CompanyId = entityObject.CompanyId,
CompanyOwner = entityObject.CompanyOwner,
Description = entityObject.Description,
IsCustomer = (entityObject.IsCustomer ? 1 : 0),
IsSupplier = (entityObject.IsSupplier ? 1 : 0),
Deleted = (entityObject.Deleted ? 1 : 0),
Phone = entityObject.Phone,
TaxCode = entityObject.TaxCode,
Website = entityObject.Website
}, Transaction);
return entityObject;
}
public List<VinaGerman.Entity.BusinessEntity.ContactEntity> GetContactForCompany(CompanyEntity hObject)
{
List<VinaGerman.Entity.BusinessEntity.ContactEntity> result = null;
string sqlStatement = "SELECT " + Environment.NewLine +
"Contact.ContactId," + Environment.NewLine +
"Contact.FullName," + Environment.NewLine +
"Contact.Email," + Environment.NewLine +
"Contact.Phone," + Environment.NewLine +
"Contact.Address," + Environment.NewLine +
"Contact.CompanyId," + Environment.NewLine +
"Contact.UserAccountId," + Environment.NewLine +
"Contact.Position," + Environment.NewLine +
"Contact.DepartmentId" + Environment.NewLine +
"FROM Contact join Company on Contact.CompanyId= Company.CompanyId" + Environment.NewLine +
"WHERE Contact.Deleted=0 and Contact.CompanyId=@CompanyId" + Environment.NewLine;
//execute
result = Connection.Query<VinaGerman.Entity.BusinessEntity.ContactEntity>(sqlStatement, new { CompanyId = hObject.CompanyId }, Transaction).ToList();
return result;
}
private void LoadData()
{
List<CompanyEntity> list = Factory.Resolve<ICompanyDS>().SearchCompanies(new CompanySearchEntity()
{
SearchText = ""
});
if (list != null && list.Count > 0)
{
source.DataSource = list;
GridCompany.DataSource = source;
}
else
{
List<CompanyEntity> lst = new List<CompanyEntity>();
CompanyEntity it = new CompanyEntity();
it.Description = "";
lst.Add(it);
source.DataSource = lst;
GridCompany.DataSource = source;
}
}
private void CopyRow()
{
try
{
List<CompanyEntity> lst = (List<CompanyEntity>)source.DataSource;
int index = -1;
index = this.gvCompany.FocusedRowHandle;
CompanyEntity b = (CompanyEntity)gvCompany.GetFocusedRow();
if (b != null)
{
source = (BindingSource)GridCompany.DataSource;
List<CompanyEntity> list = (List<CompanyEntity>)source.DataSource;
if (list != null && list.Count > 0)
{
CompanyEntity a = new CompanyEntity();
ApplicationHelper.TranferProperiesEx(b, a);
a.CompanyId = 0;
list.Add(a);
}
source.DataSource = list;
GridCompany.DataSource = source;
gvCompany.RefreshData();
}
}
catch (Exception e)
{
Log.WriteLog(this, System.Reflection.MethodBase.GetCurrentMethod().Name, e.Message);
}
}
public void Save(CompanyEntity entityObject)
{
System.Threading.ThreadPool.QueueUserWorkItem(delegate
{
try
{
ShowLoading(StringResources.captionInformation, StringResources.msgLoading);
var updatedEntity = Factory.Resolve<ICompanyDS>().AddOrUpdateCompany(entityObject);
HideLoading();
//display to UI
Application.Current.Dispatcher.Invoke(new Action(() =>
{
SelectedCompany = updatedEntity;
AddOrUpdateCompany(SelectedCompany);
}));
}
catch (Exception ex)
{
HideLoading();
ShowMessageBox(StringResources.captionError, ex.ToString(), MessageBoxButton.OK);
}
});
}
public void DeleteCompany(CompanyEntity newEntity)
{
CompanyEntity oldEntity = CompanyList.FirstOrDefault<CompanyEntity>(p => p.CompanyId == newEntity.CompanyId);
if (oldEntity != null)
{
CompanyList.Remove(oldEntity);
}
CompanyList = new List<CompanyEntity>(_companyList);
}
public void Delete(CompanyEntity 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<ICompanyDS>().DeleteCompany(entityObject);
HideLoading();
//display to UI
Application.Current.Dispatcher.Invoke(new Action(() =>
{
DeleteCompany(entityObject);
SelectedCompany = null;
}));
}
catch (Exception ex)
{
HideLoading();
ShowMessageBox(StringResources.captionError, ex.ToString(), MessageBoxButton.OK);
}
});
}
}
public void AddOrUpdateCompany(CompanyEntity newEntity)
{
CompanyEntity oldEntity = CompanyList.FirstOrDefault<CompanyEntity>(p => p.CompanyCode == newEntity.CompanyCode);
if (oldEntity == null)
{
CompanyList.Insert(0, newEntity);
}
else
{
int index = CompanyList.IndexOf(oldEntity);
CompanyList.Remove(oldEntity);
CompanyList.Insert(index, newEntity);
}
CompanyList = new List<CompanyEntity>(_companyList);
}
public void Add()
{
var newEntity = new CompanyEntity() {
CompanyId = -1,
CompanyOwner= ApplicationHelper.CurrentUserProfile.CompanyId,
Deleted = false,
IsCustomer = true,
IsSupplier = true,
TaxCode = "",
CompanyCode = "",
Address = "",
Phone = "",
Website = ""
};
SelectedCompany = newEntity;
CompanyList.Add(newEntity);
CompanyList = new List<CompanyEntity>(_companyList);
}
public List<VinaGerman.Entity.BusinessEntity.ContactEntity> GetContactForCompany(CompanyEntity Object)
{
return Factory.Resolve<IContactBL>().GetContactForCompany(Object);
}
public bool DeleteCompany(CompanyEntity entityObject)
{
return Factory.Resolve<ICompanyBL>().DeleteCompany(entityObject);
}
public CompanyEntity AddOrUpdateCompany(CompanyEntity entityObject)
{
return Factory.Resolve<ICompanyBL>().AddOrUpdateCompany(entityObject);
}
