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; }