public ActionResult EditSave(Assurance model, string returnUrl = "Index")
{
ViewBag.Path1 = "参数设置";
//检查记录在权限范围内
var result = Common.GetHRAdminAssuranceQuery(db, WebSecurity.CurrentUserId).Where(a => a.Id == model.Id).SingleOrDefault();
if (result == null)
{
Common.RMError(this);
return(Redirect(Url.Content(returnUrl)));
}
//end
if (ModelState.IsValid)
{
try
{
result.Name = model.Name;
db.PPSave();
Common.RMOk(this, "记录:" + model + "保存成功!");
return(Redirect(Url.Content(returnUrl)));
}
catch (Exception e)
{
if (e.InnerException.Message.Contains("Cannot insert duplicate key row"))
{
ModelState.AddModelError(string.Empty, "相同名称的记录已存在,保存失败!");
}
}
}
ViewBag.ReturnUrl = returnUrl;
return(View("Edit", model));
}
public IHttpActionResult PutAssurance(int id, Assurance assurance)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != assurance.IdAssurance)
{
return(BadRequest());
}
db.Entry(assurance).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AssuranceExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
//On valide si le patient a une assurance prive
private bool VerifierAssurancePublic(string nssRecherche)
{
Boolean isPublic = false;
//On valide que le champ n'est pas vide
if (nssRecherche == "")
{
MessageBox.Show("Le champs NSS doit etre rempli", "Champ Vide!");
}
else
{
//Validation que le patient existe
if ((from p in myBdd.Patients where p.NSS == nssRecherche select p).Any())
{
Patient patient = (from p in myBdd.Patients where p.NSS == nssRecherche select p).First() as Patient;
Assurance assurance = (from p in myBdd.Assurances where p.ID_Assurance == patient.ID_Assurance select p).First() as Assurance;
if (assurance.ID_Assurance == "5")
{
isPublic = true;
}
else
{
isPublic = false;
}
}
else
{
MessageBox.Show("Le patient n'existe pas dans le system!");
}
}
return(isPublic);
}
private void Modifier()
{
ConsoleHelper.AfficherEntete("Modifier");
try
{
ServiceAssurance service = new ServiceAssurance();
this.liste = service.ListerAssurance();
ConsoleHelper.AfficherListe(this.liste, strategieDelModifAssurances);
ConsoleHelper.AfficherLibelleSaisie("Laisser le champ vide pour ne pas le modifier.");
Assurance assurance = service.ChoisirAssurance(ConsoleSaisie.SaisirEntierObligatoire("ID de l'Assurance à modifier : "));
string saisie = ConsoleSaisie.SaisirChaineOptionnelle("Type (ID) : ");
if (byte.TryParse(saisie, out byte result) && Enum.IsDefined(typeof(TypeAssurance), result))
{
assurance.Type = (TypeAssurance)result;
}
decimal?montant = ConsoleSaisie.SaisirDecimalOptionnel("Montant : ");
assurance.Montant = montant ?? assurance.Montant;
service.ModifierAssurance(assurance);
ConsoleHelper.AfficherLibelleSaisie("Assurance modifiée !");
}
catch
{
ConsoleHelper.AfficherMessageErreur("Problème lors de la modification de l'Assurance !");
}
}
public ActionResult RestoreSave(Assurance record, string returnUrl = "Index")
{
ViewBag.Path1 = "参数设置";
//检查记录在权限范围内
var result = Common.GetHRAdminAssuranceQuery(db, WebSecurity.CurrentUserId, true).Where(a => a.IsDeleted == true).Where(a => a.Id == record.Id).SingleOrDefault();
if (result == null)
{
Common.RMError(this);
return(Redirect(Url.Content(returnUrl)));
}
//end
try
{
result.IsDeleted = false;
db.PPSave();
Common.RMOk(this, "记录:" + result + "恢复成功!");
return(Redirect(Url.Content(returnUrl)));
}
catch (Exception e)
{
Common.RMOk(this, "记录" + result + "恢复失败!" + e.ToString());
}
return(Redirect(Url.Content(returnUrl)));
}
public ActionResult CreateSave(Assurance model, string returnUrl = "Index")
{
ViewBag.Path1 = "参数设置";
if (ModelState.IsValid)
{
try
{
db.Assurance.Add(model);
db.PPSave();
Common.RMOk(this, "记录:'" + model.Name + "'新建成功!");
return(Redirect(Url.Content(returnUrl)));
}
catch (Exception e)
{
if (e.InnerException.Message.Contains("Cannot insert duplicate key row"))
{
ModelState.AddModelError(string.Empty, "相同名称的记录已存在,保存失败!");
}
}
}
// 如果我们进行到这一步时某个地方出错，则重新显示表单
ViewBag.ReturnUrl = returnUrl;
return(View("Create", model));
}
/// <summary>
/// méthode pour créer une nouvelle instance de Assurance sur la base.
/// </summary>
public static void CreerAssurance(Assurance assu)
{
using (var contexte = new Contexte())
{
contexte.Assurances.Add(assu);
contexte.SaveChanges();
}
}
public ActionResult DeleteConfirmed(int id)
{
Assurance assurance = db.Assurances.Find(id);
db.Assurances.Remove(assurance);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void AjouterAssurance(Assurance assurance)
{
using (Context context = new Context())
{
context.Assurances.Add(assurance);
context.SaveChanges();
}
}
public void SupprimerAssurance(Assurance assurance)
{
using (Context context = new Context())
{
context.Assurances.Attach(assurance);
context.Assurances.Remove(assurance);
context.SaveChanges();
}
}
/// <summary>
/// méthode pour Modifier une assurance.
/// </summary>
/// <param name="assurance">modification de l'assurance par OBJ</param>
/// <returns></returns>
public static void ModifierAssurance(Assurance assurance)
{
using (var contexte = new Contexte())
{
contexte.Assurances.Attach(assurance);
contexte.Entry(assurance).State = EntityState.Modified;
contexte.SaveChanges();
}
}
public void SupprimerAssurance(int id)
{
using (Context context = new Context())
{
Assurance assurance = context.Assurances.Single(x => x.Id == id);
context.Assurances.Remove(assurance);
context.SaveChanges();
}
}
public static void CreerAssurance(decimal montant, TypeAssurance typeAssurance)
{
Assurance assurance = new Assurance
{
Montant = montant,
TypeAssurance = typeAssurance
};
ServiceAssurance.CreerAssurance(assurance);
}
private void Modifier()
{
Afficher("Modifier une Assurance");
Assurance choix = MethodesAssurance.ChoisirAssurance();
choix.Id = ConsoleSaisie.SaisirEntierObligatoire("Quelle assurance (Id) ?");
MethodesAssurance.ModifierAssurance(choix);
}
public ActionResult Edit([Bind(Include = "ID,Montant,TypeAssurance")] Assurance assurance)
{
if (ModelState.IsValid)
{
db.Entry(assurance).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(assurance));
}
public IHttpActionResult GetAssurance(int id)
{
Assurance assurance = db.Assurances.Find(id);
if (assurance == null)
{
return(NotFound());
}
return(Ok(assurance));
}
public IHttpActionResult PostAssurance(Assurance assurance)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Assurances.Add(assurance);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = assurance.IdAssurance }, assurance));
}
public IHttpActionResult GetAssurance(int id)
{
Assurance assurance = db.Assurances.Include(x => x.DossierReservations)
.SingleOrDefault(x => x.ID == id);
if (assurance == null)
{
return(NotFound());
}
return(Ok(assurance));
}
public ActionResult Create([Bind(Include = "ID,TypeAssurance,Montant")] Assurance assurance)
{
if (ModelState.IsValid)
{
db.Assurances.Add(assurance);
db.SaveChanges();
Display("Assurance crée");
return(RedirectToAction("Index"));
}
return(View(assurance));
}
// GET: BackOffice/Assurances/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Assurance assurance = db.Assurances.Find(id);
if (assurance == null)
{
return(HttpNotFound());
}
return(View(assurance));
}
public IHttpActionResult DeleteAssurance(int id)
{
Assurance assurance = db.Assurances.Find(id);
if (assurance == null)
{
return(NotFound());
}
db.Assurances.Remove(assurance);
db.SaveChanges();
return(Ok(assurance));
}
// GET: BackOffice/Assurances/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Assurance assurance = db.Assurances.Find(id);
if (assurance == null)
{
return(HttpNotFound());
}
// if(db.DossiersReservations.Any(d=>d.Assurances. ))
return(View(assurance));
}
public ActionResult Create([Bind(Include = "ID,Montant,TypeAssurance")] Assurance assurance)
{
if (assurance.Montant < 0)
{
Display("Assurance doit etre possitive", MessageType.ERROR);
return(View());
}
if (ModelState.IsValid)
{
db.Assurances.Add(assurance);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(assurance));
}
public ActionResult Edit([Bind(Include = "ID,Montant,TypeAssurance")] Assurance assurance)
{
if (ModelState.IsValid)
{
if (assurance.Montant > 0)
{
db.Entry(assurance).State = EntityState.Modified;
db.SaveChanges();
Display("L'Assurance a bien été modifiée");
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("Montant", "Le Montant de l'Assurance doit être positif");
}
}
return(View(assurance));
}
public decimal CalculerPrixTotal(List <Participant> listeParticipant, int idVoyage, int?idAssurance)
{
decimal prixTotal = 0;
Voyage voyage = serviceVoyage.TrouverVoyage(idVoyage);
Assurance assurance = null;
if (idAssurance > 0)
{
assurance = serviceAssurance.TrouverAssurance(idAssurance);
prixTotal = prixTotal + assurance.Montant;
}
foreach (Participant participant in listeParticipant)
{
prixTotal = prixTotal + (voyage.CalculMarge() * Convert.ToDecimal(participant.Reduction));
}
return(prixTotal);
}
private void Nouveau()
{
ConsoleHelper.AfficherEntete("Nouveau");
try
{
var assurance = new Assurance(
type: (TypeAssurance)byte.Parse(ConsoleSaisie.SaisirChaineObligatoire("type (ID) : ")),
montant: ConsoleSaisie.SaisirDecimalObligatoire("Montant : ")
);
ServiceAssurance service = new ServiceAssurance();
service.AjouterAssurance(assurance);
ConsoleHelper.AfficherLibelleSaisie("Assurance ajoutée !");
}
catch
{
ConsoleHelper.AfficherMessageErreur("Problème lors de l'ajout de l'Assurance !");
}
}
public ActionResult Reservation([Bind(Include = "ID,NumeroCarteBancaire," +
"PrixParPersonne,EtatDossierReservation,RaisonAnnulationDossier," +
"PrixTotal,IDVoyage,IDClient")] DossierReservation dossierReservation,
Assurance Assurance, int?nbParticipants)
{
if (ModelState.IsValid)
{
dossierReservation.Assurances = new List <Assurance>();
dossierReservation.Assurances.Add(Assurance);
dossierReservation.PrixTotal = Assurance.Montant;
db.DossierReservations.Add(dossierReservation);
db.SaveChanges();
Session["IDDossier"] = dossierReservation.ID;
Session["Participants"] = nbParticipants;
Display("Demande en cours a votre banque...");
return(RedirectToAction("Ajout"));
}
ViewBag.Assurances = new SelectList(db.Assurances, "ID", "Nom", dossierReservation.Assurances);
return(View(dossierReservation));
}
public IHttpActionResult DeleteAssurance(int id)
{
Assurance assurance = db.Assurances.Find(id);
if (assurance == null)
{
return(NotFound());
}
db.Assurances.Remove(assurance);
try
{
db.SaveChanges();
}
catch
{
return(BadRequest("Assurances à des dossiers"));
}
return(Ok(assurance));
}
//Code pour effectuer la recherche d'un patient
private void Button_Click_Recherche(object sender, RoutedEventArgs e)
{
//On va chercher le NSS a chercher
string nssRecherhce = txtNSSRecherche.Text;
//On valide que le champ n'est pas vide
if (nssRecherhce == "")
{
MessageBox.Show("Le champs NSS doit etre rempli", "Champ Vide!");
}
else
{
//Validation que le patient existe
Boolean patientExiste = (from p in myBdd.Patients where p.NSS == nssRecherhce select p).Any();
if (patientExiste)
{
Patient patient = (from p in myBdd.Patients where p.NSS == nssRecherhce select p).First() as Patient;
txtNomPatientRecherche.Text = patient.nom;
txtPrenomPatientRecherche.Text = patient.prenom;
txtDateNaissanceRecherche.Text = patient.Date_naissance.ToString("MM / dd / yyyy");
txtNSSRechercheAffichage.Text = patient.NSS;
Assurance assurance = (from p in myBdd.Assurances where p.ID_Assurance == patient.ID_Assurance select p).First() as Assurance;
txtAssuranceRecherche.Text = assurance.nom_compagnie;
}
else
{
//Si le patient n'existe pas on affiche un message et on met les textBox a vide
MessageBox.Show("Le patient n'existe pas dans le systeme.", "Patient non trouve!");
txtNomPatientRecherche.Text = "";
txtPrenomPatientRecherche.Text = "";
txtDateNaissanceRecherche.Text = "";
txtNSSRechercheAffichage.Text = "";
txtAssuranceRecherche.Text = "";
}
}
}
public void SupprimerAssurance(Assurance assurance)
{
dalAssurance.SupprimerAssurance(assurance);
}
