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