public ActionResult EditarSenha()
{
int id = Int32.Parse(Request.Form["id_usuario"]);
usuario_grupo ug = db.usuario_grupo.Where(
p => p.id_grupo.Equals(4)
).Where(x => x.id_usuario.Equals(id)).FirstOrDefault();
if (ug == null)
{
return(HttpNotFound());
}
usuario u = db.usuario.Find(id);
u.senha = Criptografia.Codifica(Request.Form["senha"]);
db.SaveChanges();
rec r = db.rec.Where(
p => p.id_suario.Equals(u.id_usuario)
).FirstOrDefault();
while (r != null)
{
db.rec.Remove(r);
db.SaveChanges();
r = db.rec.Where(
p => p.id_suario.Equals(u.id_usuario)
).FirstOrDefault();
}
db.usuario_grupo.Remove(ug);
return(RedirectToAction("Login", "Account"));
}
// <param name = "idususario" ></ param >
// <returns></returns>
public ActionResult RecuperaSenha(int idususario, string code)
{
usuario usr = db.usuario.Find(idususario);
if (usr == null)
{
return(HttpNotFound());
}
usuario_grupo ug = db.usuario_grupo.Where(
p => p.id_grupo.Equals(4)
).Where(x => x.id_usuario.Equals(usr.id_usuario)).FirstOrDefault();
if (ug == null)
{
TempData["Error"] = "Usuário sem solicitacao de troca de senha!";
return(RedirectToAction("Login", "Account"));
}
rec r = db.rec.Where(
p => p.id_suario.Equals(usr.id_usuario)
).Where(x => x.str.Equals(code)).FirstOrDefault();
if (r == null)
{
TempData["Error"] = "Código de verificação inválido!";
return(RedirectToAction("Login", "Account"));
}
usr.senha = null;
return(View(usr));
}
public ActionResult Edit(int id, rec r1)
{
try
{
if (ModelState.IsValid)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Reclamation recl = rs.GetById(id);
recl.objet = r1.objet;
recl.contenu = r1.contenu;
recl.status = r1.status;
recl.type = r1.type;
recl.dateDebut = r1.dateDebut;
recl.dateFin = r1.dateFin;
if (recl == null)
{
return(HttpNotFound());
}
rs.Update(recl);
rs.Commit();
return(RedirectToAction("Index"));
}
return(View(r1));
}
catch
{
return(View("~/Views/Shared/Customer.cshtml"));
}
}
static void Main(string[] args)
{
rec del = new rec(RectangleArea);
del += new rec(RectanglePerimeter);
del(5.5, 4.5);
Console.Read();
}
// GET: reclamationFront/Delete/5
public ActionResult Delete(int id)
{
Reclamation cm = new Reclamation();
cm = rs.GetById(id);
rec c = new rec();
c.type = cm.type;
c.objet = cm.objet;
c.status = cm.status;
c.dateDebut = cm.dateDebut;
c.dateFin = cm.dateFin;
c.contenu = cm.contenu;
return(View(c));
}
public ArrayList getConvBySPSerID(decimal sSerID, decimal pSerID)
{
ArrayList al = new ArrayList();
dt = ms.SelectSql("select * from YXZ_rec where sSerID=" + sSerID + " and pSerID=" + pSerID + " order by time;");
for (int i = 0; i < dt.Rows.Count; i++)
{
rec r = new rec();
r.recID = Convert.ToInt32(dt.Rows[i][0]);
r.sSerID = Convert.ToDecimal(dt.Rows[i][1]);
r.pSerID = Convert.ToDecimal(dt.Rows[i][2]);
r.question = dt.Rows[i][3].ToString();
r.msg = dt.Rows[i][4].ToString();
r.time = Convert.ToDateTime(dt.Rows[i][5]);
r.isConvAnnounced = Convert.ToInt32(dt.Rows[i][6]);
al.Add(r);
}
return(al);
}
public ActionResult Create(rec r, HttpPostedFileBase File)
{
if (!ModelState.IsValid || File == null || File.ContentLength == 0)
{
RedirectToAction("Create", "~/Views/Shared/_CustomerLayout.cshtml");
}
rs.Add(new Reclamation()
{
objet = r.objet,
contenu = r.contenu,
type = r.type,
dateDebut = System.DateTime.Now,
dateFin = System.DateTime.Now,
status = r.status,
ClientMoralFK = 1,
ClientPhysiqueFK = 1
});
rs.Commit();
return(View());
}
public ActionResult EnviaEmail()
{
string emailDigitado = Request.Form["pessoa.email"];
pessoa p1 = db.pessoa.Where(
p => p.email.Equals(emailDigitado)).FirstOrDefault();
if (p1 == null)
{
ModelState.AddModelError("Error", "Email não encontrado");
return(RedirectToAction("Login", "Account"));
}
usuario vUser = db.usuario.Where(
p => p.pessoa_id_pessoa.Equals(p1.id_pessoa)).FirstOrDefault();
rec r2 = db.rec.Where(
p => p.id_suario.Equals(vUser.id_usuario)
).FirstOrDefault();
while (r2 != null)
{
db.rec.Remove(r2);
db.SaveChanges();
r2 = db.rec.Where(
p => p.id_suario.Equals(vUser.id_usuario)
).FirstOrDefault();
}
rec r = new rec();
r.id_suario = vUser.id_usuario;
Random rnd = new Random();
rnd.Next(100, 1000000);
r.str = rnd.Next(100, 1000000).ToString();
db.rec.Add(r);
db.SaveChanges();
MailMessage mail = new MailMessage();
mail.To.Add(p1.email);
mail.From = new MailAddress("*****@*****.**");
mail.Subject = "Passwor Recovery";
string Body = "http://rodrigolucke-001-site1.itempurl.com//Account/RecuperaSenha?idususario=" + vUser.id_usuario + "&code=" + r.str;
mail.Body = Body;
SmtpClient smtp = new SmtpClient("smtp.gmail.com", 25);
smtp.UseDefaultCredentials = false;
smtp.EnableSsl = true;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "colegio.01");
smtp.Send(mail);
usuario_grupo ug2 = new usuario_grupo();
ug2 = db.usuario_grupo.Where(
p => p.id_usuario.Equals(vUser.id_usuario)
).Where(x => x.id_grupo.Equals(4)).FirstOrDefault();
while (ug2 != null)
{
db.usuario_grupo.Remove(ug2);
db.SaveChanges();
ug2 = db.usuario_grupo.Where(
p => p.id_usuario.Equals(vUser.id_usuario))
.Where(x => x.id_grupo.Equals(4)).FirstOrDefault();
}
usuario_grupo ug = new usuario_grupo();
ug.id_usuario = vUser.id_usuario;
ug.id_grupo = 4;
db.usuario_grupo.Add(ug);
db.SaveChanges();
return(RedirectToAction("Login", "Account"));
}
public ArrayList getConvBySPSerID(decimal sSerID, decimal pSerID)
{
ArrayList al = new ArrayList();
dt = ms.SelectSql("select * from YXZ_rec where sSerID=" + sSerID + " and pSerID=" + pSerID + " order by time;");
for (int i = 0; i < dt.Rows.Count;i++)
{
rec r = new rec();
r.recID = Convert.ToInt32(dt.Rows[i][0]);
r.sSerID = Convert.ToDecimal(dt.Rows[i][1]);
r.pSerID = Convert.ToDecimal(dt.Rows[i][2]);
r.question = dt.Rows[i][3].ToString();
r.msg = dt.Rows[i][4].ToString();
r.time = Convert.ToDateTime(dt.Rows[i][5]);
r.isConvAnnounced = Convert.ToInt32(dt.Rows[i][6]);
al.Add(r);
}
return al;
}
