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