public ActionResult Edit([Bind(Include = "Id,Name,Address,WorkingHours")] Shop shop)
{
if (ModelState.IsValid)
{
db.Entry(shop).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(shop));
}
private void btnDel_Click(object sender, EventArgs e)
{
if (dgv.SelectedRows.Count == 0)
{
MetroMessageBox.Show(this, "Please select category first.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string name = dgv.SelectedRows[0].Cells[1].Value.ToString();
try
{
for (int i = 0; i < dgv.SelectedRows.Count; i++)
{
int id = Convert.ToInt32(dgv.SelectedRows[i].Cells[0].Value);
//CategoryClass.Delete(id);
using (ShopDBEntities db = new ShopDBEntities())
{
var ent = db.Categories.FirstOrDefault(c => c.CatID == id);
db.Categories.Remove(ent);
db.Entry(ent).State = EntityState.Deleted;
db.SaveChanges();
}
}
Notifications.Notfication("Categories Removed", "Operation Successful", Color.Green);
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "Category not deleted from the system.\nDetails: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
InitiateControls();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tbName.Text.Trim()))
{
MetroMessageBox.Show(this, "Please Enter Category Name to continue..", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
// CategoryClass.Create(tbName.Text.Trim(), tbDesc.Text.Trim(), dtp.Value);
using (ShopDBEntities db = new ShopDBEntities())
{
db.Configuration.AutoDetectChangesEnabled = false;
ElectricStoreMetro.Category cat = new ElectricStoreMetro.Category();
cat.Name = tbName.Text.Trim();
cat.Description = tbDesc.Text.Trim();
cat.Date = dtp.Value;
db.Entry(cat).State = EntityState.Added;
db.SaveChanges();
}
Notifications.Notfication("New Category Created", "Category " + tbName.Text + " created successfully.", Color.Green);
InitiateControls();
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "Category not saved. see below details for more information\nDetails: " + ex.Message, "Saving error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public ActionResult ChangeData(MemberDataViewModel memberData)
{
//取得會員資料
var memberAccount = db.member.Where(x => x.Account == memberData.Account).FirstOrDefault();
//判斷密碼是否正確
if (memberAccount.PassWord != memberData.PassWord)
{
ModelState.AddModelError("PassWord", "密碼不正確");
}
if (ModelState.IsValid)
{
//更改會員資料
memberAccount.Adress = memberData.Adress;
memberAccount.Email = memberData.Email;
memberAccount.Name = memberData.Name;
memberAccount.Telphone = memberData.Telphone;
memberAccount.PassWord = memberData.PassWord2;
db.Entry(memberAccount).State = EntityState.Modified;
db.SaveChanges();
TempData["Change"] = "更改成功";
memberData.PassWord = "";
memberData.PassWord2 = "";
return(View(memberData));
}
return(View(memberData));
}
public ActionResult Edit(int id, Product productToEdit)
{
try
{
// TODO: Add update logic here
var originalProduct = (from p in _db.Products
where p.Id == productToEdit.Id
select p).First();
string fileName = Path.GetFileNameWithoutExtension(productToEdit.ImageFile.FileName);
string extension = Path.GetExtension(productToEdit.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssff") + extension;
productToEdit.FileName = "~/Image/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
productToEdit.ImageFile.SaveAs(fileName);
_db.Entry(originalProduct).CurrentValues.SetValues(productToEdit);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(productToEdit));
}
}
private void brnProcess_Click(object sender, EventArgs e)
{
try
{
int CompleteOStatusID = Convert.ToInt32(Properties.Settings.Default["CompleteOStatusID"]);
int PendingOStatusID = Convert.ToInt32(Properties.Settings.Default["PendingOStatusID"]);
using (ShopDBEntities db = new ShopDBEntities())
{
string prderNo = txtOrderNo.Text;
var toUpdate = db.Orders.SingleOrDefault(c => c.OrderNo == prderNo);
toUpdate.TotalPayment = Convert.ToDecimal(txtTotalPayment.Text);
toUpdate.PaymentDue = Convert.ToDecimal(txtPaymentDue.Text);
if (Convert.ToDecimal(txtPaymentDue.Text) == 0)
{
toUpdate.OrderStatusID = CompleteOStatusID;
}
else
{
toUpdate.OrderStatusID = PendingOStatusID;
}
db.Entry(toUpdate).State = EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Updated successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("Error.\nDetails: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
txtOrderNo.Focus();
}
}
private void metroButton3_Click(object sender, EventArgs e)
{
if (id == 0)
{
MetroMessageBox.Show(this, "Validation Error. Please check for emty fields.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
using (ShopDBEntities db = new ShopDBEntities())
{
var user = db.Users.SingleOrDefault(c => c.UserID == id);
db.Users.Remove(user);
db.Entry(user).State = EntityState.Deleted;
db.SaveChanges();
}
id = 0;
Notifications.Notfication("Account Deleted", "Account " + tbCreateName.Text + " deleted from the system.", Color.Red);
initiate();
}
catch (System.Data.Entity.Infrastructure.DbUpdateException)
{
MetroMessageBox.Show(this, "Please remove data from child tables first. ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
private void btnProcessUpdate_Click(object sender, EventArgs e)
{
try
{
//UPDADE ORDER TABLE
using (ShopDBEntities db = new ShopDBEntities())
{
string orderNo = txtUpdateOrderNo.Text;
var updateOrder = db.Orders.SingleOrDefault(c => c.OrderNo == orderNo);
updateOrder.TotalPayment = Convert.ToDecimal(txtTotalPayment.Text);
if (txtPaymentDue.Text.Trim() == "0.00" || Convert.ToDecimal(txtPaymentDue.Text) == 0)
{
updateOrder.OrderStatusID = 1;
}
else
{
updateOrder.OrderStatusID = 2;
}
db.Entry(updateOrder).State = EntityState.Modified;
db.SaveChanges();
DialogResult result = MessageBox.Show("Print Slip?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
InvoiceType = "Update Order";
PrintPreviewDialog.Document = PrintDocument;
PrintPreviewDialog.Show();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//if (validateInput(numStock.Value, numAddStock.Value))
//{
try
{
using (ShopDBEntities db = new ShopDBEntities())
{
int id = Convert.ToInt32(txtID.Text);
var item = db.Items.SingleOrDefault(c => c.ItemID == id);
item.Qty = item.Qty + Convert.ToInt32(numAddStock.Value);
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
Notifications.Notfication("Item Updated Successfully!", txtName.Text + " quantity updated successfully", Color.Green);
initiate();
}
}
catch (Exception ex)
{
MessageBox.Show("Error\n:" + ex.Message);
}
//}
//else
//{
// MessageBox.Show("Error");
//}
}
private void metroButton3_Click(object sender, EventArgs e)
{
try
{
using (ShopDBEntities _context = new ShopDBEntities())
{
var item = _context.Items.SingleOrDefault(c => c.ItemID == updateID);
_context.Items.Remove(item);
_context.Entry(item).State = EntityState.Deleted;
try
{
_context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
Notifications.Notfication("Deleted successfully!", tbName.Text + " deleted successfully.", Color.Green);
initiate();
}
}
catch (NullReferenceException)
{
MessageBox.Show("Please select Item to update and try again.", "No Selection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
private void metroButton2_Click(object sender, EventArgs e)
{
try
{
using (ShopDBEntities _context = new ShopDBEntities())
{
var item = _context.Items.SingleOrDefault(c => c.ItemID == updateID);
item.Name = tbName.Text;
item.Description = tbDesc.Text;
item.CatID = Convert.ToInt32(cbCat.SelectedValue);
item.PurchasePrice = Convert.ToDecimal(txtPPrice.Text);
item.Saleprice = Convert.ToDecimal(txtSPrice.Text);
item.DiscountPercent = Convert.ToInt32(numDPercent.Value);
item.Qty = Convert.ToInt32(numQty.Value);
item.UserID = 5;
item.DateUpdated = DateTime.Now;
_context.Entry(item).State = EntityState.Modified;
_context.SaveChanges();
Notifications.Notfication("Item Updated successfully!", tbName.Text + " updated successfully", Color.Green);
initiate();
//MessageBox.Show("updated");
}
}
catch (NullReferenceException ex)
{
MessageBox.Show("Please select Item to update and try again.", "No Selection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
private void btnProcessReturn_Click(object sender, EventArgs e)
{
/*ACTIONS
* 1. DELETE RESPECTIVE DATA FROM ORDER ITEMS AND ORDER TABLE
* 2. INSERT STOCK BACK IN ITEMS TABLE
* 3. SAVE DATA IN ORDERS TABLE
* 4. SAVE DATA IN ORDER ITEMS TABLE
* 5. REMOVE STOCK FROM ITEMS TABLE
*/
try
{
using (TransactionScope trans = new TransactionScope())
{
string orderno = txtUpdateOrderNo.Text;
#region DELETE FROM ORDERS
using (ShopDBEntities db = new ShopDBEntities())
{
var orderToRemove = db.Orders.SingleOrDefault(c => c.OrderNo == orderno);
db.Orders.Remove(orderToRemove);
db.Entry(orderToRemove).State = EntityState.Deleted;
db.SaveChanges();
}
#endregion
#region DELETE FROM ORDER ITEMS
using (ShopDBEntities db = new ShopDBEntities())
{
var itemToRemove = db.OrderItems.FirstOrDefault(c => c.OrderNo == orderno);
db.OrderItems.Remove(itemToRemove);
db.Entry(itemToRemove).State = EntityState.Deleted;
db.SaveChanges();
}
#endregion
#region UPDATE QUANTITY
foreach (DataGridViewRow row in dgvCart.Rows)
{
using (var context = new ShopDBEntities())
{
int itemid = Convert.ToInt32(row.Cells["ProductID"].Value);
var item = context.Items.SingleOrDefault(c => c.ItemID == itemid);
item.UsedQty = item.UsedQty - Convert.ToInt32(row.Cells["Quantity"].Value);
context.Entry(item).State = EntityState.Modified;
context.SaveChanges();
}
}
#endregion
trans.Complete();
}
}
catch (Exception ex)
{
throw;
MessageBox.Show(ex.Message);
return;
}
}
public ActionResult Edit2(string OrderID, string Select)
{
var selectOrder = db.Orders.Where(x => x.OrderID == OrderID).FirstOrDefault();
selectOrder.Orderstat = Convert.ToInt32(Select);
db.Entry(selectOrder).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,key,Date,LastEdit,State")] Quest quest)
{
if (ModelState.IsValid)
{
db.Entry(quest).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(quest));
}
public ActionResult Edit([Bind(Include = "Id,barcode,info,price")] Item item)
{
if (ModelState.IsValid)
{
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(item));
}
public ActionResult Edit([Bind(Include = "OrderNumber,ProdectID,ProdectName,ProdectNameAR,Descriotion,DescriotionAR,Price,Rating,ImagePath,CategorieID,UserID,FullName,UserName,Email,Phone,Password,City,State,Country,Address")] oldOrder oldOrder)
{
if (ModelState.IsValid)
{
db.Entry(oldOrder).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(oldOrder));
}
public ActionResult Edit([Bind(Include = "Id,Login,Info,Password")] User user)
{
if (ModelState.IsValid)
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Edit([Bind(Include = "CategorieID,CategorieName,CategorieNameAR,ImagePath")] CategoriesT categoriesT)
{
if (ModelState.IsValid)
{
db.Entry(categoriesT).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(categoriesT));
}
public ActionResult Edit([Bind(Include = "UserID,FullName,UserName,Email,Phone,Password,City,State,Country,Address")] UserT userT)
{
if (ModelState.IsValid)
{
db.Entry(userT).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userT));
}
public ActionResult Edit([Bind(Include = "Id,Role1")] Role role)
{
if (ModelState.IsValid)
{
db.Entry(role).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(role));
}
public ActionResult Edit([Bind(Include = "Id,Name")] Provider provider)
{
if (ModelState.IsValid)
{
db.Entry(provider).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(provider));
}
public ActionResult Edit([Bind(Include = "id,Name")] Category category)
{
if (ModelState.IsValid)
{
db.Entry(category).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Edit([Bind(Include = "Id,Date,Id_Provider,State")] ShopQuest shopQuest)
{
if (ModelState.IsValid)
{
db.Entry(shopQuest).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id_Provider = new SelectList(db.Provider, "Id", "Name", shopQuest.Id_Provider);
return(View(shopQuest));
}
public ActionResult Edit(OrderViewModel order)
{
if (ModelState.IsValid)
{
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerId = new SelectList(db.Customer, "Id", "FirstName", order.CustomerId);
return(View(order));
}
public ActionResult Edit([Bind(Include = "Id,Date,Id_Item,Count")] WriteOff writeOff)
{
if (ModelState.IsValid)
{
db.Entry(writeOff).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id_Item = new SelectList(db.Item, "Id", "barcode", writeOff.Id_Item);
return(View(writeOff));
}
public ActionResult Edit([Bind(Include = "ImageID,ImagePath,ImageTitle,ProdectID")] ImageT imageT)
{
if (ModelState.IsValid)
{
db.Entry(imageT).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProdectID = new SelectList(db.ProdectTs, "ProdectID", "ProdectName", imageT.ProdectID);
return(View(imageT));
}
public ActionResult Edit([Bind(Include = "id,Category_id,Name,Price,Count,Description")] Product product)
{
if (ModelState.IsValid)
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Category_id = new SelectList(db.Category, "id", "Name", product.Category_id);
return(View(product));
}
public ActionResult Edit([Bind(Include = "ProdectID,ProdectName,ProdectNameAR,Descriotion,DescriotionAR,Price,Rating,ImagePath,CategorieID")] ProdectT prodectT)
{
if (ModelState.IsValid)
{
db.Entry(prodectT).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategorieID = new SelectList(db.CategoriesTs, "CategorieID", "CategorieName", prodectT.CategorieID);
return(View(prodectT));
}
public ActionResult Edit([Bind(Include = "Id,Id_Item,Id_ShopQuest,Count")] ShopQuest_item shopQuest_item)
{
if (ModelState.IsValid)
{
db.Entry(shopQuest_item).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id_Item = new SelectList(db.Item, "Id", "barcode", shopQuest_item.Id_Item);
ViewBag.Id_ShopQuest = new SelectList(db.ShopQuest, "Id", "Id", shopQuest_item.Id_ShopQuest);
return(View(shopQuest_item));
}
public ActionResult Edit([Bind(Include = "Id,Id_Item,Id_ItemType")] Item_Type item_Type)
{
if (ModelState.IsValid)
{
db.Entry(item_Type).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id_Item = new SelectList(db.Item, "Id", "barcode", item_Type.Id_Item);
ViewBag.Id_ItemType = new SelectList(db.ItemType, "Id", "Name", item_Type.Id_ItemType);
return(View(item_Type));
}
