private void btnXoa_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Bạn có muốn xóa doanh thu ngày " + dtpNgay.Text + " không?", "Xóa", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
DoanhThuNgay dtn = new DoanhThuNgay();
dtn.madtngay = txtMa.Text;
DoanhThuNgayBUS.Instance.Xoa(dtn);
Load(sender, e);
}
}
private void dgvRevenueDay_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
DoanhThuNgay row = (DoanhThuNgay)dgvRevenueDay.SelectedItems[0];
txtMa.Text = row.madtngay;
txtTenVeNgay.Text = row.tenvengay.ToString();
dtpNgay.Text = row.ngay.ToString();
cboPhuXe.Text = row.PhuXe.hoten;
txtSoluong1.Text = row.soluongveloai1.ToString();
txtSoluong2.Text = row.soluongveloai2.ToString();
txtSoluong3.Text = row.soluongveloai3.ToString();
txtDoanhThu.Text = row.dtngay.ToString();
}
catch (Exception i)
{
}
}
public IEnumerable <DoanhThuNgay> Xem()
{
List <DoanhThuNgay> Details = new List <DoanhThuNgay>();
var result = db.Get_DoanhThuNgay().ToList();
for (int j = 0; j < result.Count; j++)
{
DoanhThuNgay dtn = new DoanhThuNgay();
dtn.PhuXe = new PhuXe();
dtn.madtngay = Convert.ToString(result[j].madtngay);
dtn.PhuXe.hoten = Convert.ToString(result[j].hoten);
dtn.tenvengay = Convert.ToString(result[j].tenvengay);
dtn.ngay = Convert.ToDateTime(result[j].ngay);
dtn.soluongveloai1 = Convert.ToInt32(result[j].soluongveloai1);
dtn.soluongveloai2 = Convert.ToInt32(result[j].soluongveloai2);
dtn.soluongveloai3 = Convert.ToInt32(result[j].soluongveloai3);
dtn.dtngay = Convert.ToDouble(result[j].dtngay);
Details.Add(dtn);
}
return(Details);
}
private void btnLuu_Click(object sender, RoutedEventArgs e)
{
DoanhThuNgay dtn = new DoanhThuNgay();
dtn.mapx = cboPhuXe.SelectedValue.ToString();
dtn.tenvengay = txtTenVeNgay.Text;
dtn.ngay = dtpNgay.SelectedDate.Value;
dtn.soluongveloai1 = Convert.ToInt32(txtSoluong1.Text);
dtn.soluongveloai2 = Convert.ToInt32(txtSoluong2.Text);
dtn.soluongveloai3 = Convert.ToInt32(txtSoluong3.Text);
dtn.dtngay = Convert.ToDouble(txtDoanhThu.Text);
if (themMoi)
{
DoanhThuNgayBUS.Instance.Them(dtn);
}
else
{
DoanhThuNgayBUS.Instance.CapNhat(dtn, maDTN);
}
Load(sender, e);
}
void ThongKe()
{
chart1.Series[0].Points.Clear();
if (cbbThongKe.Text.ToString() == "Doanh Thu")
{
// Hien thi danh sach hoa don
DataTable data = DataProvider.Instance.ExecuteQuery("exec USP_ThongKeBill @Date1 , @Date2", new object[] { DateTimeTu.Value.ToString("yyyy-MM-dd"), DateTimeDen.Value.ToString("yyyy-MM-dd") });
dtgThongKe.DataSource = data;
// lay doanh thu theo ngay va ve bieu do
List <DoanhThuNgay> listDoanhThu = new List <DoanhThuNgay>();
DataTable dataDoanhThu = DataProvider.Instance.ExecuteQuery("exec USP_BieuDoThongKeDoanhThu @Date1 , @Date2", new object[] { DateTimeTu.Value.ToString("yyyy-MM-dd"), DateTimeDen.Value.ToString("yyyy-MM-dd") });
foreach (DataRow row in dataDoanhThu.Rows)
{
DoanhThuNgay doanhThu = new DoanhThuNgay(row);
listDoanhThu.Add(doanhThu);
}
chart1.Series[0].Name = "Doanh Thu (VNĐ)";
foreach (DoanhThuNgay item in listDoanhThu)
{
chart1.Series[0].Points.AddXY(item.Date.Value.ToString("yyyy-MM-dd"), (float)item.TotalPrice);
}
dataExportExcel = data;
}
else
{
List <ThongKeSanPham> listSanPham = new List <ThongKeSanPham>();
DataTable dataSanPham = DataProvider.Instance.ExecuteQuery("exec USP_ThongKeSanPham @Date1 , @Date2", new object[] { DateTimeTu.Value.ToString("yyyy-MM-dd"), DateTimeDen.Value.ToString("yyyy-MM-dd") });
dtgThongKe.DataSource = dataSanPham;
foreach (DataRow row in dataSanPham.Rows)
{
ThongKeSanPham tkSanPham = new ThongKeSanPham(row);
listSanPham.Add(tkSanPham);
}
chart1.Series[0].Name = "Số Lượng Đã Bán";
foreach (ThongKeSanPham item in listSanPham)
{
chart1.Series[0].Points.AddXY(item.TenSP.ToString(), item.DaBan);
}
dataExportExcel = dataSanPham;
}
try
{
string doanhThuNow = DataProvider.Instance.ExecuteScalar("select sum(totalPrice) from Bill where DateCheckIn = '" + DateTime.Now.ToString("yyyy-MM-dd") + "' group by DateCheckIn").ToString();
lblDoanhThu.Text = doanhThuNow.ToString() + " ₫";
string hoaDonNow = DataProvider.Instance.ExecuteScalar("select count(DateCheckIn) from Bill where DateCheckIn = '" + DateTime.Now.ToString("yyyy-MM-dd") + "'").ToString();
lblSLHoaDon.Text = hoaDonNow.ToString();
string daBanNow = DataProvider.Instance.ExecuteScalar("select sum(bi.count) from BillInfo as bi, Bill as b where DateCheckIn = '" + DateTime.Now.ToString("yyyy-MM-dd") + "' and bi.idBill = b.id group by b.DateCheckIn").ToString();
lblSLDaBan.Text = daBanNow.ToString();
}
catch (Exception ex)
{
}
}
public void Xoa(DoanhThuNgay dtn)
{
DoanhThuNgayDAO.Instance.Xoa(dtn);
}
public void CapNhat(DoanhThuNgay dtn, string maDTN)
{
DoanhThuNgayDAO.Instance.CapNhat(dtn, maDTN);
}
public void Them(DoanhThuNgay dtn)
{
DoanhThuNgayDAO.Instance.Them(dtn);
}
public void Xoa(DoanhThuNgay dtn)
{
var result = db.Delete_DoanhThuNgay(dtn.madtngay);
}
public void CapNhat(DoanhThuNgay dtn, string maDTN)
{
var result = db.Update_DoanhThuNgay(maDTN, dtn.mapx, dtn.tenvengay, dtn.ngay, dtn.soluongveloai1, dtn.soluongveloai2, dtn.soluongveloai3, dtn.dtngay);
}
public void Them(DoanhThuNgay dtn)
{
var result = db.Insert_DoanhThuNgay(dtn.mapx, dtn.tenvengay, dtn.ngay, dtn.soluongveloai1, dtn.soluongveloai2, dtn.soluongveloai3, dtn.dtngay);
}
