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