public async Task <IHttpActionResult> PutDemande(int id, Demande demande)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != demande.IdDemande)
{
return(BadRequest());
}
db.Entry(demande).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DemandeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(Ok(demande));
}
public void saveDemande(Demande de)
{
de.idStudent = StudentController.apoge;
de.status = 0;
MyContext.InsertDemande(de);
Response.Redirect("History", true);
}
public async Task <IActionResult> Edit(int id, [Bind("DemandeID,ID_stage,ID_student,etat")] Demande demande)
{
if (id != demande.DemandeID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(demande);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DemandeExists(demande.DemandeID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(demande));
}
public IHttpActionResult PutDemande(int id, Demande demande)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != demande.ID)
{
return(BadRequest());
}
db.Entry(demande).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DemandeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult SendConfirmation(Demande contact, int?id)
{
MailMessage ms = new MailMessage("*****@*****.**", contact.Email);
ms.Subject = "accepte";
string body = "Le Titre : " + "Demande d'emploi" + "<br>" +
"Message : " + "Cher candidat, Votre demande a été recu Nous vous appellerons à travers 24 heur Pour fournir plus d'informations" + " </br>";
ms.Body = body;
ms.IsBodyHtml = false;
SmtpClient sm = new SmtpClient();
sm.Host = "smtp.gmail.com";
sm.Port = 587;
sm.EnableSsl = true;
NetworkCredential nt = new NetworkCredential("*****@*****.**", "Amin.Morid..");
sm.UseDefaultCredentials = true;
sm.Credentials = nt;
try
{
sm.Send(ms);
return(RedirectToAction("Les_Demande_Apply"));
}
catch (Exception ex)
{
return(RedirectToAction("Error"));
}
}
public int RemoveFromCart(Demande demande)
{
var shoppingCartItem =
_appDbContext.ShoppingCartItems.SingleOrDefault(
s => s.Demande.DemandeID == demande.DemandeID && s.ShoppingCartId == ShoppingCartId);
var localAmount = 0;
if (shoppingCartItem != null)
{
if (shoppingCartItem.Amount > 1)
{
shoppingCartItem.Amount--;
localAmount = shoppingCartItem.Amount;
}
else
{
_appDbContext.ShoppingCartItems.Remove(shoppingCartItem);
}
}
_appDbContext.SaveChanges();
return(localAmount);
}
public ActionResult Create([Bind(Include = "id_demande,depart,arriver,date_depart,date_arriver,id_client")] Demande demande)
{
var olddemande = db.Demandes.Where(d => d.depart == demande.depart && d.arriver == demande.arriver && d.date_arriver == demande.date_arriver && d.date_depart == demande.date_depart).FirstOrDefault();
if (olddemande != null)
{
olddemande.number += 1;
db.SaveChanges();
db.Entry(olddemande).State = EntityState.Modified;
return(RedirectToAction("Index"));
}
else
{
if (ModelState.IsValid)
{
demande.number = 1;
db.Demandes.Add(demande);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_client = new SelectList(db.Clients, "id_utilisateur", "id_utilisateur", demande.id_client);
return(View(demande));
}
}
public ActionResult Apply(string Nom, string Prenom, string Message, string CIN, string Adresse, string Email, string tele, int id, HttpPostedFileBase cv)
{
Session[" choixeId"] = id;
var UserId = User.Identity.GetUserId();
var MedId = (int)(Session[" choixeId"]);
var check = db.Applies.Where(a => a.jobId == MedId && a.UserId == UserId).ToList();
try
{
if (ModelState.IsValid)
{
string path = Path.Combine(Server.MapPath("~/upload"), cv.FileName);
cv.SaveAs(path);
if (check.Count < 1)
{
var medcine = new Demande();
medcine.cv = cv.FileName;
medcine.jobId = MedId;
medcine.UserId = UserId;
medcine.Nom = Nom;
medcine.Message = Message;
medcine.Prenom = Prenom;
medcine.Adresse = Adresse;
medcine.CIN = CIN;
medcine.Email = Email;
medcine.Tele = tele;
medcine.Date = DateTime.Now;
db.Applies.Add(medcine);
db.SaveChanges();
ViewBag.Result = "Demande Effectué";
}
else
{
ViewBag.Result = "Desolé tu est deja Demandé";
}
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
return(View());
}
public static void InsertDemande(Demande de)
{
using (var context = new LibraryContext())
{
// Creates the database if not exists
context.Database.EnsureCreated();
if (de.checkDemande() == 0)
{
//context.demande.First(b=>b.apoge==de.company)
// Adds admins
context.demande.Add(new Demande
{
intern_supervisor = de.intern_supervisor,
extern_supervisor = de.extern_supervisor,
company = de.company,
idStudent = de.idStudent
});
// Saves changes
context.SaveChanges();
}
}
}
public List <Demande> getAll()
{
List <Demande> demandes = new List <Demande>();
using (DbConnection connection = factory.CreateConnection())
{
DbCommand command = mCommand.GetCommand(connection);
command.CommandText = "select * from demandes where status = 'denied'";
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Demande demande = new Demande();
int patrimoinId = Int16.Parse(reader["patrimoine_id"].ToString());
int employeeId = Int16.Parse(reader["utilisateur_id"].ToString());
int demandeId = Int16.Parse(reader["id"].ToString());
UserDto user = userRepository.findById(employeeId);
PatrimoineDto patrimoine = patrimoineRepository.findById(patrimoinId);
string fullName = user.FirstName + " " + user.LastName;
string patNom = patrimoine.Nom;
demande.DemandeId = demandeId;
demande.FullName = fullName;
demande.PatNom = patNom;
demandes.Add(demande);
}
}
}
return(demandes);
}
public static int AddDemande(Demande demande, SqlConnection myConnection)
{
int result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "InsertDemande";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Connection = myConnection;
cmd.Parameters.Add(new SqlParameter("@param1", demande.EmployeeId));
cmd.Parameters.Add(new SqlParameter("@param2", demande.PartId));
cmd.Parameters.Add(new SqlParameter("@param3", demande.MachineId));
cmd.Parameters.Add(new SqlParameter("@param4", demande.QtyPiece));
cmd.Parameters.Add(new SqlParameter("@param5", DateTime.Now));
cmd.Parameters.Add(new SqlParameter("@param6", "New"));
myConnection.Open();
result = cmd.ExecuteNonQuery();
}
catch (SqlException s)
{
}
finally
{
myConnection.Close();
}
return(result);
}
public ActionResult DeleteConfirmed(int id)
{
Demande demande = db.Demandes.Find(id);
db.Demandes.Remove(demande);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult FormDemande()
{
Demande p = new Demande();
IEnumerable <Categorie> cats = dbContext.ListeCategories.ToList();
ViewBag.categories = cats;
return(View("FormDemande", p));
}
// GET: Demandes/Create
public async Task <ActionResult> Create()
{
var etudiant = (Etudiant)Session["etudiant"];
var demande = new Demande {
Etudiant = etudiant
};
return(View(demande));
}
[HttpGet] //optionnelle
public ActionResult Delete(int id)
{
Demande d = new Demande();
d.DemandeID = id;
dbContext.ListeDemandes.Remove(d);
dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
private void Load()
{
ListeDemandes = new ObservableCollection <Demande>(_ctx.Demandes.OrderBy(d => d.Client.Nom));
ListeOffres = new ObservableCollection <Offre>(_ctx.Offres);
if (CurrentDemande == null)
{
CurrentDemande = new Demande();
}
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Commentaire,Etat")] Demande demande)
{
if (!ModelState.IsValid)
{
return(View(demande));
}
var result = await api.Put(uri + demande.IdDemande, demande);
return(RedirectToAction("Index"));
}
public ActionResult Editer(int id)
{
Demande d = new Demande();
d.DemandeID = id;
IEnumerable <Categorie> cats = dbContext.ListeCategories.ToList();
ViewBag.categories = cats;
return(View("DemandeFormEdit", d));
}
public ActionResult Demander(Demande dm)
{
if (ModelState.IsValid)
{
db.Demandes.Add(dm);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public async Task <IActionResult> Create([Bind("DemandeID,ID_stage,ID_student,etat")] Demande demande)
{
if (ModelState.IsValid)
{
_context.Add(demande);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(demande));
}
public ActionResult Edit([Bind(Include = "id_demande,depart,arriver,date_depart,date_arriver,id_client,number")] Demande demande)
{
if (ModelState.IsValid)
{
db.Entry(demande).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_client = new SelectList(db.Clients, "id_utilisateur", "id_utilisateur", demande.id_client);
return(View(demande));
}
//Afficher les reponses
public static void AfficherReponses(String Cin, ref DataGridView Grille)
{
Demande demande = new Demande();
DataTable tab = new DataTable();
//Afficher les réponses
demande.AfficherDerniersDemandes(Cin, ref tab);
//Afficher les réponses dans la grille
Grille.DataSource = tab;
}
//Enregistrement de la demande
public static void EnregistrerDemande(String CIN, String Type, DateTime DateDebut, DateTime DateFin, String Commentaire)
{
Int32 NombreJours = Convert.ToInt32((DateFin.Date - DateDebut.Date).TotalDays);
//Enregistremet des données
Demande demande = new Demande(CIN, Type, DateTime.Now, DateDebut, DateFin, NombreJours, Commentaire);
//Message
MyMessageBox.MyMessageBox message = new MyMessageBox.MyMessageBox("Information", "Votre demande ajouter avec succés.");
message.ShowDialog();
}
//Afficher tout les demande
public static void AfficherDemandes(ref DataGridView Grille)
{
Demande demande = new Demande();
DataTable tab = new DataTable();
//l'appel de la méthode
demande.AfficherToutesDemandes(ref tab);
//Affichage des données
Grille.DataSource = tab;
}
public IHttpActionResult PostDemande(Demande demande)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Demandes.Add(demande);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = demande }, demande));
}
public Demande GetDemandeById(int id)
{
try
{
gestion_agentEntities1 context = new gestion_agentEntities1();
Demande t = context.Demande.Where(e => e.id == id).FirstOrDefault <Demande>();
return(t);
}
catch (Exception)
{
throw;
}
}
public IActionResult Demande()
{
Console.WriteLine("from Demande function " + StudentController.apoge);
Console.WriteLine("from Demande function viewData " + ViewData["apoge"]);
Demande dd = new Demande();
dd.idStudent = StudentController.apoge;
if (dd.checkDemande() == 1)
{
ViewData["button"] = "disabled";
}
return(View());
}
public bool CreateDemande([FromBody] Demande demande)
{
bool status = false;
if (ModelState.IsValid)
{
if (IngenieurDAO.AddDemande(demande, myConnection) > 0)
{
status = true;
}
}
return(status);
}
/// <summary>
/// Get unit of product by name
/// </summary>
/// <param name="name">unit name</param>
/// <returns></returns>
public Demande GetDemandeBLByName(string name)
{
try
{
gestion_agentEntities1 context = new gestion_agentEntities1();
Demande t = context.Demande.Where(e => e.Precisions == name).FirstOrDefault <Demande>();
return(t);
}
catch (Exception)
{
throw;
}
}
public IActionResult SaveDemande(Demande p)
{
if (ModelState.IsValid)
{
dbContext.ListeDemandes.Add(p);
dbContext.SaveChanges();
return(RedirectToAction("Index")); //retour à l'index apres l'enregistrement
}
IEnumerable <Categorie> cats = dbContext.ListeCategories.ToList();
ViewBag.categories = cats;
return(View("FormDemande", p));
}
public List<Demande> getAllDemands()
{
List<Demande> lesDemandes = new List<Demande>();
string query = "SELECT nodemande, datedem, debut, fin, remarque, `status`, remgsb, produits.nom, user.nom, pharma.nom FROM demande inner join produits on demande.idprod = produits.idprod left join pharma on demande.idpharma = pharma.idpharma left join user on demande.uid = user.uid";
MySqlCommand cmd = new MySqlCommand(query, con);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
int i = Convert.ToInt16(rdr[0].ToString());
string d = rdr[1].ToString();
string deb = rdr[2].ToString();
string fin = rdr[3].ToString();
string rq = rdr[4].ToString();
string status = rdr[5].ToString();
string remgsb = rdr[6].ToString();
string produit = rdr[7].ToString();
string animateur = rdr[8].ToString();
string pharmacie = rdr[9].ToString();
Demande dmd = new Demande(i, d, deb, fin, rq, status, remgsb, produit, animateur, pharmacie);
lesDemandes.Add(dmd);
}
return lesDemandes;
}
