public void InstanceDB()
{
AppDataBase db = new AppDataBase();
Realms.Realm instance = db.GetInstanceSync();
ReceiptDao = new ReceiptDao(instance);
}
private void btnConfirm_Click(object sender, EventArgs e)
{
lsvReceipt.Items.Clear();
lsvReceiptDetail.Items.Clear();
DateTime startDate = dtmStartDate.Value;
DateTime endDate = dtmEndDate.Value;
if (startDate >= endDate)
{
MessageBox.Show("Ngày bắt đầu không thể lớn hơn ngày kết thúc");
}
ReceiptDao dao = new ReceiptDao();
List <Receipt> receipts = dao.GetReceiptListByDate(startDate.ToString(), endDate.ToString());
if (receipts.Count > 0)
{
receipts.ForEach(receipt =>
{
string[] row = { receipt.ReceiptID.ToString(), receipt.PrintDate.ToString(), receipt.EmployeeID.ToString(), receipt.Total.ToString() };
ListViewItem item = new ListViewItem(row);
lsvReceipt.Items.Add(item);
});
}
}
public ActionResult Payment(string ten, string diachi, string sdt, string email)
{
var user = (User)Session[FashionShop.Common.CommonConstants.USER_SESSION];
Receipt re = new Receipt();
re.diaChiGiaoHang = diachi;
re.soDienThoai = sdt;
re.username = user.username;
re.tinhTrang = "Chưa giao hàng";
try
{
ReceiptDao dao = new ReceiptDao();
var ma = dao.Insert(re);
var cart = (List <CartItem>)Session[Common.CommonConstants.CART_SESSION];
foreach (var item in cart)
{
ReceiptDetail detail = new ReceiptDetail();
detail.maHoaDon = ma;
detail.maSanPham = item.product.maSanPham;
detail.size = item.size;
detail.soLuongDatMua = item.soLuong;
detail.thanhTien = (long)(item.soLuong * int.Parse(item.product.giaSanPham.ToString()));
dao.InsertDetail(detail);
}
}
catch (Exception ex)
{
return(View("Error"));
}
return(View("Success"));
}
public OrderService(EmailSender emailSender, ReceiptPrinter receiptPrinter, OrderDao orderDao, ReceiptDao receiptDao, RecommendationEngine recommendationEngine)
{
_emailSender = emailSender;
_receiptPrinter = receiptPrinter;
_orderDao = orderDao;
_receiptDao = receiptDao;
_recommendationEngine = recommendationEngine;
}
public void byDay()
{
lsvGeneralReport.Items.Clear();
//in
ReceiptDao r = new ReceiptDao();
var incomes = r.GetReceiptList();
IDictionary <DateTime, double> list = new Dictionary <DateTime, double>();
list.Add(incomes[0].PrintDate.Date, incomes[0].Total + incomes[0].AdditionalFee);
for (int i = 1; i < incomes.Count; i++)
{
if (!list.ContainsKey(incomes[i].PrintDate.Date))
{
list.Add(incomes[i].PrintDate.Date, incomes[i].Total + incomes[i].AdditionalFee);
}
else
{
list[incomes[i].PrintDate.Date] += incomes[i].Total + incomes[i].AdditionalFee;
}
}
//out
PaymentDao p = new PaymentDao();
var outcomes = p.GetPaymentList();
IDictionary <DateTime, double> list1 = new Dictionary <DateTime, double>();
list1.Add(outcomes[0].PayDate.Date, outcomes[0].TotalFee);
for (int i = 1; i < outcomes.Count; i++)
{
if (!list1.ContainsKey(outcomes[i].PayDate.Date))
{
list1.Add(outcomes[i].PayDate.Date, outcomes[i].TotalFee);
}
else
{
list1[outcomes[i].PayDate.Date] += outcomes[i].TotalFee;
}
}
foreach (KeyValuePair <DateTime, double> kvp in list)
{
string[] row = { kvp.Key.ToString(), kvp.Value.ToString(), "", (kvp.Value - 0).ToString() };
ListViewItem item = new ListViewItem(row);
lsvGeneralReport.Items.Add(item);
foreach (KeyValuePair <DateTime, double> kvp1 in list1)
{
if (kvp1.Key.Date == kvp.Key.Date)
{
string[] rows = { kvp.Key.ToString(), kvp.Value.ToString(), kvp1.Value.ToString(), (kvp.Value - kvp1.Value).ToString() };
item = new ListViewItem(rows);
lsvGeneralReport.Items.RemoveAt(lsvGeneralReport.Items.Count - 1);
lsvGeneralReport.Items.Add(item);
}
}
}
}
private void LoadReceipsToForm()
{
ReceiptDao dao = new ReceiptDao();
List <Receipt> receipts = dao.GetReceiptList();
receipts.ForEach(receipt =>
{
string[] row = { receipt.ReceiptID.ToString(), receipt.PrintDate.ToString(), receipt.EmployeeID.ToString(), receipt.Total.ToString() };
ListViewItem item = new ListViewItem(row);
lsvReceipt.Items.Add(item);
});
}
private void btnDatBan_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtTotal.Text) || string.IsNullOrEmpty(txtTableNumber.Text))
{
MessageBox.Show("Vui lòng điền số bàn và chọn sản phẩm ");
return;
}
double total = double.Parse(txtTotal.Text);
if (total <= 0)
{
MessageBox.Show("Vui lòng chọn sản phẩm ");
return;
}
try
{
int index = new ReceiptDao().AddReceipt(new Receipt(cUser.EmployeeId, int.Parse(txtTableNumber.Text), new DateTime().Date, total, 0));
if (index > 0)
{
foreach (var myitem in productsMap)
{
new ReceiptDetailDao().AddReceiptDetail(new ReceiptDetail(index, myitem.Key.ProductID, myitem.Value, total));
}
MessageBox.Show("Đặt Bàn Thành Công");
lsvOrder.Items.Clear();
txtTableNumber.Text = "";
txtTotal.Text = "";
btnDatBan.Enabled = false;
}
else
{
MessageBox.Show("thất bại rồi");
}
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
public void byMonth()
{
lsvGeneralReport.Items.Clear();
ReceiptDao r = new ReceiptDao();
PaymentDao p = new PaymentDao();
var incomes = r.GetReceiptList();
for (int i = 1; i <= 12; i++)
{
if (i >= 10)
{
string[] rows = { "Tháng " + i, "" + r.GetByMonth(i.ToString()), "" + p.GetByMonth(i.ToString()), (r.GetByMonth(i.ToString()) - p.GetByMonth(i.ToString())).ToString() };
ListViewItem item = new ListViewItem(rows);
lsvGeneralReport.Items.Add(item);
}
else
{
string[] rowss = { "Tháng " + i, "" + r.GetByMonth("0" + i.ToString()), "" + p.GetByMonth("0" + i.ToString()), (r.GetByMonth("0" + i.ToString()) - p.GetByMonth("0" + i.ToString())).ToString() };
var item = new ListViewItem(rowss);
lsvGeneralReport.Items.Add(item);
}
}
}
