public int CrudUser(int Action, Mod_Usr_Usuarios Modelo)
{
var Result = db.Database.ExecuteSqlCommand("SP_CRUD_USER @ACTION, @USRID, @NAME, @LASTN, @MAIL, @PHONE, @LOGIN, @PASS, @ACT",
new SqlParameter("@ACTION", Action),
new SqlParameter("@USRID", Modelo.Usr_Id),
new SqlParameter("@NAME", Modelo.Usr_Name),
new SqlParameter("@LASTN", Modelo.Usr_LastName),
new SqlParameter("@MAIL", Modelo.Usr_Mail),
new SqlParameter("@PHONE", Modelo.Usr_Phone),
new SqlParameter("@LOGIN", Modelo.Usr_Login),
new SqlParameter("@PASS", Modelo.Usr_Pass),
new SqlParameter("@ACT", Modelo.Usr_Active));
SendMailNewUser(Modelo.Usr_Mail, Modelo.Usr_Name);
return(Result);
}
public ActionResult NewAccount(Mod_Usr_Usuarios Usuario)
{
string Result = "";
var Exist = MTD.ValidLogin(Usuario.Usr_Login);
if (Exist != "0")
{
Result = "existe";
}
else
{
var Response = MTD.CrudUser(1, Usuario);
Result = Response.ToString();
}
return(Json(Result, JsonRequestBehavior.AllowGet));
}
public JsonResult Modify(Mod_Usr_Usuarios Usuario)
{
var Response = MTD.CrudUser(2, Usuario);
return(Json(Response, JsonRequestBehavior.AllowGet));
}
