public ActionResult CartDelete(int id)
{
var data = db.Carts
.Where(m => m.rowid == id)
.FirstOrDefault();
if (data != null)
{
db.Carts.Remove(data);
db.SaveChanges();
}
return(RedirectToAction("CartList"));
}
/// <summary>
/// 消費者付款
/// </summary>
public static void CartPayment(cvmOrders model)
{
OrderNo = CreateNewOrderNo(model);
using (ZONYEntities db = new ZONYEntities())
{
var datas = db.Carts
.Where(m => m.user_no == UserAccount.UserNo)
.ToList();
if (datas != null)
{
int int_amount = datas.Sum(m => m.amount).GetValueOrDefault();
decimal dec_tax = 0;
if (int_amount > 0)
{
dec_tax = Math.Round((decimal)(int_amount * 5 / 100), 0);
}
int int_total = int_amount + (int)dec_tax;
var data = db.Orders.Where(m => m.order_no == OrderNo).FirstOrDefault();
if (data != null)
{
data.amounts = int_amount;
data.taxs = (int)dec_tax;
data.totals = int_total;
db.SaveChanges();
}
foreach (var item in datas)
{
OrdersDetail detail = new OrdersDetail();
detail.order_no = OrderNo;
detail.product_no = item.product_no;
detail.product_name = item.product_name;
detail.vendor_no = ShopContent.GetVendorNoByProduct(item.product_no);
detail.category_name = ShopContent.GetCategoryName(item.product_no);
detail.product_spec = item.product_spec;
detail.qty = item.qty;
detail.price = item.price;
detail.amount = item.amount;
detail.remark = "";
db.OrdersDetail.Add(detail);
db.SaveChanges();
db.Carts.Remove(item);
db.SaveChanges();
}
}
}
}
public ActionResult Register(cvmRegister model)
{
if (!ModelState.IsValid) return View(model);
//自定義檢查
bool bln_error = false;
var check = db.Users.Where(m => m.mno == model.mno).FirstOrDefault();
if (check != null) { ModelState.AddModelError("mno", "帳號重覆註冊!!"); bln_error = true; }
check = db.Users.Where(m => m.email == model.email).FirstOrDefault();
if (check != null) { ModelState.AddModelError("email", "電子信箱重覆註冊!!"); bln_error = true; }
if (bln_error) return View(model);
//密碼加密
using (Cryptographys cryp = new Cryptographys())
{
model.password = cryp.SHA256Encode(model.password);
model.ConfirmPassword = model.password;
}
Users user = new Users();
user.mno = model.mno;
user.mname = model.mname;
user.password = model.password;
user.email = model.email;
user.birthday = model.birthday;
user.remark = model.remark;
user.role_no = "Member";
user.varify_code = UserAccount.GetNewVarifyCode(); //產生驗證碼
user.isvarify = 0;
//寫入資料庫
try
{
db.Configuration.ValidateOnSaveEnabled = false;
db.Users.Add(user);
db.SaveChanges();
db.Configuration.ValidateOnSaveEnabled = true;
}
catch (Exception ex)
{
string str_message = ex.Message;
}
//寄出驗證信
SendVerifyMail(model.email, user.varify_code);
return RedirectToAction("SendEmailResult");
}
public ActionResult Edit(Companys models)
{
bool status = false;
if (ModelState.IsValid)
{
using (ZONYEntities db = new ZONYEntities())
{
if (models.rowid > 0)
{
//Edit
var Companys = db.Companys.Where(m => m.rowid == models.rowid).FirstOrDefault();
if (Companys != null)
{
Companys.mno = models.mno;
Companys.mname = models.mname;
Companys.remark = models.remark;
}
}
else
{
//Save
db.Companys.Add(models);
}
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult EditProfile(Users model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (ZONYEntities db = new ZONYEntities())
{
var user = db.Users
.Where(m => m.rowid == model.rowid)
.FirstOrDefault();
if (user != null)
{
user.mname = model.mname;
user.email = model.email;
user.birthday = model.birthday;
user.remark = model.remark;
db.SaveChanges();
}
return(RedirectToAction("VendorProfile"));
}
}
public ActionResult Edit(Users models)
{
bool status = false;
ModelState.Remove("Password"); //忽略 Password 驗證
ModelState.Remove("role_no"); //忽略 role_no 驗證
if (ModelState.IsValid)
{
using (ZONYEntities db = new ZONYEntities())
{
if (models.rowid > 0)
{
//Edit
var users = db.Users.Where(m => m.rowid == models.rowid).FirstOrDefault();
if (users != null)
{
users.isvarify = ShopContent.BoolToInteger(models.bool_isvarify);
users.mno = models.mno;
users.mname = models.mname;
users.email = models.email;
users.birthday = models.birthday;
users.remark = models.remark;
}
}
else
{
//Save
models.role_no = UserAccount.UserRoleNo;
models.varify_code = UserAccount.GetNewVarifyCode(); //產生驗證碼
if (UserAccount.UserStatus < 2)
{
models.isvarify = UserAccount.UserStatus;
}
else
{
models.isvarify = ShopContent.BoolToInteger(models.bool_isvarify);
}
db.Users.Add(models);
}
try
{
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
db.Configuration.ValidateOnSaveEnabled = true;
status = true;
}
catch (Exception ex)
{
string str_message = ex.Message;
status = false;
}
}
}
return(new JsonResult {
Data = new { status = status }
});
}
private static string CreateNewOrderNo(cvmOrders model)
{
ShopContent.OrderID = 0;
ShopContent.OrderNo = "0";
string str_order_no = "";
string str_guid = Guid.NewGuid().ToString().Substring(0, 25).ToUpper();
using (ZONYEntities db = new ZONYEntities())
{
Orders orders = new Orders();
orders.order_closed = 0;
orders.order_validate = 0;
orders.order_no = "";
orders.order_date = DateTime.Now;
orders.user_no = UserAccount.UserNo;
orders.order_status = "ON";
orders.order_guid = str_guid;
orders.payment_no = model.payment_no;
orders.shipping_no = model.shipping_no;
orders.receive_name = model.receive_name;
orders.receive_email = model.receive_email;
orders.receive_address = model.receive_address;
orders.remark = "";
db.Orders.Add(orders);
db.SaveChanges();
var neword = db.Orders.Where(m => m.order_guid == str_guid).FirstOrDefault();
if (neword != null)
{
str_order_no = neword.rowid.ToString().PadLeft(8, '0');
neword.order_no = str_order_no;
ShopContent.OrderID = neword.rowid;
ShopContent.OrderNo = str_order_no;
db.SaveChanges();
}
}
return(str_order_no);
}
/// <summary>
/// 加入購物車
/// </summary>
/// <param name="productNo">商品編號</param>
/// <param name="prod_Spec">商品規格</param>
/// <param name="buyQty">數量</param>
public static void AddCart(string productNo, string prod_Spec, int buyQty)
{
using (ZONYEntities db = new ZONYEntities())
{
int int_price = ShopContent.GetProductPrice(productNo);
int int_amount = (buyQty * int_price);
var datas = db.Carts
.Where(m => m.lot_no == LotNo)
.Where(m => m.user_no == UserAccount.UserNo)
.Where(m => m.product_no == productNo)
.Where(m => m.product_spec == prod_Spec)
.FirstOrDefault();
if (datas == null)
{
Carts models = new Carts();
models.lot_no = LotNo;
models.user_no = UserAccount.UserNo;
models.crete_time = LotCreateTime;
models.product_no = productNo;
models.product_name = ShopContent.GetProductName(productNo);
models.product_spec = prod_Spec;
models.qty = buyQty;
models.amount = int_amount;
models.price = int_price;
db.Carts.Add(models);
db.SaveChanges();
}
else
{
datas.qty += buyQty;
datas.amount = buyQty * int_price;
db.SaveChanges();
}
}
}
public ActionResult ReturnProduct(int id = 0)
{
using (ZONYEntities db = new ZONYEntities())
{
var model = db.Orders.Where(m => m.rowid == id).FirstOrDefault();
if (model != null)
{
if (ShopContent.IsUnCloseOrder(model.order_status))
{
model.order_status = "RT";
model.order_closed = 1;
db.SaveChanges();
}
}
}
return(RedirectToAction("Index", "Orders", new { area = "Member", id = UserAccount.UserStatus, code = UserAccount.UserCode }));
}
public ActionResult UnConfirm(int id = 0)
{
using (ZONYEntities db = new ZONYEntities())
{
var model = db.Users.Where(m => m.rowid == id).FirstOrDefault();
if (model != null)
{
model.isvarify = 0;
db.SaveChanges();
return(RedirectToAction("Index", "Vendor", new { area = "Admin", id = UserAccount.UserStatus }));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult Remark(Products products)
{
bool status = false;
using (ZONYEntities db = new ZONYEntities())
{
var model = db.Products.Where(m => m.rowid == products.rowid).FirstOrDefault();
if (model != null)
{
model.detail_remark = products.detail_remark;
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult DeleteData(int id)
{
bool status = false;
using (ZONYEntities db = new ZONYEntities())
{
var model = db.Products.Where(m => m.rowid == id).FirstOrDefault();
if (model != null)
{
db.Products.Remove(model);
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult ChangeStatus(Orders model)
{
using (ZONYEntities db = new ZONYEntities())
{
bool status = false;
var orders = db.Orders.Where(m => m.order_no == model.order_no).FirstOrDefault();
if (orders != null)
{
orders.order_status = model.order_status;
orders.order_closed = ShopContent.GetOrderClosed(model.order_status);
orders.order_validate = ShopContent.GetOrderValidate(model.order_status);
db.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
}
public ActionResult ResetPassword(int id)
{
bool status = false;
using (ZONYEntities db = new ZONYEntities())
{
var model = db.Users.Where(m => m.rowid == id).FirstOrDefault();
if (model != null)
{
using (Cryptographys crpy = new Cryptographys())
{
model.password = crpy.SHA256Encode(model.mno);
db.SaveChanges();
}
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult Edit(Categorys models)
{
bool status = false;
if (ModelState.IsValid)
{
using (ZONYEntities db = new ZONYEntities())
{
if (models.rowid > 0)
{
//Edit
var Categorys = db.Categorys.Where(m => m.rowid == models.rowid).FirstOrDefault();
if (Categorys != null)
{
Categorys.category_no = models.category_no;
Categorys.category_name = models.category_name;
}
}
else
{
//Save
if (Session["CategoryID"] == null)
{
models.parentid = 0;
}
else
{
models.parentid = int.Parse(Session["CategoryID"].ToString());
}
db.Categorys.Add(models);
}
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
/// <summary>
/// 登入時將現有遊客的購物車加入客戶的購物車
/// </summary>
public static void LoginCart()
{
if (!string.IsNullOrEmpty(LotNo))
{
int int_qty = 0;
using (ZONYEntities db = new ZONYEntities())
{
var datas = db.Carts
.Where(m => m.lot_no == LotNo)
.ToList();
if (datas != null)
{
foreach (var item in datas)
{
int_qty = item.qty.GetValueOrDefault();
AddCart(item.product_no, item.product_spec, int_qty);
db.Carts.Remove(item);
}
db.SaveChanges();
}
}
NewLotNo();
}
}
public ActionResult Edit(Products models)
{
bool status = false;
if (ModelState.IsValid)
{
using (ZONYEntities db = new ZONYEntities())
{
int int_cate_id = 0;
if (models.rowid > 0)
{
//Edit
var products = db.Products.Where(m => m.rowid == models.rowid).FirstOrDefault();
if (products != null)
{
int_cate_id = models.categoryid.GetValueOrDefault();
products.product_no = models.product_no;
products.product_name = models.product_name;
products.product_spec = models.product_spec;
products.categoryid = int_cate_id;
products.category_name = ShopContent.GetCategoryName(int_cate_id);
products.istop = (models.bool_istop) ? 1 : 0;
products.issale = (models.bool_issale) ? 1 : 0;
products.issize = (models.bool_issize) ? 1 : 0;
products.iscolor = (models.bool_iscolor) ? 1 : 0;
products.isgame = (models.bool_isgame) ? 1 : 0;
products.ismultiplayer = (models.bool_ismultiplayer) ? 1 : 0;
products.price = models.price;
products.start_count = models.start_count;
products.browse_count = models.browse_count;
products.vendor_no = UserAccount.UserNo;
products.color_name = models.color_name;
products.size_name = models.size_name;
products.remark = models.remark;
products.detail_remark = models.detail_remark;
products.publisher = models.publisher;
products.language_view = models.language_view;
products.language_voice = models.language_voice;
products.player_num = models.player_num;
}
}
else
{
//Save
models.vendor_no = UserAccount.UserNo;
int_cate_id = models.categoryid.GetValueOrDefault();
models.category_name = ShopContent.GetCategoryName(int_cate_id);
models.istop = (models.bool_istop) ? 1 : 0;
models.issale = (models.bool_issale) ? 1 : 0;
models.issize = (models.bool_issize) ? 1 : 0;
models.iscolor = (models.bool_iscolor) ? 1 : 0;
models.isgame = (models.bool_isgame) ? 1 : 0;
models.ismultiplayer = (models.bool_ismultiplayer) ? 1 : 0;
db.Products.Add(models);
}
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
