public ActionResult SignIn(FormCollection f)
{
string sUs = f["txtUserName"].ToString();
string sPs = f["txtPassword"].ToString();
TSql_Informations info_user = db.TSql_Informations.Where(t => t.Role == 0).SingleOrDefault(t => t.UserName == sUs && t.Password == sPs);
TSql_Informations info_ad1 = db.TSql_Informations.Where(t => t.Role == 1).SingleOrDefault(t => t.UserName == sUs && t.Password == sPs);
TSql_Informations info_ad2 = db.TSql_Informations.Where(t => t.Role == 2).SingleOrDefault(t => t.UserName == sUs && t.Password == sPs);
if (info_user != null)
{
Session["flag"] = info_user;
Session["user"] = info_user;
}
if (info_ad1 != null)
{
Session["flag"] = info_ad1;
Session["ad"] = info_ad1;
Session["ad1"] = info_ad1;
}
if (info_ad2 != null)
{
Session["flag"] = info_ad2;
Session["ad"] = info_ad2;
Session["ad2"] = info_ad2;
}
return(Redirect(Request.UrlReferrer.ToString()));
}
public ActionResult SendEmail(EmployeeModel obj)
{
try
{
//Configuring webMail class to send emails
//gmail smtp server
WebMail.SmtpServer = "smtp.gmail.com";
//gmail port to send emails
WebMail.SmtpPort = 587;
WebMail.SmtpUseDefaultCredentials = true;
//sending emails with secure protocol
WebMail.EnableSsl = true;
//EmailId used to send emails from application
WebMail.UserName = "******";
WebMail.Password = "******";
TSql_Informations info = db.TSql_Informations.SingleOrDefault(t => t.UserName == obj.ToEmail);
//Sender email address.
WebMail.From = "*****@*****.**";
obj.EmailSubject = "Reset Password";
obj.EMailBody = "<a href='https://localhost:44343/ForgotPassword/ResetPassword/" + info.IDInfo + "?token=" + info.ForgotPasswordCode + "'>Reset Password</a>";
//Send email
WebMail.Send(to: obj.ToEmail, subject: obj.EmailSubject, body: obj.EMailBody, cc: obj.EmailCC, bcc: obj.EmailBCC, isBodyHtml: true);
ViewBag.Status = "Email Sent Successfully.";
}
catch (Exception)
{
ViewBag.Status = "Problem while sending email, Please check details.";
}
return(View());
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
TSql_Informations tSql_Informations = await db.TSql_Informations.FindAsync(id);
db.TSql_Informations.Remove(tSql_Informations);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult PostReply(TSql_Reply rep, int idcmt)
{
TSql_Informations info = (TSql_Informations)Session["flag"];
rep.IDInfo = info.IDInfo;
rep.IDComment = idcmt;
rep.DatePost = DateTime.Now;
db.TSql_Reply.Add(rep);
db.SaveChanges();
return(Redirect(Request.UrlReferrer.ToString()));
}
public ActionResult PostComment(TSql_Comment cmt)
{
TSql_Informations info = (TSql_Informations)Session["flag"];
cmt.IDInfo = info.IDInfo;
cmt.DatePost = DateTime.Now;
cmt.IDFilm = Int32.Parse(Session["tmpFilm"].ToString());
db.TSql_Comment.Add(cmt);
db.SaveChanges();
return(Redirect(Request.UrlReferrer.ToString()));
}
public async Task <ActionResult> Create([Bind(Include = "IDInfo,DisplayName,UserName,Password,Role,DateCreate,ForgotPasswordCode")] TSql_Informations tSql_Informations)
{
if (ModelState.IsValid)
{
db.TSql_Informations.Add(tSql_Informations);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(tSql_Informations));
}
public ActionResult SignUp(TSql_Informations user)
{
if (ModelState.IsValid)
{
user.ForgotPasswordCode = Guid.NewGuid().ToString();
user.DateCreate = DateTime.Now;
db.TSql_Informations.Add(user);
db.SaveChanges();
Session["user"] = Session["flag"] = user;
}
return(Redirect("/Home/Index"));
}
public ActionResult Feedback(TSql_Chat fb)
{
if (ModelState.IsValid)
{
TSql_Informations info = (TSql_Informations)Session["flag"];
fb.IDUser = info.IDInfo;
fb.DateChat = DateTime.Now;
db.TSql_Chat.Add(fb);
db.SaveChanges();
}
return(Redirect(Request.UrlReferrer.ToString()));
}
// GET: Admin/TSql_Informations/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TSql_Informations tSql_Informations = await db.TSql_Informations.FindAsync(id);
if (tSql_Informations == null)
{
return(HttpNotFound());
}
return(View(tSql_Informations));
}
public async Task <ActionResult> Edit([Bind(Include = "IDInfo,DisplayName,UserName,Password,ConfirmPassword,Role,DateCreate,ForgotPasswordCode")] TSql_Informations tSql_Informations)
{
if (tSql_Informations.Password != tSql_Informations.ConfirmPassword)
{
return(RedirectToAction("Index"));
}
if (ModelState.IsValid)
{
db.Entry(tSql_Informations).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(tSql_Informations));
}
public async Task <ActionResult> ResetPassword(int?id, string token)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TSql_Informations tSql_Informations = await db.TSql_Informations.FindAsync(id);
Session["fgpw"] = tSql_Informations;
if (tSql_Informations == null)
{
return(HttpNotFound());
}
return(View(tSql_Informations));
}
public async Task <ActionResult> ResetPassword([Bind(Include = "IDInfo,DisplayName,UserName,Password,Role,ConfirmPassword")] TSql_Informations tSql_Informations)
{
if (tSql_Informations.Password != tSql_Informations.ConfirmPassword)
{
ViewBag.Status = "Password incorrect";
return(View());
}
if (ModelState.IsValid)
{
tSql_Informations.ForgotPasswordCode = Guid.NewGuid().ToString();
db.Entry(tSql_Informations).State = EntityState.Modified;
await db.SaveChangesAsync();
}
Session["user"] = Session["flag"] = Session["fgpw"];
Session["ffgpw"] = null;
return(View());
}
