//[HttpPut] //[HttpPatch] public async Task <IHttpActionResult> PutAGENCY(int id, AGENCY aGENCY) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != aGENCY.AGENCYID) { return(BadRequest()); } db.Entry(aGENCY).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AGENCYExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(int id) { AGENCY aGENCY = db.AGENCies.Find(id); db.AGENCies.Remove(aGENCY); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "AGENCYID,AGENCYNAME,STATUS,CREATEDTIME,CREATEDBY,UPDATEDTIME,UPDATEDBY")] AGENCY aGENCY) { if (ModelState.IsValid) { db.Entry(aGENCY).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aGENCY)); }
public ActionResult Edit([Bind(Include = "ID_AGENCY,NAME,LATITUDE,LONGITUDE")] AGENCY aGENCY) { if (ModelState.IsValid) { db.Entry(aGENCY).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aGENCY)); }
public ActionResult Edit([Bind(Include = "Id,Name,AdresseId")] AGENCY aGENCY) { if (ModelState.IsValid) { db.Entry(aGENCY).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AdresseId = new SelectList(db.ADRESS, "Id", "Street", aGENCY.AdresseId); return(View(aGENCY)); }
public async Task <IHttpActionResult> GetAGENCY(int id) { AGENCY aGENCY = await db.AGENCies.FindAsync(id); if (aGENCY == null) { return(NotFound()); } return(Ok(aGENCY)); }
public ActionResult Create([Bind(Include = "ID_AGENCY,NAME,LATITUDE,LONGITUDE")] AGENCY aGENCY) { if (ModelState.IsValid) { db.AGENCies.Add(aGENCY); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aGENCY)); }
public ActionResult Create([Bind(Include = "AGENCYID,AGENCYNAME,STATUS,CREATEDTIME,CREATEDBY,UPDATEDTIME,UPDATEDBY")] AGENCY aGENCY) { if (ModelState.IsValid) { db.AGENCies.Add(aGENCY); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aGENCY)); }
// GET: AGENCY/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AGENCY aGENCY = db.AGENCies.Find(id); if (aGENCY == null) { return(HttpNotFound()); } return(View(aGENCY)); }
public async Task <string> PostAGENCY([FromBody] AGENCY aGENCY) { //AGENCY aGENCY = JsonConvert.DeserializeObject<AGENCY>(s); if (!ModelState.IsValid) { return("fail");//BadRequest(ModelState); } aGENCY.CREATEDTIME = DateTime.Now; db.AGENCies.Add(aGENCY); await db.SaveChangesAsync(); //return CreatedAtRoute("DefaultApi", new { id = aGENCY.AGENCYID }, aGENCY); return("OK"); }
public async Task <IHttpActionResult> DeleteAGENCY(int id) { AGENCY aGENCY = await db.AGENCies.FindAsync(id); if (aGENCY == null) { return(NotFound()); } db.AGENCies.Remove(aGENCY); await db.SaveChangesAsync(); return(Ok(aGENCY)); }
// GET: AGENCies/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AGENCY aGENCY = db.AGENCY.Find(id); if (aGENCY == null) { return(HttpNotFound()); } ViewBag.AdresseId = new SelectList(db.ADRESS, "Id", "Street", aGENCY.AdresseId); return(View(aGENCY)); }
public void add(AGENCY agency) { try { var Context = new connext_dbEntities(); Context.AGENCies.Add(agency); Context.SaveChanges(); } catch (Exception ex) { #if DEBUG throw new Exception("Impossible de modifier l'agence." + Environment.NewLine + ex.StackTrace); #else throw new Exception("Impossible de modifier l'agence."); #endif } }
public void remove(AGENCY agency) { try { var Context = new connext_dbEntities(); Context.AGENCies.Remove(agency); Context.SaveChanges(); } catch (Exception ex) { #if DEBUG throw new Exception("Impossible de supprimer le lieu." + Environment.NewLine + ex.StackTrace); #else throw new Exception("Impossible de supprimer le lieu."); #endif } }
public ActionResult Create(AGENCY agency) { using (DOANCHUYENNGANHEntities db = new DOANCHUYENNGANHEntities()) { var user = (USER)Session["TaiKhoan"]; ViewBag.IDCATE = db.CATEGORies.FirstOrDefault().IDCATE; agency.IDUSER = user.IDUSER; db.AGENCies.Add(agency); try { db.SaveChanges(); } catch (Exception ex) { } } return(RedirectToAction("Index", new { id = agency.IDAGENCY })); }
// POST api/values public HttpResponseMessage Post(AgencyModel model) { if (HttpContext.Current.Request.Headers["Authorization"] == null) { throw new HttpResponseException(HttpStatusCode.Unauthorized); } string token = HttpContext.Current.Request.Headers["Authorization"]; AGENCY objBdd = new AGENCY(); objBdd.NAME = model.Name; objBdd.LATITUDE = model.Latitude; objBdd.LONGITUDE = model.Longitude; manager.add(objBdd); return new HttpResponseMessage() { Content = new JsonContent(new { Success = true, //error Message = "Success" //return exception }) }; }
// POST api/values public HttpResponseMessage Post(AgencyModel model) { if (HttpContext.Current.Request.Headers["Authorization"] == null) { throw new HttpResponseException(HttpStatusCode.Unauthorized); } string token = HttpContext.Current.Request.Headers["Authorization"]; AGENCY objBdd = new AGENCY(); objBdd.NAME = model.Name; objBdd.LATITUDE = model.Latitude; objBdd.LONGITUDE = model.Longitude; manager.add(objBdd); return(new HttpResponseMessage() { Content = new JsonContent(new { Success = true, //error Message = "Success" //return exception }) }); }
// // GET: /Settings/Members/ public ActionResult Index() { try { //get the logged in member for authorization ViewData["Role"] = GetLoggedInMember(); List <MemberListingModel> allMemberModel = new List <MemberListingModel>(); STNServiceCaller serviceCaller = STNServiceCaller.Instance; var request = new RestRequest(); request.Resource = "/Members"; request.RootElement = "ArrayOfMEMBER"; List <MEMBER> MembersList = serviceCaller.Execute <List <MEMBER> >(request); List <MEMBER> SortedMembers = MembersList.OrderBy(x => x.LNAME).ToList(); //request agencies request = new RestRequest(); request.Resource = "/Agencies"; request.RootElement = "ArrayOfAGENCY"; List <AGENCY> theAgencies = serviceCaller.Execute <List <AGENCY> >(request); //request roles request = new RestRequest(); request.Resource = "/Roles"; request.RootElement = "ArrayOfROLE"; List <ROLE> theRoles = serviceCaller.Execute <List <ROLE> >(request); //loop through members to get each member and their agency and role foreach (MEMBER mem in SortedMembers) { MemberListingModel aMember = new MemberListingModel(); aMember.MemberID = mem.MEMBER_ID; aMember.MemberName = mem.LNAME + ", " + mem.FNAME; //loop through agencies to get agencyname that matches mem.agencyid if (mem.AGENCY_ID != null) { AGENCY anAg = theAgencies.FirstOrDefault(b => b.AGENCY_ID == mem.AGENCY_ID); if (anAg != null) { aMember.AgencyName = anAg.AGENCY_NAME; } } //loop through roles to get role name that matches mem.roleid if (mem.ROLE_ID != null) { ROLE aRole = theRoles.FirstOrDefault(r => r.ROLE_ID == mem.ROLE_ID); if (aRole != null) { aMember.RoleName = aRole.ROLE_NAME; } } allMemberModel.Add(aMember); } return(View("../Settings/Members/Index", allMemberModel)); } catch (Exception e) { return(View("../Shared/Error", e)); } }