private void BtnDelete_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show($"Are you sure that you want to delete this?", "Delete", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
if (dgFurniture.Visibility.Equals(Visibility.Visible))
{
FurnitureDAO.Delete(SelectedFurniture);
}
else if (dgFurnitureType.Visibility.Equals(Visibility.Visible))
{
FurnitureTypeDAO.Delete(SelectedFurnitureType);
}
else if (dgSales.Visibility.Equals(Visibility.Visible))
{
SaleDAO.Delete(SelectedSale);
SaleDAO.DeleteFurnitureSale(SelectedSale);
}
else if (dgUsers.Visibility.Equals(Visibility.Visible))
{
UserDAO.Delete(SelectedUser);
}
else if (dgAdditionalService.Visibility.Equals(Visibility.Visible))
{
AdditionalServiceDAO.Delete(SelectedAdditionalService);
}
}
}
private void button3_Click(object sender, EventArgs e)
{
FrmAgregarVenta fav = new FrmAgregarVenta();
fav.ShowDialog();
dgvListaVentas.DataSource = SaleDAO.getAll();
}
public ActionResult BuyItems()
{
if (!Authentication.IsValid())
{
return(Json(new { Error = "Not Authenticated" }));
}
SaleDAO.BuyItemsByCart();
return(Json(new { Success = "Success" }));
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 5)
{
FrmVerVenta fvv = new FrmVerVenta(int.Parse(dgvListaVentas.Rows[e.RowIndex].Cells[0].Value + ""));
fvv.ShowDialog();
dgvListaVentas.DataSource = SaleDAO.getAll();
}
}
public ActionResult Get(uint id)
{
if (!Authentication.IsValid())
{
return(Json(new { Error = "Not Authenticated" }));
}
JsonResult json = Json(new { Object = SaleDAO.GetItemSaleById(id) });
json.MaxJsonLength = int.MaxValue;
return(json);
}
private void checkBox2_CheckedChanged(object sender, EventArgs e)
{
if (chbBuscar.Checked)
{
pnlContenedorBuscar.Visible = true;
}
else
{
pnlContenedorBuscar.Visible = false;
dgvListaVentas.DataSource = SaleDAO.getAll();
}
}
public static void CheckSaleDate()
{
foreach (var sale in Project.Instance.SalesList)
{
int dateCompare = DateTime.Compare(sale.EndDate, DateTime.Now);
if (dateCompare < 0 || sale.Deleted)
{
SaleDAO.Delete(sale);
SaleDAO.DeleteFurnitureSale(sale);
}
}
}
public ActionResult Edit(int id)
{
var model = new ProductDAO().ViewDetail(id);
var sale = new SaleDAO().ViewDetailNew(model.ID);
if (sale != null)
{
ViewBag.sale = sale;
}
setViewBag();
setProducer();
return(View(model));
}
public static List <Sale> Select(DateTime start, DateTime end)
{
DataTable source = SaleDAO.Select(start, end);
List <Sale> sale = new List <Sale>();
if (source != null)
{
for (int i = 0; i < source.Rows.Count; i++)
{
sale.Add(new Sale(Convert.ToDateTime(source.Rows[i][0].ToString()), double.Parse(source.Rows[i][1].ToString()), double.Parse(source.Rows[i][2].ToString())));
}
}
return(sale);
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
if (IsValid() == false)
{
return;
}
if (dpStartDate.SelectedDate > dpEndDate.SelectedDate ||
dpStartDate.SelectedDate < DateTime.Now.AddDays(-1))
{
MessageBox.Show("Please pick a valid date.", "Bad date", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
switch (operation)
{
case Operation.ADD:
sale.StartDate = (DateTime)dpStartDate.SelectedDate;
sale.EndDate = (DateTime)dpEndDate.SelectedDate;
SaleDAO.Create(sale);
break;
case Operation.EDIT:
foreach (var s in Project.Instance.SalesList)
{
if (s.ID == sale.ID)
{
if (s.StartDate != (DateTime)dpStartDate.SelectedDate)
{
MessageBox.Show("You cannot edit start date.", "Error", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
s.Discount = sale.Discount;
s.StartDate = (DateTime)dpStartDate.SelectedDate;
s.EndDate = (DateTime)dpEndDate.SelectedDate;
s.Deleted = sale.Deleted;
MainWindow.CheckSaleDate();
SaleDAO.Update(s);
break;
}
}
break;
}
this.Close();
}
private void BtnAddSale_Click(object sender, RoutedEventArgs e)
{
SaleDAO.AddFurnitureSale(SelectedSale, furniture);
furniture.Sales.Add(SelectedSale);
var pricePrim = furniture.Price;
if (furniture.Sales != null)
{
foreach (var s in furniture.Sales)
{
furniture.PriceOnSale = pricePrim - (pricePrim / 100 * s.Discount);
pricePrim = furniture.PriceOnSale;
}
}
FurnitureDAO.Update(furniture);
MessageBox.Show("Success!", "Congratulations", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
}
public static bool Insert(DataTable source, Customer customer, string money, string card, string term)
{
List <SaleItem> saleItem = new List <SaleItem>();
for (int i = 0; i < source.Rows.Count; i++)
{
saleItem.Add(new SaleItem(source.Rows[i][1].ToString(), int.Parse(source.Rows[i][3].ToString())));
}
DateTime date = DateTime.Now;
double termD = double.Parse(term);
Sale sale = new Sale(date, customer, double.Parse(money), double.Parse(card), saleItem);
if (termD > 0)
{
BillItem billItem = new BillItem(date, termD, sale);
return(SaleDAO.Insert(billItem));
}
else
{
return(SaleDAO.Insert(sale));
}
}
private void FrmCatalagoVentas_Load(object sender, EventArgs e)
{
dgvListaVentas.DataSource = SaleDAO.getAll();
}
public ActionResult Edit(Product product, IEnumerable <HttpPostedFileBase> MoreImage, long?price, long?sale, DateTime?beginDate, DateTime?endDate)
{
if (ModelState.IsValid)
{
//láy hình ảnh thêm vao trong thư mục data
//mục thêm nhiều hình ảnh
int i = 0;
string path = "/Data/images/Product/";
XElement xElement = new XElement("Images");//khổi tạo xml có node là Images
if (MoreImage.First() != null)
{
foreach (var file in MoreImage)
{
if (file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName); //lấy tên hình ảnh
string[] name = fileName.Split('.'); //tách để đổi tên hình ảnh
name[0] = product.MetaTitle + "-item_" + i++; //đổi tên sản phẩm
var rename = name[0] + "." + name[1]; //gáng lại vào chuỗi
var filePath = Path.Combine(Server.MapPath(path), rename);
file.SaveAs(filePath);
xElement.Add(new XElement("Image", path + rename));
}
}
//gáng hình vào object product
product.MoreImage = xElement.ToString();
}
var dao = new ProductDAO();
var model = dao.Update(product);
if (model)
{
TempData["Success"] = "Cập nhập sản phẩm thành công";
//nếu giá mà thay đổi sé thêm mới
//cập nhập giá
var prices = new PriceDAO().ViewDetailNew(product.ID);
var sales = new SaleDAO().ViewDetailNew(product.ID);
if (prices.Price1 != price && price != null)
{
var priceNew = new Price();
priceNew.Price1 = price;
priceNew.ProductID = product.ID;
new PriceDAO().Create(priceNew, Session["username"].ToString());
}
if (sales != null)
{
if (sales.Price != sale && sale != null)
{
var saleNew = new Sale();
saleNew.Price = sale;
saleNew.ProductID = product.ID;
saleNew.BeginDate = (DateTime)beginDate;
saleNew.EndDate = (DateTime)endDate;
new SaleDAO().Create(saleNew);
}
}
else
{
var saleNew = new Sale();
saleNew.Price = sale;
saleNew.ProductID = product.ID;
saleNew.BeginDate = (DateTime)beginDate;
saleNew.EndDate = (DateTime)endDate;
new SaleDAO().Create(saleNew);
}
return(RedirectToAction("Index", "Product"));
}
else
{
TempData["Error"] = "Cập nhập sản phẩm thất bại";
return(View("Edit"));
}
}
setViewBag();
setProducer();
TempData["Error"] = "Cập nhập sản phẩm thất bại";
return(View("Edit"));
}
