public async Task<bool> UpdateCompany(int id, Company company)
{
using (db = new Diplomna_newEntities())
{
Company companyFromDb = await db.Companies.FindAsync(id);
companyFromDb.AddressText = company.AddressText;
companyFromDb.CityID = company.CityID;
companyFromDb.CompanyName = company.CompanyName;
companyFromDb.Email = company.Email;
companyFromDb.Phones = company.Phones;
db.Entry(companyFromDb).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!(await CompanyExists(id)))
{
return false; // does not exist
}
else
{
throw;
}
}
return true;
}
}
public async Task<List<GetCityEntity>> GetCities()
{
using (db = new Diplomna_newEntities())
{
List<GetCityEntity> cities = await db.Cities.Select(x => new GetCityEntity
{
CityId = x.CityID,
CityName = x.CityName
}).ToListAsync();
return cities;
}
}
public async Task<GetCityEntity> GetCityById(int id)
{
using (db = new Diplomna_newEntities())
{
GetCityEntity city = await db.Cities
.Where(x => x.CityID == id)
.Select(x => new GetCityEntity
{
CityId = x.CityID,
CityName = x.CityName
}).FirstOrDefaultAsync();
return city;
}
}
public async Task<GetCompanyByUsername> GetCompanyByUsername(string username)
{
using (db = new Diplomna_newEntities())
{
GetCompanyByUsername company = await db.Companies
.Where(x => x.CreateBy.ToUpper() == username.ToUpper() && !x.IsDeleted)
.Select(x => new GetCompanyByUsername
{
CompanyAddress = x.AddressText,
CityID = x.CityID,
CompanyID = x.CompanyID,
CompanyName = x.CompanyName,
CreateBy = x.CreateBy,
Email = x.Email,
CompanyPhones = x.Phones
}).FirstOrDefaultAsync();
return company;
}
}
public async Task<List<GetCompanyEntity>> GetCompanies()
{
using (db = new Diplomna_newEntities())
{
List<GetCompanyEntity> companies = await db.Companies.Select(x => new GetCompanyEntity
{
AddedOn = x.AddedOn,
AddressText = x.AddressText,
CityID = x.CityID,
CompanyID = x.CompanyID,
CompanyName = x.CompanyName,
CreateBy = x.CreateBy,
DeletedBy = x.DeletedBy,
DeletedDate = x.DeletedDate,
Email = x.Email,
IsDeleted = x.IsDeleted,
Phones = x.Phones
}).ToListAsync();
return companies;
}
}
public async Task<Company> InsertCompany(Company company)
{
using (db = new Diplomna_newEntities())
{
db.Companies.Add(company);
await db.SaveChangesAsync();
return company;
}
}
