public ActionResult Deliver(FormCollection f)
{
try
{
int _ORDER_ID = int.Parse(f.Get("txtOrderId"));
string _SHIP_CODE = f.Get("txtShipCode");
DateTime _SHIP_DATE = DateTime.Parse(f.Get("dtpShipDate"));
decimal _FREIGHT = decimal.Parse(f.Get("txtFreight"));
string _NOTE_EMPLOYEE = f.Get("txtNote");
USER _ADMIN = (USER)(Session["SS_USER_ADMIN"]);
var ORDER = db.ORDERS.Find(_ORDER_ID);
//Cập nhật điểm người dùng khi mua hàng
if (ORDER.USER_ID != 0)
{
USER_PROFILES _USER = db.USER_PROFILES.Single(n => n.USER_ID == ORDER.USER_ID);
_USER.POINTS += (int)(ORDER.SUBTOTAL / 1000000);
}
//Cập nhật số hàng bán ra
List <ORDER_DETAILS> _lstORDER_DETAILS = db.ORDER_DETAILS.Where(n => n.ORDER_ID == ORDER.ORDER_ID).ToList();
foreach (var _order_details in _lstORDER_DETAILS)
{
PRODUCT _PRODUCT = db.PRODUCTS.Find(_order_details.PRODUCT_ID);
_PRODUCT.QUANTITY_SOLD += _order_details.QUANTITY;
db.SaveChanges();
}
ORDER.ORDER_STATUS_ID = 1;
ORDER.EMPLOYEE_ID = _ADMIN.USER_ID;
ORDER.SHIP_CODE = _SHIP_CODE;
ORDER.SHIPPED_DATE = _SHIP_DATE;
ORDER.FREIGHT = _FREIGHT;
ORDER.NOTE_EMPLOYEE = _NOTE_EMPLOYEE;
TempData["Success"] = "Đơn hàng #VNT-" + ORDER.ORDER_ID + " đã được giao !";
db.SaveChanges();
return(RedirectToAction("ManagingOrders", "Admin", new { order_status_id = 1, Time = 1 }));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Update(int id, FormCollection collection, HttpPostedFileBase AVATAR)
{
try
{
m_USER = db.USERS.Find(id);
switch (collection.Get("r3").ToString())
{
case "user":
m_USER.IS_ADMIN = false;
m_USER.IS_EMPLOYEE = false;
break;
case "employee":
m_USER.IS_EMPLOYEE = true;
m_USER.IS_ADMIN = false;
break;
case "admin":
m_USER.IS_ADMIN = true;
m_USER.IS_EMPLOYEE = false;
break;
}
db.SaveChanges();
m_USER_PROFILES = db.USER_PROFILES.Where(n => n.USER_ID == id).Single();
m_USER_PROFILES.FULL_NAME = collection.Get("FULL_NAME").ToString();
m_USER_PROFILES.ADDRESS = collection.Get("ADDRESS").ToString();
m_USER_PROFILES.MOBILE = collection.Get("MOBILE").ToString();
if (AVATAR != null)
{
string _fileNameRandom = m_STRING_RANDOM_IMAGE.RandomString();
m_USER_PROFILES.AVATAR = "~/Images/AVATAR/" + _fileNameRandom + AVATAR.FileName;
string _path = Path.Combine(Server.MapPath("~/Images/AVATAR/" + _fileNameRandom + AVATAR.FileName));
AVATAR.SaveAs(_path);
}
db.SaveChanges();
TempData["SuccessCreate"] = "Cập nhật thông tin tài khoản thành công.";
return(RedirectToAction("Update", "ManagingUsers", new { id = id }));
}
catch
{
return(View());
}
}
public int Register(string UserName, string Email, string Password)
{
try
{
USER _USER = db.USERS.Where(n => n.USER_NAME == UserName).SingleOrDefault();
USER_PROFILES _USER_PROFILES = db.USER_PROFILES.Where(n => n.EMAIL == Email).SingleOrDefault();
if (_USER != null)
{
return(1);
}
else if (_USER_PROFILES != null)
{
return(2);
}
_USER = new USER();
_USER_PROFILES = new USER_PROFILES();
_USER.USER_NAME = UserName;
_USER.PASSWORD = StringCipher.Encrypt(Password, UserName);
_USER.IS_ACTIVE = true;
_USER.IS_ADMIN = _USER.IS_EMPLOYEE = false;
_USER.CREATED_DATE = DateTime.Now;
db.USERS.Add(_USER);
db.SaveChanges();
_USER_PROFILES.FULL_NAME = UserName;
_USER_PROFILES.EMAIL = Email;
_USER_PROFILES.USER_ID = _USER.USER_ID;
_USER_PROFILES.POINTS = 0;
_USER_PROFILES.ADDRESS = "";
_USER_PROFILES.MOBILE = "";
_USER_PROFILES.AVATAR = "~/Content/Page_Layout/img/default-avatar.jpg";
db.USER_PROFILES.Add(_USER_PROFILES);
db.SaveChanges();
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
