public ActionResult DeleteConfirmed(string id)
{
tbl_req_mini tbl_req_mini = db.tbl_req_mini.Find(id);
db.tbl_req_mini.Remove(tbl_req_mini);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: ReqMini/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_req_mini tbl_req_mini = db.tbl_req_mini.Find(id);
if (tbl_req_mini == null)
{
return(HttpNotFound());
}
return(View(tbl_req_mini));
}
public ActionResult Edit(tbl_req_mini tbl_req_mini)
{
if (ModelState.IsValid)
{
db.Entry(tbl_req_mini).State = EntityState.Modified;
db.SaveChanges();
ViewBag.EmpCount = tbl_req_mini.MINI_CODE.ToString();
var email = Session["USER_EMAIL"].ToString();
MailMessage mm = new MailMessage();
mm.To.Add("*****@*****.**");
mm.From = new MailAddress(email);
mm.Subject = "แบบฟอร์มการขอและยกเลิกการใช้เครื่อง PDJMINI02";
mm.IsBodyHtml = true;
mm.Body = GetFormattedMessageIT();
SmtpClient smtp = new SmtpClient();
smtp.Host = "mail01.pranda.co.th";
smtp.Port = 25;
smtp.EnableSsl = false;
smtp.UseDefaultCredentials = true;
smtp.Credentials = new System.Net.NetworkCredential();
System.Net.ServicePointManager.ServerCertificateValidationCallback = delegate(object s,
System.Security.Cryptography.X509Certificates.X509Certificate certificate,
System.Security.Cryptography.X509Certificates.X509Chain chain,
System.Net.Security.SslPolicyErrors sslPolicyErrors)
{
return(true);
};
smtp.Send(mm);
return(RedirectToAction("Index"));
}
return(View(tbl_req_mini));
}
public ActionResult Create(tbl_req_mini tbl_req_mini)
{
if (ModelState.IsValid)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("AddReqMini", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@USER_NO", tbl_req_mini.USER_NO);
cmd.Parameters.AddWithValue("@MINI_DATE", tbl_req_mini.MINI_DATE);
cmd.Parameters.AddWithValue("@Allow_STATUS", tbl_req_mini.ALLOW_STATUS);
cmd.Parameters.AddWithValue("@MINI_SAMPLE", tbl_req_mini.MINI_SAMPLE);
cmd.Parameters.AddWithValue("@MINI_PROTO", tbl_req_mini.MINI_PROTO);
cmd.Parameters.AddWithValue("@MINI_INFORM", tbl_req_mini.MINI_INFORM);
cmd.Parameters.AddWithValue("@MINI_CHM", tbl_req_mini.MINI_CHM);
cmd.Parameters.AddWithValue("@REQ_STATUS", tbl_req_mini.REQ_STATUS);
cmd.Parameters.AddWithValue("@MINI_REQUESTER", tbl_req_mini.MINI_REQUESTER);
cmd.Parameters.Add("@MINI_CODE", SqlDbType.NVarChar, 20);
cmd.Parameters["@MINI_CODE"].Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
ViewBag.EmpCount = cmd.Parameters["@MINI_CODE"].Value.ToString();
ViewBag.Requester = cmd.Parameters["@USER_NO"].Value.ToString();
ViewBag.Date = cmd.Parameters["@MINI_DATE"].Value.ToString();
var email = Session["USER_EMAIL"].ToString();
var approve = Session["USER_EMAIL_APPROVE"].ToString();
MailMessage mm = new MailMessage();
mm.To.Add(approve);
mm.To.Add("*****@*****.**");
mm.From = new MailAddress(email);
mm.Subject = "แบบฟอร์มการขอและยกเลิกการใช้เครื่อง PDJMINI02";
mm.IsBodyHtml = true;
mm.Body = GetFormattedMessageHTML();
SmtpClient smtp = new SmtpClient();
smtp.Host = "mail01.pranda.co.th";
smtp.Port = 25;
smtp.EnableSsl = false;
smtp.UseDefaultCredentials = true;
smtp.Credentials = new System.Net.NetworkCredential();
System.Net.ServicePointManager.ServerCertificateValidationCallback = delegate(object s,
System.Security.Cryptography.X509Certificates.X509Certificate certificate,
System.Security.Cryptography.X509Certificates.X509Chain chain,
System.Net.Security.SslPolicyErrors sslPolicyErrors)
{
return(true);
};
smtp.Send(mm);
}
return(RedirectToAction("Index"));
}
ViewData["ALLOW_STATUS"] = new SelectList(db.tbl_req_allow_status, "ALLOW_STATUS", "ALLOW_DESC", tbl_req_mini.ALLOW_STATUS);
return(View(tbl_req_mini));
}
