public ActionResult account_settings()
{
if (Session["userLogged"] == null)
{
return(RedirectToAction("login", "User"));
}
var user = Session["userLogged"] as TradingVLU.Models.user;
using (vlutrading3545Entities db = new vlutrading3545Entities())
{
ViewBag.user_question = db.users.Join(db.security_question,
usr => user.id_security_question,
ques => ques.id,
(usr, ques) => new {
username = usr.username,
question = ques.question,
answer = usr.answer_security_question
}).ToList();
var user_detail = db.users.FirstOrDefault(usr => user.id == usr.id);
ViewBag.user_detail = user_detail;
}
return(View());
}
public ActionResult login(USERMetadata userLogin)
{
using (vlutrading3545Entities db = new vlutrading3545Entities())
{
if (db.users.Any(x => x.username == userLogin.username))
{
var user = db.users.FirstOrDefault(x => x.username == userLogin.username);
if (user.password == hashPwd(userLogin.password))
{
Session["userLogged"] = user;
updateLastLoginTimeAndIp();
ViewBag.SuccessMessage = "Successful Logged";
ViewBag.LoggedStatus = true;
}
else
{
ViewBag.DuplicateMessage = "Login failed!";
}
}
else
{
ViewBag.DuplicateMessage = "Login failed!";
}
}
if (Session["userLogged"] != null)
{
}
return(View());
}
public ActionResult detail(int id)
{
using (vlutrading3545Entities db = new vlutrading3545Entities())
{
var item = db.items.FirstOrDefault(x => x.id == id);
var imgList = db.item_images.Where(x => x.item_id == id)
.Select(x => new { x.filename, imgString = x.base64_string })
.ToList();
ViewBag.DetailItem = item;
ViewBag.imgList = imgList;
}
ViewBag.IdItem = id;
return(View());
}
private void updateLastLogoutTimeAndIp()
{
var user = Session["userLogged"] as TradingVLU.Models.user;
if (user != null)
{
string ip_logout = "default";
if (Request.UserHostAddress != null)
{
ip_logout = Request.UserHostAddress;
}
//db.Database.SqlQuery<ObjReturn>("updateLastLoginIpAddress", user_detail.id, ip_login);
var sql_sp = @"exec updateLastLogoutIpAddress {0}, {1}";
using (vlutrading3545Entities db = new vlutrading3545Entities())
{
db.Database.ExecuteSqlCommand(sql_sp,
user.id, ip_logout);
}
}
}
public ActionResult register()
{
if (Session["userLogged"] != null)
{
return(RedirectToAction("account_settings", "User"));
}
using (vlutrading3545Entities db = new vlutrading3545Entities())
{
var ques = db.security_question.ToList();
List <SelectListItem> item = new List <SelectListItem>();
foreach (var i in ques)
{
item.Add(new SelectListItem
{
Text = i.question,
Value = i.id.ToString()
});
}
ViewBag.question = item;
}
return(View());
}
public ActionResult index(String name, String description, int quantity, int status, HttpPostedFileBase uploadImages)
{
using (vlutrading3545Entities db = new vlutrading3545Entities())
{
byte[] img = null;
string img_as_string = "";
if (uploadImages != null)
{
img = new byte[uploadImages.ContentLength];
using (BinaryReader read = new BinaryReader(uploadImages.InputStream))
{
img = read.ReadBytes(uploadImages.ContentLength);
}
img_as_string = Convert.ToBase64String(img);
}
item item = new item
{
item_name = name,
description = description,
quantity = quantity,
status = status,
images = img_as_string,
seller_id = 1,
create_by = "vinh",
create_date = DateTime.Now,
update_by = "vinh",
update_date = DateTime.Now
};
try
{
db.items.Add(item);
db.SaveChanges();
}
catch (Exception e)
{
ViewBag.DuplicateMessage = "Error occurred while create new item. Contact Admin for details";
return(View());
throw;
}
//if (uploadImages != null)
//{
// string[] n = uploadImages.FileName.Split('.');
// string sfile = n[0] + "_" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + "." + n[1];
// string spath = Server.MapPath("~/Content/img/items/");
// string sfullpath = Path.Combine(spath, sfile);
// try
// {
// uploadImages.SaveAs(sfullpath);
// db.item_images.Add(new item_images
// {
// item_id = 1,
// filename = sfile,
// path = sfullpath,
// create_by = "vinh",
// create_date = DateTime.Now,
// update_by = "vinh",
// update_date = DateTime.Now
// });
// db.SaveChanges();
// }
// catch (Exception ex)
// {
// }
//}
}
return(View());
}
public ActionResult register(USERMetadata newUser)
{
using (vlutrading3545Entities db = new vlutrading3545Entities())
{
var ques = db.security_question.ToList();
List <SelectListItem> item = new List <SelectListItem>();
foreach (var i in ques)
{
item.Add(new SelectListItem
{
Text = i.question,
Value = i.id.ToString()
});
}
ViewBag.question = item;
if (ModelState.IsValid)
{
if (db.users.Any(x => x.email == newUser.email))
{
ModelState.AddModelError("Email", "Email already exist");
return(View(newUser));
}
else if (db.users.Any(x => x.username == newUser.username))
{
ModelState.AddModelError("Username", "Username already exist");
return(View(newUser));
}
else
{
string ip_login = "";
if (Request.UserHostAddress != null)
{
ip_login = Request.UserHostAddress;
}
user usr = new user
{
username = newUser.username,
password = hashPwd(newUser.password),
email = newUser.email,
name = newUser.name,
role = 1,
id_security_question = newUser.id_security_question,
answer_security_question = newUser.answer_security_question,
is_active = 1,
ip_last_login = ip_login,
last_login_date = DateTime.Now,
create_by = newUser.username,
create_date = DateTime.Now,
update_by = newUser.username,
update_date = DateTime.Now
};
try
{
db.users.Add(usr);
db.SaveChanges();
}
catch (Exception e)
{
ViewBag.DuplicateMessage = "Error occurred while register. Contact Admin for details";
return(View());
throw;
}
ViewBag.SuccessMessage = "Successful Register";
ModelState.Clear();
return(View());
}
}
else
{
return(View());
}
}
}
