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; }