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 <Company> InsertCompany(Company company)
{
using (db = new Diplomna_newEntities())
{
db.Companies.Add(company);
await db.SaveChangesAsync();
return(company);
}
}
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);
}
}
