public ActionResult ChangePassword(ChangePassword cp)
{
cp.msg = "";
if (ModelState.IsValid)
{
try
{
int userId = int.Parse(User.Identity.Name);
string encPass = EncrypHelpers.Encrypt(cp.OldPassword);
ass_user user = db.ass_user
.Where(a => a.id == userId && a.password.Equals(encPass))
.FirstOrDefault();
if (user != null)
{
user.password = EncrypHelpers.Encrypt(cp.NewPassword);
db.SaveChanges();
cp.msg = "Password Has Been Changed.";
}
else
{
ModelState.AddModelError("", "OldPassword is incorrect!");
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.ToString());
}
}
//return RedirectToAction("AfterLogin");
return(View(cp));
}
public ActionResult Login(LoginModel userLogin)
{
if (ModelState.IsValid)
{
try
{
string encPass = EncrypHelpers.Encrypt(userLogin.password);
ass_user user = db.ass_user
.Where(a => a.username.Equals(userLogin.username) && a.password.Equals(encPass))
.FirstOrDefault();
if (user != null)
{
Session["userid"] = user.id;
Session["username"] = user.username;
Session["fullname"] = user.fullname;
FormsAuthentication.SetAuthCookie(user.id.ToString(), false);
return(RedirectToAction("Index", "AssReminder"));
}
else
{
ModelState.AddModelError("", "Login data is incorrect!");
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.ToString());
}
}
//return RedirectToAction("AfterLogin");
return(View(userLogin));
}
public JsonResult ResetPassword(LoginModel dataChange)
{
try
{
if (Session["username"] == null || Session["username"].ToString().ToLower() != "admin")
{
return(Json(new { success = 0, username = dataChange.username, ex = "You don't have a privillages to reset password." }));
}
ass_user user = db.ass_user
.Where(a => a.username == dataChange.username)
.FirstOrDefault();
if (user == null)
{
return(Json(new { success = 0, username = dataChange.username, ex = "User Not Found." }));
}
user.password = EncrypHelpers.Encrypt("123456");
db.SaveChanges();
return(Json(new { success = 1, username = dataChange.username, ex = "Password has been reset." }));
}
catch (Exception ex)
{
return(Json(new { success = 0, username = dataChange.username, ex = ex.ToString() }));
}
}
public ActionResult Edit([Bind(Include = "id,ent_cd,email,password,url_logo,ent_descs,ent_address,ttd_name,ttd_title,email_template,tempTemplate")] ass_email_sender ass_email_sender)
{
if (ModelState.IsValid)
{
ass_email_sender.password = EncrypHelpers.Encrypt(ass_email_sender.password);
ass_email_sender.email_template = ass_email_sender.tempTemplate;
db.Entry(ass_email_sender).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ass_email_sender));
}
// GET: AssEmailSender/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ass_email_sender ass_email_sender = db.ass_email_sender.Find(id);
if (ass_email_sender == null)
{
return(HttpNotFound());
}
ass_email_sender.password = EncrypHelpers.Decrypt(ass_email_sender.password);
ass_email_sender.tempTemplate = ass_email_sender.email_template;
return(View(ass_email_sender));
}
public ActionResult Create([Bind(Include = "id,username,fullname")] ass_user ass_user)
{
if (Session["username"] == null || Session["username"].ToString().ToLower() != "admin")
{
return(new HttpStatusCodeResult(HttpStatusCode.NotFound));
}
if (ModelState.IsValid)
{
ass_user.password = EncrypHelpers.Encrypt("123456");
ass_user.audit_date = DateTime.Now;
ass_user.user_id = int.Parse(User.Identity.Name);
db.ass_user.Add(ass_user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ass_user));
}
public JsonResult CreateJson(AddStatus status)
{
string messageResult = "Progress has been updated";
using (var dbTrans = db.Database.BeginTransaction())
{
try
{
foreach (AddStatusDtl dtl in status.dtl)
{
ass_complaint_dtl compDtl = db.ass_complaint_dtl.Where(a => a.id == dtl.compDtlId).FirstOrDefault();
if (compDtl != null)
{
compDtl.curr_status_id = dtl.statusId;
ass_status_update up = new ass_status_update
{
compdtl_id = dtl.compDtlId,
status_id = dtl.statusId,
status_date = DateTime.Today,
remark = dtl.remark,
user_id = int.Parse(User.Identity.Name)
};
db.ass_status_update.Add(up);
db.SaveChanges();
ass_complaint complaint = db.ass_complaint
.Where(a => a.id == compDtl.comp_id)
.FirstOrDefault();
if (!complaint.ass_complaint_dtl.Where(x => x.curr_status_id == null || !x.ass_status.name.Contains("CLOSED")).Any())
{
complaint.closing_date = DateTime.Today;
}
bool cancel = true;
foreach (ass_complaint_dtl itemDtl in complaint.ass_complaint_dtl)
{
if (!itemDtl.currentStatus.Contains("CANCEL"))
{
cancel = false;
}
}
if (cancel)
{
complaint.cancel_date = DateTime.Now;
}
ass_status currentStatus = db.ass_status.Where(a => a.id == dtl.statusId).FirstOrDefault();
if (currentStatus != null && currentStatus.name.Contains("DONE") && complaint.cp_email != "")
{
if (!complaint.ass_complaint_dtl.Where(x => x.curr_status_id == null || (!x.ass_status.name.Contains("CLOSED") && !x.ass_status.name.Contains("DONE"))).Any())
{
//#GET SENDER EMAIL
ass_email_sender mailSender = db.ass_email_sender.FirstOrDefault();
string templateBody = mailSender.email_template;
//#SEND EMAIL
DateTime today = DateTime.Today;
string mailNo = today.Day.ToString() + "/ASS-GLC/" + IntExtensions.ToRomanNumeral(today.Month) + "/" + today.Year;
string templateHTML;
//Read template file from the App_Data folder
using (var sr = new StreamReader(Server.MapPath("\\App_Data\\Templates\\") + "MailAssDone.html"))
{
templateHTML = sr.ReadToEnd();
}
MailMessage mail = new MailMessage();
mail.To.Add(complaint.cp_email);
//mail.To.Add("*****@*****.**");
//mail.From = new MailAddress("*****@*****.**");
mail.From = new MailAddress(mailSender.email);
mail.Subject = "Surat Pemberitahuan Komplain Telah Selesai";
string messageBody = @"
<table style='width:100%'>
<tr>
<th>#</th>
<th>Uraian Checklist</th>
<th>Proses</th>
<th>Keterangan</th>
</tr>";
int x = 1;
foreach (ass_complaint_dtl ass_complaint_dtl in complaint.ass_complaint_dtl)
{
string descs = ass_complaint_dtl.ass_category.name + " "
+ ass_complaint_dtl.ass_location.name + " "
+ ass_complaint_dtl.descs;
string contentDtl = "<tr>";
contentDtl += "<td>" + x.ToString() + "</td>";
contentDtl += "<td>" + descs + "</td>";
contentDtl += "<td>" + ass_complaint_dtl.currentStatus + "</td>";
contentDtl += "<td>" + ass_complaint_dtl.currentRemark + "</td>";
contentDtl += "</tr>";
messageBody += contentDtl;
x++;
}
messageBody += "</table>";
string Body = templateBody.Replace("{emailNo}", mailNo)
.Replace("{cluster}", complaint.pm_tenancy.pl_project.descs)
.Replace("{lotNo}", complaint.lot_no)
.Replace("{date}", DateTime.Today.ToString("dd MMMM yyyy"))
.Replace("{complaintDetail}", messageBody)
.Replace("{complaintDate}", complaint.check_date.ToString("dd MMM yyyy"));
Body = templateHTML.Replace("{body}", Body);
mail.Body = Body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "mx.agungsedayu.com";
smtp.Port = 25;
smtp.UseDefaultCredentials = false;
//smtp.Credentials = new System.Net.NetworkCredential
//("*****@*****.**", "aqswde123");// Enter seders User name and password
smtp.Credentials = new System.Net.NetworkCredential
(mailSender.email, EncrypHelpers.Decrypt(mailSender.password));// Enter seders User name and password
smtp.EnableSsl = true;
smtp.Send(mail);
ass_complaint_mail compMail = new ass_complaint_mail
{
mail_no = mailNo,
email_to = complaint.cp_email,
mail_date = today,
comp_id = complaint.id,
user_id = int.Parse(User.Identity.Name),
audit_date = DateTime.Now
};
db.ass_complaint_mail.Add(compMail);
db.SaveChanges();
//#END SEND EMAIL
messageResult = "Progress has been updated and Email has been sent.";
}
}
db.SaveChanges();
}
}
dbTrans.Commit();
return(Json(new { success = 1, ex = messageResult }));
}
catch (Exception ex)
{
dbTrans.Rollback();
return(Json(new { success = 0, ex = ex.ToString() }));
}
}
}
