public async Task <IHttpActionResult> DeletePopularPlace(int id) { if (User.Identity.IsAuthenticated) { popularPlace city = await db.popularPlaces.FindAsync(id); if (city == null) { return(NotFound()); } var data = city.CompanyOffices.ToList(); foreach (var office in data) { office.popularPlaceId = null; } db.popularPlaces.Remove(city); try { await db.SaveChangesAsync(); } catch (Exception e) { string s = e.ToString(); } return(Ok(city)); } return(BadRequest("Not login")); }
public async Task <IHttpActionResult> UpdatePopularPlace(popularPlace city) { if (User.Identity.IsAuthenticated) { if (!ModelState.IsValid) { return(BadRequest()); } city.status = "a"; city.updatedBy = User.Identity.GetUserId(); city.updatedOn = DateTime.UtcNow; db.Entry(city).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { throw; } return(StatusCode(HttpStatusCode.NoContent)); } return(BadRequest("Not login")); }
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)); }
public async Task <IHttpActionResult> HeadOfficeLocation(Company branch, string city, string popularPlace, string exectLocation) { // var branch = 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; try { db.Entry(branch).State = EntityState.Modified; 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("Done")); }
public async Task <bool> SaveLocation(string city, string popularPlace) { if (city != null && city != "undefined") { var citydb = db.Cities.FirstOrDefault(x => x.cityName.Equals(city, StringComparison.OrdinalIgnoreCase)); if (citydb == null) { City cit = new City(); cit.cityName = city; cit.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId(); cit.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId(); cit.addedOn = DateTime.UtcNow; cit.status = "a"; db.Cities.Add(cit); await db.SaveChangesAsync(); if (popularPlace != null && popularPlace != "undefined") { popularPlace pop = new popularPlace(); pop.status = "p"; try { ElectronicsController.Coordinates co = ElectronicsController.GetLongitudeAndLatitude(popularPlace, city); if (co.status) { pop.longitude = co.longitude; pop.latitude = co.latitude; pop.status = "a"; } } catch (Exception e) { } pop.cityId = cit.Id; pop.name = popularPlace; pop.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId(); pop.addedOn = DateTime.UtcNow; db.popularPlaces.Add(pop); await db.SaveChangesAsync(); } } else { if (popularPlace != null && popularPlace != "undefined") { 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.status = "p"; try { ElectronicsController.Coordinates co = ElectronicsController.GetLongitudeAndLatitude(popularPlace, city); if (co.status) { pop.longitude = co.longitude; pop.latitude = co.latitude; pop.status = "a"; } } catch (Exception e) { } pop.cityId = citydb.Id; pop.name = popularPlace; pop.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId(); pop.addedOn = DateTime.UtcNow; db.popularPlaces.Add(pop); await db.SaveChangesAsync(); } } } } return(true); }