public async Task<ActionResult> SaveDataContact(ContactModel f) { if (ModelState.IsValid) { D.Open(); bool check = D.DataSearch("SELECT * FROM table_form WHERE Email = '" + f.Email + "' "); D.Close(); if (check == false) { if (Request.Files.Count > 0) { var file = Request.Files[0]; if (file != null && file.ContentLength > 0) { // αποθηκεύουμε το αρχείο στο σημείο που θέλουμε και πέρχουμε το όνομα του αρχείου για να το αποθηκεύσουμε στην συνεχεια στην βδ f.nameofcv = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/App_Data/uploads"), f.nameofcv); file.SaveAs(path); D.Open(); int i = D.DataInsert("INSERT INTO table_form(First_Name,Last_Name,Age,Email,Comments,File_Name,Job_Title) VALUES ('" + f.FirstName + "','" + f.LastName + "','" + f.Age + "','" + f.Email + "','" + f.Comments + "','" + file.FileName + "','" + f.nameofjob + "')"); if (i > 0) { ModelState.AddModelError("Success", "Save Success"); } else { ModelState.AddModelError("Error", "Save Error"); } TempData["notice"] = 1; await SendEmail(f.Email, f.nameofjob,f.LastName); } } D.Close(); } else { TempData["check_db"] = 1; } } return RedirectToAction("ContactForm", "Contact"); }
public ActionResult DeleteApplier(ContactModel f) { string fullPath = Request.MapPath("~/App_Data/uploads/" + f.nameofcv); System.IO.File.Delete(fullPath); D.Open(); int i = D.DataDelete("DELETE FROM table_form WHERE Email= '" + f.Email + "' "); D.Close(); if (i > 0) {ModelState.AddModelError("Success", "Save Success");} else {ModelState.AddModelError("Error", "Save Error");} return RedirectToAction("Jobs", "Dashboard"); }
public ActionResult SaveDataContact(ContactModel f) { if (ModelState.IsValid) { D.Open(); int i=D.DataInsert("INSERT INTO table_cont(Name,Email,Comments) VALUES ('" + f.Name + "','" + f.Email + "','" + f.Comments + "')"); if (i>0) { ModelState.AddModelError("Success","Save Success"); } else { ModelState.AddModelError("Error", "Save Error"); } D.Close(); } return RedirectToAction("Index", "Home"); }
public ActionResult Jobs() { ContactModel p = new ContactModel(); List<ContactModel> Li = new List<ContactModel>(); Li = p.JobDisplay(); ViewData["JobDisplay"] = Li; return View(); }
public List<ContactModel> JobDisplay() { SqlConnection con = new SqlConnection(constr); con.Open(); using (con) { SqlCommand cmd = new SqlCommand("Select * from table_form ", con); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { p = new ContactModel(); p.FirstName = Convert.ToString(rd.GetSqlValue(1)); p.LastName = Convert.ToString(rd.GetSqlValue(2)); p.Age = (int)rd["Age"]; p.Email = Convert.ToString(rd.GetSqlValue(4)); p.Comments = Convert.ToString(rd.GetSqlValue(5)); p.nameofcv = Convert.ToString(rd.GetSqlValue(6)); p.nameofjob = Convert.ToString(rd.GetSqlValue(7)); JobList.Add(p); } } return JobList; }