public bool PostList([FromBody] List <Contact_us> contact_usList) { bool status = false; try { Contact_us temp; foreach (Contact_us contact_us in contact_usList) { temp = new Contact_us(); temp.Id = Guid.NewGuid(); temp.Name = contact_us.Name; temp.UserComments = contact_us.UserComments; temp.Phone = contact_us.Phone; temp.Email = contact_us.Email; temp.PostTime = DateTime.UtcNow.AddHours(08); db.Contact_us.Add(temp); } db.SaveChanges(); status = true; } catch (Exception ex) { throw; } return(status); }
public ActionResult DeleteConfirmed(Guid id) { Contact_us contact_us = db.Contact_us.Find(id); db.Contact_us.Remove(contact_us); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Name,Email,Phone,UserComments,PostTime")] Contact_us contact_us) { if (ModelState.IsValid) { db.Entry(contact_us).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(contact_us)); }
public string Delete(Contact_us contact_us, Guid id) { contact_us = db.Contact_us.Find(id); if (contact_us != null) { db.Contact_us.Remove(contact_us); db.SaveChanges(); return("OK"); } return("找不到要刪除的參數"); }
//[HttpPost] //[ValidateAntiForgeryToken] public ActionResult Index(Contact_us contact_us) { if (ModelState.IsValid && contact_us.Name != null) { contact_us.Id = Guid.NewGuid(); contact_us.PostTime = DateTime.UtcNow.AddHours(08); db.Contact_us.Add(contact_us); db.SaveChanges(); return(RedirectToAction("Index")); //重新都入,也可以將text-lable中的文字資料清除 } return(View()); }
public ActionResult Create(Contact_us contact_us) { if (ModelState.IsValid) { contact_us.Id = Guid.NewGuid(); contact_us.PostTime = DateTime.UtcNow.AddHours(08); db.Contact_us.Add(contact_us); db.SaveChanges(); return(RedirectToAction("Create")); } return(View(contact_us)); }
public ActionResult Contact2(Contact_us Contact_us) { if (ModelState.IsValid) { db.Contact_us.Add(Contact_us); db.SaveChanges(); TempData["message2"] = "Your Message Sent Successfully"; return(RedirectToAction("Index")); } return(View(Contact_us)); }
// GET: Contact_us/Delete/5 public ActionResult Delete(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Contact_us contact_us = db.Contact_us.Find(id); if (contact_us == null) { return(HttpNotFound()); } return(View(contact_us)); }
public string Post(Contact_us contact_us, string name, string email, string phonenumber, string content) { try { db.Contact_us.Add(new Contact_us { Id = Guid.NewGuid(), Name = name, UserComments = content, Phone = phonenumber, Email = email, PostTime = DateTime.UtcNow.AddHours(08) }); db.SaveChanges(); return("OK"); } catch (Exception) { return("資料無法傳入"); } }
public bool ContactUS(Contact_us _cont_us, bool _mail_status) { string Connection_string = ConfigurationManager.ConnectionStrings[ConnectionName].ConnectionString; using (SqlConnection conn = new SqlConnection(Connection_string)) { conn.Open(); SqlCommand cmd = new SqlCommand("USP_ContactUSInsert", conn); cmd.CommandType = CommandType.StoredProcedure; if (conn.State == ConnectionState.Open) { try { SqlParameter paramName = new SqlParameter(); paramName.ParameterName = "@Name"; paramName.Value = _cont_us.Name; cmd.Parameters.Add(paramName); SqlParameter paramEmail = new SqlParameter(); paramEmail.ParameterName = "@Email"; paramEmail.Value = _cont_us.Email; cmd.Parameters.Add(paramEmail); SqlParameter paramSubject = new SqlParameter(); paramSubject.ParameterName = "@Subject"; paramSubject.Value = _cont_us.Subject; cmd.Parameters.Add(paramSubject); SqlParameter paramMessage = new SqlParameter(); paramMessage.ParameterName = "@Message"; paramMessage.Value = _cont_us.Message; cmd.Parameters.Add(paramMessage); cmd.ExecuteNonQuery(); string smtpAddress = "smtpout.secureserver.net"; int portNumber = 80; //bool enableSSL = true; string emailFrom = _cont_us.Email; string password = "******"; string emailTo = "*****@*****.**"; string subject = _cont_us.Subject; string body = _cont_us.Message; using (MailMessage mail = new MailMessage()) { mail.From = new MailAddress(emailFrom); mail.To.Add(emailTo); mail.Subject = subject; mail.Body = body; mail.IsBodyHtml = true; // Can set to false, if you are sending pure text. //mail.Attachments.Add(new Attachment("C:\\SomeFile.txt")); //mail.Attachments.Add(new Attachment("C:\\SomeZip.zip")); using (SmtpClient smtp = new SmtpClient(smtpAddress, portNumber)) { smtp.Credentials = new NetworkCredential("*****@*****.**", password); //smtp.EnableSsl = enableSSL; smtp.Send(mail); _mail_status = true; } } } catch (Exception ex) { _mail_status = false; throw; } } } return(_mail_status); }