public IList <CompanyAllInfo> GetAllCompaniesAllInfo()
{
using (var tran = _session.BeginTransaction())
{
try
{
Address address = null;
Company company = null;
CompanyAllInfo all = null;
var result = _session.QueryOver(() => company)
.JoinAlias(() => company.Address, () => address)
.SelectList(list => list
.Select(() => company.Id).WithAlias(() => all.Id)
.Select(() => company.CompanyName).WithAlias(() => all.CompanyName)
.Select(() => company.Activity).WithAlias(() => all.Activity)
.Select(() => company.Address.Id).WithAlias(() => all.AddressId)
.Select(() => address.City).WithAlias(() => all.City)
.Select(() => address.Street).WithAlias(() => all.Street))
.TransformUsing(Transformers.AliasToBean <CompanyAllInfo>())
.List <CompanyAllInfo>();
return(result);
}
catch (Exception ex)
{
Logger.Logger.AddToLog("ComapnyRepository | GetCompanyAllInfo | {0}", ex);
tran.Rollback();
return(null);
}
}
}
public CompanyModel(CompanyAllInfo company)
{
Id = company.Id;
CompanyName = company.CompanyName;
Activity = company.Activity;
City = company.City;
Street = company.Street;
}
public CompanyAllInfo TransformToDto(long id)
{
var newcompany = new CompanyAllInfo();
newcompany.Id = id;
newcompany.CompanyName = CompanyName;
newcompany.Activity = Activity;
newcompany.City = City;
newcompany.Street = Street;
return(newcompany);
}
public void UpdateCompany(Company currentcompany, CompanyAllInfo newcompany)
{
using (var transaction = _session.BeginTransaction())
{
try
{
currentcompany.ChangeData(newcompany);
transaction.Commit();
}
catch (Exception ex)
{
Logger.Logger.AddToLog("ComapnyRepository | UpdateCompany | {0}", ex);
transaction.Rollback();
}
}
}
public PartialViewResult Edit(long id, CompanyModel company)
{
if (ModelState.IsValid)
{
CompanyAllInfo newCompany = company.TransformToDto(id);
Company currentCompany = CompanyRepository.GetItemById <Company>(id);
Address currentAddress = AddressRepository.GetItemById <Address>(currentCompany.Address.Id);
AddressRepository.UpdateAddress(currentAddress, newCompany.City, newCompany.Street);
CompanyRepository.UpdateCompany(currentCompany, newCompany);
var companyNamesActivity = CompanyRepository.GetAllCompanyNamesAndActivity();
return(PartialView("CompanyList", companyNamesActivity));
}
Response.StatusCode = (int)HttpStatusCode.NotAcceptable;
return(PartialView(company));
}
public virtual void ChangeData(CompanyAllInfo newcompany)
{
CompanyName = newcompany.CompanyName;
Activity = newcompany.Activity;
//Address.City = newcompany.City;
}
