//
// GET: /GestionDesClasses/Edit/5
public ActionResult EditEtablissement(Guid id)
{
EtablissementModels model;
using (EtablissementRepository repository = new EtablissementRepository())
{
IQueryable <Academies> academies = repository.GetAcademies();
IQueryable <Users> users = repository.GetUsers();
Establishments a = repository.GetEtablissementById(id);
if (a == null)
{
return(HttpNotFound());
}
model = new EtablissementModels
{
mode = 0,
id = a.Id,
name = a.Name,
address = a.Address,
postCode = a.PostCode,
town = a.Town,
academieId = a.Academie_Id,
userId = a.User_Id,
academies = getListAcademies(academies),
users = getListUsers(users)
};
}
return(View("CreateEtablissement", model));
}
public ActionResult CreateEtablissement(EtablissementModels model)
{
if (ModelState.IsValid)
{
using (EtablissementRepository repository = new EtablissementRepository())
{
Establishments a = new Establishments
{
Id = Guid.NewGuid(),
Name = model.name,
Address = model.address,
PostCode = model.postCode,
Town = model.town,
User_Id = model.userId,
Academie_Id = model.academieId
};
repository.Add(a);
repository.Save();
}
return(RedirectToAction("ReadEtablissements"));
}
return(View(model));
}
public ActionResult AddOrUpdate(EstablishmentModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
var isCreated = model.Id == Guid.Empty;
var establishment = new Establishments();
if (!isCreated)
{
establishment = EstablishmentRepository.GetById(model.Id);
}
establishment.Name = model.Name;
establishment.Academie_Id = model.AcademyId;
establishment.Academies = AcademyRepository.GetByName(model.Academy);
establishment.Address = model.Address;
establishment.PostCode = model.PostCode;
establishment.Town = model.Town;
establishment.User_Id = model.UserId;
establishment.Users = UserRepository.GetById(model.UserId);
if (isCreated)
{
EstablishmentRepository.Add(establishment);
}
EstablishmentRepository.Save();
return(Redirect(Url.Action("Get", "Establishment", new { id = establishment.Id })));
}
// GET: /GestionDesClasses/ReadEtablissement/1122
public ActionResult ReadEtablissement(Guid id)
{
EtablissementModels model;
using (EtablissementRepository repository = new EtablissementRepository())
{
Establishments a = repository.GetEtablissementById(id);
IQueryable <Classrooms> e = repository.GetClassroomById(a.Id);
if (a == null)
{
return(HttpNotFound());
}
model = new EtablissementModels
{
id = a.Id,
name = a.Name,
address = a.Address,
postCode = a.PostCode,
town = a.Town,
userId = a.User_Id,
academieId = a.Academie_Id,
userName = a.Users.UserName,
academieName = a.Academies.Name,
classrooms = getListClasses(e)
};
}
return(View(model));
}
public async Task <IHttpActionResult> PutEstablishments(int id, Establishments establishments)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != establishments.id_establishment)
{
return(BadRequest());
}
db.Entry(establishments).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException e)
{
if (!EstablishmentsExists(id))
{
return(NotFound());
}
else
{
WebApiApplication.logger.Warn(e.ToString());
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(Guid id)
{
Establishments establishments = establishmentsRepository.GetById(id);
establishmentsRepository.Remove(establishments);
establishmentsRepository.Save();
return(RedirectToAction("Index"));
}
private void MapElementClicked(object args)
{
string selected = (((MapElementClickEventArgs)args).MapElements.First() as MapIcon).Title;
Establishment establishment = Establishments.SingleOrDefault(e => e.Name == selected);
ShowEstablishmentDialogAsync(establishment);
}
private async Task LoadListCommandExecute()
{
var estabs = await GetEstablismetnsAsync();
Establishments.Clear();
foreach (var e in estabs)
{
Establishments.Add(e);
}
}
public async Task <IHttpActionResult> GetEstablishments(int id)
{
Establishments establishments = await db.establishments.FindAsync(id);
if (establishments == null)
{
return(NotFound());
}
return(Ok(establishments));
}
public async Task <IHttpActionResult> PostEstablishments(Establishments establishments)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.establishments.Add(establishments);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = establishments.id_establishment }, establishments));
}
public ActionResult Edit([Bind(Include = "Id,Name,Address,PostCode,Town,User_Id,Academie_Id")] Establishments establishments)
{
if (ModelState.IsValid)
{
establishmentsRepository.SetEntryState(establishments, EntityState.Modified);
establishmentsRepository.Save();
return(RedirectToAction("Index"));
}
ViewBag.Academie_Id = new SelectList(establishmentsRepository.GetAcademy().Academies, "Id", "Name", establishments.Academie_Id);
ViewBag.User_Id = new SelectList(establishmentsRepository.GetAcademy().Users, "Id", "UserName", establishments.User_Id);
return(View(establishments));
}
public HttpResponseMessage UpdateEstablishments([FromBody] Establishments establishments)
{
int totalRecordsEffected = EstablishmentManagement.GetInstance.UpdateEstablishments(establishments);
if (totalRecordsEffected > 0)
{
return(new iCAS.WebAPI.ResponseMessage().ReturnHttpResponseMessage(true, totalRecordsEffected, string.Format("Successfully updated {0} records", totalRecordsEffected)));
}
else
{
return(new iCAS.WebAPI.ResponseMessage().ReturnHttpResponseMessage(false, totalRecordsEffected, "Failed to update any record"));
}
}
public ActionResult Delete(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Establishments establishments = establishmentsRepository.GetById(id);
if (establishments == null)
{
return(HttpNotFound());
}
return(View(establishments));
}
public async Task <IHttpActionResult> DeleteEstablishments(int id)
{
Establishments establishments = await db.establishments.FindAsync(id);
if (establishments == null)
{
return(NotFound());
}
db.establishments.Remove(establishments);
await db.SaveChangesAsync();
return(Ok(establishments));
}
public ActionResult Edit([Bind(Include = "Id,Name,Address,PostCode,Town,User_Id,Academie_Id")] Establishments establishments)
{
if (ModelState.IsValid)
{
_establishmentRepository.UpdateEstablishment(establishments);
_establishmentRepository.Save();
//db.Entry(establishments).State = EntityState.Modified;
//db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Academie_Id = new SelectList(_establishmentRepository.GetAcademies(), "Id", "Name");
ViewBag.User_Id = new SelectList(_establishmentRepository.GetUsers(), "Id", "UserName");
return(View());
}
// GET: Establishments/Details/5
public ActionResult Details(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Establishments establishments = _establishmentRepository.GetEstablishmentByID(id);
//Establishments establishments = db.Establishments.Find(id);
if (establishments == null)
{
return(HttpNotFound());
}
return(View(establishments));
}
public ActionResult Create([Bind(Include = "Id,Name,Address,PostCode,Town,User_Id,Academie_Id")] Establishments establishments)
{
if (ModelState.IsValid)
{
establishments.Id = Guid.NewGuid();
_establishmentRepository.InsertEstablishment(establishments);
_establishmentRepository.Save();
//db.Establishments.Add(establishments);
//db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Academie_Id = new SelectList(_establishmentRepository.GetAcademies(), "Id", "Name");
ViewBag.User_Id = new SelectList(_establishmentRepository.GetUsers(), "Id", "UserName");
return(View());
}
public int UpdateEstablishments(Establishments establishments)
{
int ReturnValue = 0;
using (SqlCommand UpdateCommand = new SqlCommand())
{
UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
UpdateCommand.Parameters.Add(GetParameter("@ESTB_IDS", SqlDbType.VarChar, establishments.EstbIDs));
UpdateCommand.Parameters.Add(GetParameter("@OPERATION", SqlDbType.VarChar, establishments.Operation));
UpdateCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, establishments.OperationByUserID));
UpdateCommand.CommandText = "pICAS_Establishments_Update_Status";
ExecuteStoredProcedure(UpdateCommand);
ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Establishments establishments = establishmentsRepository.GetById(id);
if (establishments == null)
{
return(HttpNotFound());
}
ViewBag.Academie_Id = new SelectList(establishmentsRepository.GetAcademy().Academies, "Id", "Name", establishments.Academie_Id);
ViewBag.User_Id = new SelectList(establishmentsRepository.GetAcademy().Users, "Id", "UserName", establishments.User_Id);
return(View(establishments));
}
public ActionResult Index()
{
GetJsonData var = new GetJsonData();
var jsonstring = var.GetData(System.Configuration.ConfigurationManager.AppSettings["GetEstablishmentsJsonString"]);
var model = new Establishments();
model.establishments = new List <Establishment>();
if (jsonstring.Equals("File Not Found"))
{
ViewBag.FileNotFound = true;
}
else
{
model = JsonConvert.DeserializeObject <Establishments>(jsonstring);
}
return(View(model.establishments));
}
// GET: Establishments/Edit/5
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Establishments establishments = _establishmentRepository.GetEstablishmentByID(id);
// Establishments establishments = db.Establishments.Find(id);
if (establishments == null)
{
return(HttpNotFound());
}
ViewBag.Academie_Id = new SelectList(_establishmentRepository.GetAcademies(), "Id", "Name");
ViewBag.User_Id = new SelectList(_establishmentRepository.GetUsers(), "Id", "UserName");
return(View());
}
public ActionResult EditEtablissement(EtablissementModels model)
{
using (EtablissementRepository repository = new EtablissementRepository())
{
Establishments a = repository.GetEtablissementById(model.id);
a.Name = model.name;
a.Address = model.address;
a.PostCode = model.postCode;
a.Town = model.town;
a.User_Id = model.userId;
a.Academie_Id = model.academieId;
if (ModelState.IsValid)
{
repository.Save();
}
return(RedirectToAction("ReadEtablissements"));
}
}
public static EstablishmentModel ToModel(Establishments esta)
{
return(new EstablishmentModel
{
Id = esta.Id,
Name = esta.Name,
AcademyId = esta.Academies.Id,
Academy = esta.Academies.Name,
Address = esta.Address,
PostCode = esta.PostCode,
Town = esta.Town,
UserId = esta.Users.Id,
User = esta.Users.FirstName + " " + esta.Users.LastName,
Classrooms = esta.Classrooms.Select(c => new ModelWithNameAndId
{
Id = c.Id,
Name = c.Title
})
});
}
// GET: /GestionDesClasses/DeleteEtablissement/5
public ActionResult DeleteEtablissement(Guid id)
{
EtablissementModels model;
using (EtablissementRepository repository = new EtablissementRepository())
{
Establishments a = repository.GetEtablissementById(id);
if (a == null)
{
return(HttpNotFound());
}
model = new EtablissementModels
{
id = a.Id,
name = a.Name,
address = a.Address,
postCode = a.PostCode,
town = a.Town,
};
}
return(View("DeleteEtablissement", model));
}
public void DeleteEstablishment(Guid?EstablishmentId)
{
Establishments establishments = _context.Establishments.Find(EstablishmentId);
_context.Establishments.Remove(establishments);
}
public int UpdateEstablishments(Establishments establishments)
{
return(EstablishmentIntegration.UpdateEstablishments(establishments));
}
public void Delete(Establishments s)
{
data.Establishments.Remove(s);
}
public void InsertEstablishment(Establishments Establishment)
{
_context.Establishments.Add(Establishment);
}
public void UpdateEstablishment(Establishments Establishment)
{
_context.Entry(Establishment).State = System.Data.Entity.EntityState.Modified;
}
public static int UpdateEstablishments(Establishments establishments)
{
return(EstablishmentDataAccess.GetInstance.UpdateEstablishments(establishments));
}
