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 ChangeStatus(int id = 0)
{
string str_status = "ON";
using (ZONYEntities db = new ZONYEntities())
{
var model = db.Orders.Where(m => m.rowid == id).FirstOrDefault();
if (model != null)
{
str_status = model.order_status;
}
var selectList = new List <SelectListItem>();
List <Status> lists = ShopContent.GetStatusList();
foreach (var item in lists)
{
SelectListItem list = new SelectListItem();
list.Value = item.mno;
list.Text = item.mname;
selectList.Add(list);
}
//預設選擇哪一筆
selectList.Where(m => m.Value == str_status).First().Selected = true;
ViewBag.SelectList = selectList;
return(View(model));
}
}
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 Index(int id = 0, int code = -1)
{
UserAccount.UserStatus = id;
if (code == -1)
{
if (UserAccount.UserCode == -1)
{
UserAccount.UserCode = 0;
}
}
else
{
UserAccount.UserCode = code;
}
if (id > 0)
{
using (ZONYEntities db = new ZONYEntities())
{
string str_order_no = "";
var orders = db.Orders.Where(m => m.rowid == id).FirstOrDefault();
if (orders != null)
{
str_order_no = orders.order_no;
}
var details = db.OrdersDetail.Where(m => m.order_no == str_order_no).ToList();
ViewBag.OrderNo = str_order_no;
ViewBag.OrderDetail = details;
}
}
return(View());
}
public ActionResult GetDataList()
{
using (ZONYEntities db = new ZONYEntities())
{
var models = db.Orders
.Join(db.Payments, p => p.payment_no, d => d.mno,
(p1, d1) => new { p1, payment_name = d1.mname })
.Join(db.Status, p => p.p1.order_status, d => d.mno,
(p2, d2) => new { p2, status_name = d2.mname })
.Join(db.Shippings, p => p.p2.p1.shipping_no, d => d.mno,
(p3, d3) => new
{
rowid = p3.p2.p1.rowid,
order_closed = p3.p2.p1.order_closed,
user_no = p3.p2.p1.user_no,
order_no = p3.p2.p1.order_no,
order_date = p3.p2.p1.order_date,
status_no = p3.p2.p1.order_status,
status_name = p3.status_name,
payment_name = p3.p2.payment_name,
shipping_name = d3.mname,
receive_name = p3.p2.p1.receive_name,
receive_address = p3.p2.p1.receive_address,
remark = p3.p2.p1.remark
})
.Where(m => m.user_no == UserAccount.UserNo)
.Where(m => m.order_closed == UserAccount.UserCode)
.OrderByDescending(m => m.order_no).ToList();
return(Json(new { data = models }, JsonRequestBehavior.AllowGet));
}
}
public static List <Status> GetStatusList()
{
using (ZONYEntities db = new ZONYEntities())
{
return(db.Status.OrderBy(m => m.mno).ToList());
}
}
private static int GetCartTotals()
{
int?int_totals = 0;
using (ZONYEntities db = new ZONYEntities())
{
if (UserAccount.IsLogin)
{
var data1 = db.Carts
.Where(m => m.user_no == UserAccount.UserNo)
.ToList();
if (data1 != null)
{
int_totals = data1.Sum(m => m.amount);
}
}
else
{
var data2 = db.Carts
.Where(m => m.lot_no == LotNo)
.ToList();
if (data2 != null)
{
int_totals = data2.Sum(m => m.amount);
}
}
}
if (int_totals == null)
{
int_totals = 0;
}
return(int_totals.GetValueOrDefault());
}
/// <summary>
/// 取得目前購物車筆數
/// </summary>
/// <returns></returns>
private static int GetCartCount()
{
int int_count = 0;
using (ZONYEntities db = new ZONYEntities())
{
if (UserAccount.IsLogin)
{
var data1 = db.Carts
.Where(m => m.user_no == UserAccount.UserNo)
.ToList();
if (data1 != null)
{
int_count = data1.Count;
}
}
else
{
var data2 = db.Carts
.Where(m => m.lot_no == LotNo)
.ToList();
if (data2 != null)
{
int_count = data2.Count;
}
}
}
return(int_count);
}
public static List <Users> GetVendorsList()
{
using (ZONYEntities db = new ZONYEntities())
{
return(db.Users.Where(m => m.role_no == "Vendor").OrderBy(m => m.mno).ToList());
}
}
public ActionResult GetDataList()
{
using (ZONYEntities db = new ZONYEntities())
{
var models = db.Companys.OrderBy(m => m.mno).ToList();
return(Json(new { data = models }, JsonRequestBehavior.AllowGet));
}
}
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 }
});
}
public ActionResult EditProfile()
{
using (ZONYEntities db = new ZONYEntities())
{
var model = db.Users
.Where(m => m.mno == UserAccount.UserNo)
.FirstOrDefault();
return(View(model));
}
}
public static List <Categorys> GetCategorys(int id)
{
ZONYEntities db = new ZONYEntities();
var lists = db.Categorys
.Where(m => m.parentid == id)
.OrderBy(m => m.category_no)
.ToList();
return(lists);
}
public static List <Products> GetTopProducts()
{
ZONYEntities db = new ZONYEntities();
var lists = db.Products
.Where(m => m.istop == 1)
.OrderBy(m => m.product_no)
.ToList();
return(lists);
}
public ActionResult GetDataList()
{
using (ZONYEntities db = new ZONYEntities())
{
int int_pid = int.Parse(Session["CategoryID"].ToString());
var models = db.Categorys
.Where(m => m.parentid == int_pid)
.OrderBy(m => m.category_no).ToList();
return(Json(new { data = models }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult ReturnToParent()
{
using (ZONYEntities db = new ZONYEntities())
{
int int_pid = int.Parse(Session["CategoryID"].ToString());
var model = db.Categorys.Where(m => m.rowid == int_pid).FirstOrDefault();
if (model != null)
{
int_pid = model.parentid.GetValueOrDefault();
}
return(RedirectToAction("Index", "Category", new { id = int_pid }));
}
}
public ActionResult Edit(int id = 0)
{
using (ZONYEntities db = new ZONYEntities())
{
if (id == 0)
{
Companys new_model = new Companys();
return(View(new_model));
}
var models = db.Companys.Where(m => m.rowid == id).FirstOrDefault();
return(View(models));
}
}
/// <summary>
/// 取得日期範圍中的銷售金額
/// </summary>
/// <param name="startDate">開始日期</param>
/// <param name="endDate">結束日期</param>
/// <returns></returns>
private int GetSaleAmount(DateTime startDate, DateTime endDate)
{
using (ZONYEntities db = new ZONYEntities())
{
int int_amount = 0;
startDate = startDate.ezMinDateTime();
endDate = endDate.ezMaxDateTime();
if (UserAccount.RoleNo == AppEnums.enUserRole.Admin)
{
object obj_value = db.OrdersDetail
.Join(db.Orders, p => p.order_no, d => d.order_no,
(p1, d1) => new { p1, d1 })
.Where(m => m.d1.order_date >= startDate)
.Where(m => m.d1.order_date <= endDate)
.Sum(m => m.p1.amount);
if (obj_value != null)
{
int.TryParse(obj_value.ToString(), out int_amount);
}
}
if (UserAccount.RoleNo == AppEnums.enUserRole.Member)
{
object obj_value = db.OrdersDetail
.Join(db.Orders, p => p.order_no, d => d.order_no,
(p1, d1) => new { p1, d1 })
.Where(m => m.d1.order_date >= startDate)
.Where(m => m.d1.order_date <= endDate)
.Where(m => m.d1.user_no == UserAccount.UserNo)
.Sum(m => m.p1.amount);
if (obj_value != null)
{
int.TryParse(obj_value.ToString(), out int_amount);
}
}
if (UserAccount.RoleNo == AppEnums.enUserRole.Vendor)
{
object obj_value = db.OrdersDetail
.Join(db.Orders, p => p.order_no, d => d.order_no,
(p1, d1) => new { p1, d1 })
.Where(m => m.d1.order_date >= startDate)
.Where(m => m.d1.order_date <= endDate)
.Where(m => m.p1.vendor_no == UserAccount.UserNo)
.Sum(m => m.p1.amount);
if (obj_value != null)
{
int.TryParse(obj_value.ToString(), out int_amount);
}
}
return(int_amount);
}
}
/// <summary>
/// 取得商品名稱
/// </summary>
/// <param name="productNo">商品代號</param>
/// <returns></returns>
public static string GetProductName(string productNo)
{
string str_name = "";
using (ZONYEntities db = new ZONYEntities())
{
var models = db.Products.Where(m => m.product_no == productNo).FirstOrDefault();
if (models != null)
{
str_name = models.product_name;
}
}
return(str_name);
}
public static string GetUserName(string userNo)
{
string str_name = "";
using (ZONYEntities db = new ZONYEntities())
{
var models = db.Users.Where(m => m.mno == userNo).FirstOrDefault();
if (models != null)
{
str_name = models.mname;
}
}
return(str_name);
}
public static string GetVendorNoByProduct(string productNo)
{
string str_no = "";
using (ZONYEntities db = new ZONYEntities())
{
var prod = db.Products.Where(m => m.product_no == productNo).FirstOrDefault();
if (prod != null)
{
str_no = prod.vendor_no;
}
}
return(str_no);
}
/// <summary>
/// 加入購物車
/// </summary>
/// <param name="productNo">商品編號</param>
/// <param name="color_no">商品顏色</param>
/// <param name="size_no">商品尺寸</param>
/// <param name="buyQty">數量</param>
public static void AddCart(string productNo /*, string color_no, string size_no*/, int buyQty)
{
using (ZONYEntities db = new ZONYEntities())
{
string str_spec = "";
//if (!string.IsNullOrEmpty(color_no)) str_spec += string.Format("顏色:{0}", color_no);
//if (!string.IsNullOrEmpty(size_no))
//{
// if (!string.IsNullOrEmpty(str_spec)) str_spec += " ";
// str_spec += string.Format("尺寸:{0}", size_no);
//}
AddCart(productNo, str_spec, buyQty);
}
}
public ActionResult Delete(int id)
{
using (ZONYEntities db = new ZONYEntities())
{
var model = db.Products.Where(m => m.rowid == id).FirstOrDefault();
if (model != null)
{
return(View(model));
}
else
{
return(HttpNotFound());
}
}
}
/// <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 Remark(int id = 0)
{
using (ZONYEntities db = new ZONYEntities())
{
var model = db.Products.Where(m => m.rowid == id).FirstOrDefault();
if (model != null)
{
ShopContent.ProductNo = model.product_no;
return(View(model));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult Reset(int id)
{
using (ZONYEntities db = new ZONYEntities())
{
var model = db.Users.Where(m => m.rowid == id).FirstOrDefault();
if (model != null)
{
model.bool_isvarify = ShopContent.IntegerToBool(model.isvarify);
return(View(model));
}
else
{
return(HttpNotFound());
}
}
}
/// <summary>
/// 取得分類名稱
/// </summary>
/// <param name="cat_no">分類代號</param>
/// <param name="cat_id">分類 ID</param>
/// <returns></returns>
public static string GetCategoryName(string cat_no, ref int cat_id)
{
cat_id = 0;
string str_name = "";
using (ZONYEntities db = new ZONYEntities())
{
var model = db.Categorys.Where(m => m.category_no == cat_no).FirstOrDefault();
if (model != null)
{
str_name = model.category_name;
cat_id = model.rowid;
}
return(str_name);
}
}
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 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 }));
}
/// <summary>
/// 取得商品單價
/// </summary>
/// <param name="productNo">商品代號</param>
/// <returns></returns>
public static int GetProductPrice(string productNo)
{
int int_price = 0;
using (ZONYEntities db = new ZONYEntities())
{
var models = db.Products.Where(m => m.product_no == productNo).FirstOrDefault();
if (models != null)
{
if (models.price != null)
{
int.TryParse(models.price.ToString(), out int_price);
}
}
}
return(int_price);
}
