public async Task <IHttpActionResult> DeleteBranch(int id)
{
CompanyOffice company = await db.CompanyOffices.FindAsync(id);
if (company == null)
{
return(NotFound());
}
db.CompanyOffices.Remove(company);
await db.SaveChangesAsync();
return(Ok("Done"));
}
public async Task <IHttpActionResult> OfficeBranch(CompanyOffice branch, string city, string popularPlace, string exectLocation, string SaveOrUpdate)
{
//var company = await db.Companies.FindAsync(companyId);
if (city != null)
{
var citydb = db.Cities.FirstOrDefault(x => x.cityName.Equals(city, StringComparison.OrdinalIgnoreCase));
if (citydb == null)
{
City cit = new City();
cit.cityName = city;
cit.addedBy = User.Identity.GetUserId();
cit.addedBy = User.Identity.GetUserId();
cit.addedOn = DateTime.UtcNow;
db.Cities.Add(cit);
await db.SaveChangesAsync();
// loc.cityId = cit.Id;
branch.cityId = cit.Id;
if (popularPlace != null)
{
popularPlace pop = new popularPlace();
pop.cityId = cit.Id;
pop.name = popularPlace;
pop.addedBy = User.Identity.GetUserId();
pop.addedOn = DateTime.UtcNow;
db.popularPlaces.Add(pop);
await db.SaveChangesAsync();
// loc.popularPlaceId = pop.Id;
branch.popularPlaceId = pop.Id;
}
}
else
{
// loc.cityId = citydb.Id;
branch.cityId = citydb.Id;
if (popularPlace != null)
{
var ppp = db.popularPlaces.FirstOrDefault(x => x.City.cityName.Equals(city, StringComparison.OrdinalIgnoreCase) && x.name.Equals(popularPlace, StringComparison.OrdinalIgnoreCase));
if (ppp == null)
{
popularPlace pop = new popularPlace();
pop.cityId = citydb.Id;
pop.name = popularPlace;
pop.addedBy = User.Identity.GetUserId();
pop.addedOn = DateTime.UtcNow;
db.popularPlaces.Add(pop);
await db.SaveChangesAsync();
// loc.popularPlaceId = pop.Id;
branch.popularPlaceId = pop.Id;
}
else
{
// loc.popularPlaceId = ppp.Id;
branch.popularPlaceId = ppp.Id;
}
}
}
branch.exectLocation = exectLocation;
if (SaveOrUpdate == "Save")
{
db.CompanyOffices.Add(branch);
}
else if (SaveOrUpdate == "Update")
{
//var bra = db.CompanyOffices.Find(branch.Id);
//bra.popularPlaceId = branch.popularPlaceId;
//bra.since = branch.since;
//bra.cityId = branch.cityId;
//bra.contactNo1 = branch.contactNo1;
//bra.contactNo2 = branch.contactNo2;
//await db.SaveChangesAsync();
db.Entry(branch).State = EntityState.Modified;
}
try
{
await db.SaveChangesAsync();
}
catch (Exception e)
{
string s = e.ToString();
}
}
var ret = await(from br in db.CompanyOffices
where br.Id.Equals(branch.Id)
select new
{
id = br.Id,
cityId = br.cityId,
cityName = br.City.cityName,
popularPlace = br.popularPlace.name,
popularPlaceId = br.popularPlaceId,
contactNo1 = br.contactNo1,
contactNo2 = br.contactNo2,
since = br.since,
exectLocation = br.exectLocation,
}).FirstOrDefaultAsync();
return(Ok(ret));
}
