public ActionResult StorageArticle(Models.Article model)
{
if (Session["idProfile"] != null)
{
ConnectionDataBase.StoreProcediur data = new ConnectionDataBase.StoreProcediur();
var nomaas = Request.Files;
for (var i = 0; i < nomaas.Count; i++)
{
if (nomaas[i].ContentLength > 0)
{
string FileName = Path.GetFileNameWithoutExtension(nomaas[i].FileName);
string FileExtension = Path.GetExtension(nomaas[i].FileName);
FileName = DateTime.Now.ToString("yyyyMMdd") + "_" + FileName.Trim() + FileExtension;
string UploadPath = System.Web.HttpContext.Current.Server.MapPath("/Content/images/");
string stringimg = "/Content/images/" + FileName;
nomaas[i].SaveAs(UploadPath + FileName);
model.Image = "/Content/images/" + FileName;
}
}
DataTable td = data.StorageArticle(model);
return(RedirectToAction("Catalogo", "Home"));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult CreateUser(WebPlastic.Models.User model)
{
ConnectionDataBase.StoreProcediur data = new ConnectionDataBase.StoreProcediur();
CredencialesDeAcceso access = new CredencialesDeAcceso();
string password = access.CreatePassword();
RijndaelManaged myRijndael = new RijndaelManaged();
myRijndael.GenerateKey();
myRijndael.GenerateIV();
string user = access.CreateUserName(model.Name, model.Last).ToLower();
model.UserName = user;
Byte[] contrasenaEncriptada = access.EncryptStringToBytes(password, myRijndael.Key, myRijndael.IV);
DataTable dt = data.SaveUser(model, contrasenaEncriptada, myRijndael.Key, myRijndael.IV);
DataRow row = dt.Rows[0];
if (dt.Rows.Count > 0)
{
SentEmail correoCreacion = new SentEmail();
string bodyCorreo = correoCreacion.EmailForNewUser(model.Name, model.Last, model.UserName, password);
correoCreacion.SendEmailForNewUser(model.Email, "Creación de Usuario", "*****@*****.**", bodyCorreo, "*****@*****.**", "*****@*****.**", "hola1234", "");
}
return(RedirectToAction("Index"));
}
// GET: Administrator
public ActionResult MyProfile()
{
ConnectionDataBase.StoreProcediur data = new ConnectionDataBase.StoreProcediur();
DataTable dt = data.GetUser(Convert.ToInt32(Session["idUser"]));
ViewBag.User = dt.Rows[0];
return(View());
}
public ActionResult editUser(int id)
{
ConnectionDataBase.StoreProcediur data = new ConnectionDataBase.StoreProcediur();
DataTable dt = data.GetUser(id);
ViewBag.Userr = dt.Rows;
return(View());
}
public ActionResult Login(Models.Login model)
{
Session["idUser"] = null;
Session["idProfile"] = null;
Session["Name"] = null;
if (model.UserName != null)
{
ConnectionDataBase.StoreProcediur data = new ConnectionDataBase.StoreProcediur();
CredencialesDeAcceso acceso = new CredencialesDeAcceso();
DataTable dt = data.ValidarIngresoUsuario(model.UserName, GetMACAddress().ToString());
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
byte[] password = (byte[])row["Password"];
byte[] key = (byte[])row["pKEY"];
byte[] iv = (byte[])row["pIV"];
if (password.Length > 2)
{
string finalpassword = acceso.DecryptStringFromBytes(password, key, iv);
if (finalpassword == model.Password)
{
dynamic dol = null;
if (dt.Rows.Count == 1)
{
dol = dt.Rows[0];
}
else
{
dol = dt.Rows[1];
}
Session["idUser"] = row["idUser"].ToString();
Session["idProfile"] = row["idProfile"].ToString();
Session["Name"] = row["Name"].ToString();
Session["Last"] = row["Last"].ToString();
Session["Email"] = row["Email"].ToString();
Session["Profile"] = row["Profile"].ToString();
return(RedirectToAction("Index", "Home"));
}
else
{
Session["message"] = "Las credenciales de usuario no coinciden, verifique.";
}
}
}
else
{
Session["message"] = "No se encontro datos de usuario con esas credenciales, por favor cree uno.";
}
Session["title"] = "Error";
Session["type"] = "error";
}
return(RedirectToAction("Index"));
}
public ActionResult Catalogo()
{
ConnectionDataBase.StoreProcediur data = new ConnectionDataBase.StoreProcediur();
DataTable td = data.GetArticle();
ViewBag.Article = td.Rows;
td = data.GetCategory();
ViewBag.Category = td.Rows;
return(View());
}
public ActionResult MyCart()
{
ConnectionDataBase.StoreProcediur data = new ConnectionDataBase.StoreProcediur();
DataTable td = data.GetCart(Convert.ToInt32(Session["idUser"]));
ViewBag.Articles = td.Rows;
td = data.GetArticle();
ViewBag.Article = td.Rows;
return(View());
}
public ActionResult Users()
{
ConnectionDataBase.StoreProcediur data = new ConnectionDataBase.StoreProcediur();
DataTable dt = data.ObtenerData("SP_GetUser");
ViewBag.User = dt.Rows;
return(View());
}
public ActionResult UpdateUser(Models.User model)
{
ConnectionDataBase.StoreProcediur data = new ConnectionDataBase.StoreProcediur();
model.idUser = (Convert.ToInt32(Session["idUser"]));
DataTable dt = data.UpdateUser(model);
ViewBag.Userr = dt.Rows;
return(RedirectToAction("MyProfile"));
}
public ActionResult AddCart(int id)
{
if (Session["idProfile"] != null)
{
ConnectionDataBase.StoreProcediur data = new ConnectionDataBase.StoreProcediur();
DataTable td = data.AddCart(id, Convert.ToInt32(Session["idUser"]));
ViewBag.Article = td.Rows;
return(RedirectToAction("MyCart", "Administrator"));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
//chages
public ActionResult CreateArticle()
{
if (Session["idProfile"] != null)
{
ConnectionDataBase.StoreProcediur data = new ConnectionDataBase.StoreProcediur();
DataTable td = data.GetCategory();
ViewBag.Category = td.Rows;
return(View());
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
