void Loading()
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
data_grid.DataSource = db.PRODUCTs.ToList();
}
}
void Loading()
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
bunifuCustomDataGrid1.DataSource = db.PRODUCTs.ToList();
}
}
private void btn_delete_Click(object sender, EventArgs e)
{
if (!add)
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
try
{
int index = bunifuCustomDataGrid1.CurrentRow.Index;
index = int.Parse(bunifuCustomDataGrid1.Rows[index].Cells[0].Value.ToString());
PRODUCT prdct = db.PRODUCTs.SingleOrDefault(x => x.ID == index);
db.PRODUCTs.DeleteOnSubmit(prdct);
db.SubmitChanges();
notifyIcon1.Visible = true;
notifyIcon1.Icon = SystemIcons.Exclamation;
notifyIcon1.BalloonTipTitle = "Delete Successful";
notifyIcon1.BalloonTipText = "Your product has been deleted in Database!";
notifyIcon1.BalloonTipIcon = ToolTipIcon.Info;
notifyIcon1.ShowBalloonTip(1000);
}
catch
{
notifyIcon1.Visible = true;
notifyIcon1.Icon = SystemIcons.Exclamation;
notifyIcon1.BalloonTipTitle = "Can't Delete new Product to Database";
notifyIcon1.BalloonTipText = "Check your id is Valid!";
notifyIcon1.BalloonTipIcon = ToolTipIcon.Error;
notifyIcon1.ShowBalloonTip(1000);
}
}
Loading();
bunifuCustomDataGrid1.DataSource = Loaded_Record(page_number, number_record);
}
}
void Loading()
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
bunifuCustomDataGrid1.DataSource = db.PRODUCTs.ToList();
txt_bill.Text = (db.BILLs.Count() + 1).ToString();
}
}
public void UC_Dashboard_Load(object sender, EventArgs e)
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
lbl_product.Text = db.PRODUCTs.Count().ToString();
lbl_producer.Text = db.GETPRODUCER().Count().ToString();
lbl_invoice.Text = db.BILLs.Count().ToString();
}
}
public List <BILL> Loaded_Record(int page, int recordNum)
{
List <BILL> resulf = new List <BILL>();
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
resulf = db.BILLs.Skip((page - 1) * recordNum).Take(recordNum).ToList();
}
return(resulf);
}
private void numericUpDown1_ValueChanged(object sender, EventArgs e)
{
NumericUpDown num = sender as NumericUpDown;
int totalrecord = 0;
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
totalrecord = db.BILLs.Count();
}
num.Maximum = totalrecord / number_record + 1;
page_number = (int)num.Value;
data_grid.DataSource = Loaded_Record(page_number, number_record);
}
private void radiobtn_product_CheckedChanged(object sender, EventArgs e)
{
dropdown_producer.Enabled = true;
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
dropdown_producer.Clear();
var temp = db.GETPRODUCER().ToList();
foreach (var i in temp)
{
dropdown_producer.AddItem(i.PRODUCER);
}
}
}
private void bunifuFlatButton4_Click(object sender, EventArgs e)
{
try
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
var rs = db.BILLs.Where(q => q.NAME_PRODUCT.Contains(txt_search.Text)).ToList();
data_grid.DataSource = rs;
}
}
catch
{
}
}
private void btn_update_Click(object sender, EventArgs e)
{
if (!add)
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
try
{
PRODUCT prodct = new PRODUCT
{
ID = int.Parse(txt_id.Text),
NAME = txt_name.Text,
CATEGORY = txt_category.Text,
PRODUCER = txt_producer.Text,
PURCHASE_PRICE = int.Parse(txt_purchase.Text),
PRICE = int.Parse(txt_price.Text),
INVENTORY = int.Parse(txt_inventory.Text),
};
PRODUCT temp = db.PRODUCTs.SingleOrDefault(x => x.ID == prodct.ID);
temp.ID = int.Parse(txt_id.Text);
temp.NAME = txt_name.Text;
temp.CATEGORY = txt_category.Text;
temp.PRODUCER = txt_producer.Text;
temp.PURCHASE_PRICE = int.Parse(txt_purchase.Text);
temp.PRICE = int.Parse(txt_price.Text);
temp.INVENTORY = int.Parse(txt_inventory.Text);
db.SubmitChanges();
notifyIcon1.Visible = true;
notifyIcon1.Icon = SystemIcons.Exclamation;
notifyIcon1.BalloonTipTitle = "Update Successful!";
notifyIcon1.BalloonTipText = "Your product has been updated in Database!";
notifyIcon1.BalloonTipIcon = ToolTipIcon.Info;
notifyIcon1.ShowBalloonTip(1000);
}
catch
{
notifyIcon1.Visible = true;
notifyIcon1.Icon = SystemIcons.Exclamation;
notifyIcon1.BalloonTipTitle = "Can't Delete new Product to Database";
notifyIcon1.BalloonTipText = "Check your id is Valid!";
notifyIcon1.BalloonTipIcon = ToolTipIcon.Error;
notifyIcon1.ShowBalloonTip(1000);
}
}
Loading();
bunifuCustomDataGrid1.DataSource = Loaded_Record(page_number, number_record);
}
}
private void txt_search_KeyPress(object sender, KeyPressEventArgs e)
{
try
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
if (e.KeyChar == (char)13)
{
var rs = db.BILLs.Where(q => q.NAME_PRODUCT.Contains(txt_search.Text)).ToList();
data_grid.DataSource = rs;
}
}
}
catch
{
}
}
private void bunifuFlatButton2_Click(object sender, EventArgs e)
{
if (db_excel == null)
{
Loading();
bunifuCustomDataGrid1.DataSource = Loaded_Record(page_number, number_record);
}
else
{
try
{
int totalrecord;
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
totalrecord = db.PRODUCTs.Count();
int temp = db.PRODUCTs.OrderByDescending(x => x.ID).First().ID;
if (temp <= totalrecord)
{
temp = totalrecord;
}
for (int i = 0; i < db_excel.Count; i++)
{
db_excel[i].ID = db_excel[i].ID + temp;
totalrecord = db.PRODUCTs.Count();
db.PRODUCTs.InsertOnSubmit(db_excel[i]);
db.SubmitChanges();
}
bunifuCustomDataGrid1.DataSource = Loaded_Record(page_number, number_record);
}
}
catch
{
notifyIcon1.Visible = true;
notifyIcon1.Icon = SystemIcons.Exclamation;
notifyIcon1.BalloonTipTitle = "Can't Add new Product to Database";
notifyIcon1.BalloonTipText = "Check your input is Valid!";
notifyIcon1.BalloonTipIcon = ToolTipIcon.Error;
notifyIcon1.ShowBalloonTip(1000);
}
}
txt_search.Text = "";
}
private void btn_add_Click(object sender, EventArgs e)
{
if (add)
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
try
{
PRODUCT prodct = new PRODUCT
{
ID = int.Parse(txt_id.Text),
NAME = txt_name.Text,
CATEGORY = txt_category.Text,
PRODUCER = txt_producer.Text,
PURCHASE_PRICE = int.Parse(txt_purchase.Text),
PRICE = int.Parse(txt_price.Text),
INVENTORY = int.Parse(txt_inventory.Text),
};
db.PRODUCTs.InsertOnSubmit(prodct);
db.SubmitChanges();
notifyIcon1.Visible = true;
notifyIcon1.Icon = SystemIcons.Exclamation;
notifyIcon1.BalloonTipTitle = "Add Successfull!";
notifyIcon1.BalloonTipText = "Your product is added in Database!";
notifyIcon1.BalloonTipIcon = ToolTipIcon.Info;
notifyIcon1.ShowBalloonTip(1000);
}
catch
{
notifyIcon1.Visible = true;
notifyIcon1.Icon = SystemIcons.Exclamation;
notifyIcon1.BalloonTipTitle = "Can't Add new Product to Database";
notifyIcon1.BalloonTipText = "Check your input is Valid!";
notifyIcon1.BalloonTipIcon = ToolTipIcon.Error;
notifyIcon1.ShowBalloonTip(1000);
}
}
Loading();
bunifuCustomDataGrid1.DataSource = Loaded_Record(page_number, number_record);
}
}
private void btn_printbill_Click(object sender, EventArgs e)
{
try
{
if (txt_namecustomer.Text != "")
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
bool type_pay;
if (bunifuDropdown1.selectedIndex != 1)
{
type_pay = false;
}
else
{
type_pay = true;
}
BILL bil = new BILL
{
ID_BILL = int.Parse(txt_bill.Text),
ID_PRODUCT = int.Parse(txt_id.Text),
NAME_CUSTOMER = txt_namecustomer.Text,
NAME_PRODUCT = txt_name.Text,
PRODUCER = txt_category.Text,
PRICE = int.Parse(txt_price.Text),
AMOUNT = Convert.ToInt32(numericUpDown1.Value),
DATE_TIME = bunifuDatepicker1.Value,
ADVANCE = int.Parse(txt_price.Text),
TYPE_PAY = bunifuDropdown1.selectedValue,
TOTAL = int.Parse(txt_total.Text),
TRANGTHAI = type_pay,
};
PRODUCT temp = db.PRODUCTs.SingleOrDefault(x => x.ID == bil.ID_PRODUCT);
temp.INVENTORY--;
if (temp.INVENTORY < 0)
{
notifyIcon1.Visible = true;
notifyIcon1.Icon = SystemIcons.Exclamation;
notifyIcon1.BalloonTipTitle = "Don't have any product in Inventory";
notifyIcon1.BalloonTipText = "Please choose another Product, this Product is sold out!";
notifyIcon1.BalloonTipIcon = ToolTipIcon.Error;
notifyIcon1.ShowBalloonTip(1000);
}
else
{
db.BILLs.InsertOnSubmit(bil);
db.SubmitChanges();
notifyIcon1.Visible = true;
notifyIcon1.Icon = SystemIcons.Exclamation;
notifyIcon1.BalloonTipTitle = "Add Successfull!";
notifyIcon1.BalloonTipText = "Your Bill is added in Database!";
notifyIcon1.BalloonTipIcon = ToolTipIcon.Info;
notifyIcon1.ShowBalloonTip(1000);
bunifuFlatButton2_Click(sender, e);
}
};
}
}
catch
{
notifyIcon1.Visible = true;
notifyIcon1.Icon = SystemIcons.Exclamation;
notifyIcon1.BalloonTipTitle = "Can't Add new Bill to Database";
notifyIcon1.BalloonTipText = "Check your input is Valid!";
notifyIcon1.BalloonTipIcon = ToolTipIcon.Error;
notifyIcon1.ShowBalloonTip(1000);
}
}
private void btn_loadChart_Click(object sender, EventArgs e)
{
//Clear Biểu đồ
foreach (var series in chart1.Series)
{
series.Points.Clear();
}
//Xử lý đọc doanh số từ NSX
if (radiobtn_producer.Checked)
{
if (radiobtn_time.Checked)
{
if (dropdown_type.selectedValue == "Day")
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
var temp = db.GETPRODUCERBYDAY(bunifuDatepicker1.Value.Date).ToList();
foreach (var i in temp)
{
chart1.Series["Value"].Points.AddXY(i.PRODUCER, i.Total);
}
}
}
else if (dropdown_type.selectedValue == "Month")
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
var temp = db.GETPRODUCERBYMONTH(bunifuDatepicker1.Value.Date.Month.ToString(), bunifuDatepicker1.Value.Date.Year.ToString()).ToList();
foreach (var i in temp)
{
chart1.Series["Value"].Points.AddXY(i.PRODUCER, i.Total);
}
}
}
else
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
var temp = db.GETPRODUCERBYYEAR(bunifuDatepicker1.Value.Date.Year.ToString()).ToList();
foreach (var i in temp)
{
chart1.Series["Value"].Points.AddXY(i.PRODUCER, i.Total);
}
}
}
}
else
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
var temp = db.GETPRODUCERBY2DAYS(bunifuDatepicker3.Value.Date, bunifuDatepicker2.Value.Date).ToList();
foreach (var i in temp)
{
chart1.Series["Value"].Points.AddXY(i.PRODUCER, i.Total);
}
}
}
}
//Xử lý đọc sản phẩm từ NSX
else
{
if (radiobtn_time.Checked)
{
if (dropdown_type.selectedValue == "Day")
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
var temp = db.GETPRODUCTBYDAY(bunifuDatepicker1.Value.Date, dropdown_producer.selectedValue).ToList();
foreach (var i in temp)
{
chart1.Series["Value"].Points.AddXY(i.NAME_PRODUCT, i.Total);
}
}
}
else if (dropdown_type.selectedValue == "Month")
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
var temp = db.GETPRODUCTBYMONTH(bunifuDatepicker1.Value.Date.Month.ToString(), bunifuDatepicker1.Value.Date.Year.ToString(), dropdown_producer.selectedValue).ToList();
foreach (var i in temp)
{
chart1.Series["Value"].Points.AddXY(i.NAME_PRODUCT, i.Total);
}
}
}
else
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
var temp = db.GETPRODUCTBYYEAR(bunifuDatepicker1.Value.Date.Year.ToString(), dropdown_producer.selectedValue).ToList();
foreach (var i in temp)
{
chart1.Series["Value"].Points.AddXY(i.NAME_PRODUCT, i.Total);
}
}
}
}
else
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
var temp = db.GETPRODUCTBY2DAYS(bunifuDatepicker3.Value.Date, bunifuDatepicker2.Value.Date, dropdown_producer.selectedValue).ToList();
foreach (var i in temp)
{
chart1.Series["Value"].Points.AddXY(i.NAME_PRODUCT, i.Total);
}
}
}
}
}
private void bunifuImageButton1_Click(object sender, EventArgs e)
{
foreach (var series in chart2.Series)
{
series.Points.Clear();
}
if (radiobtn_time2.Checked)
{
if (dropdown_type2.selectedValue == "Day")
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
int total = db.BILLs.Where(x => x.DATE_TIME == bunifuDatepicker6.Value.Date).Sum(x => x.PRICE);
var temp = db.GETREVENUEBYDAY(bunifuDatepicker6.Value.Date).ToList();
int purchase = 0;
foreach (var i in temp)
{
purchase = purchase + (i.PURCHASE_PRICE * (int)i.Amount);
}
lstSoBanNgay.Add(new KeyValuePair <DateTime, int>(bunifuDatepicker6.Value.Date, purchase));
chart2.Series["SELL"].Points.AddXY(lstSoBanNgay[0].Key.ToString("dd - MM - yy"), total);
chart2.Series["PURCHASE"].Points.AddXY(lstSoBanNgay[0].Key.ToString("dd - MM - yy"), lstSoBanNgay[0].Value);
}
}
else if (dropdown_type.selectedValue == "Month")
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
var temp = db.GETPRODUCERBYMONTH(bunifuDatepicker1.Value.Date.Month.ToString(), bunifuDatepicker1.Value.Date.Year.ToString()).ToList();
foreach (var i in temp)
{
chart1.Series["Value"].Points.AddXY(i.PRODUCER, i.Total);
}
}
}
else
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
var temp = db.GETPRODUCERBYYEAR(bunifuDatepicker1.Value.Date.Year.ToString()).ToList();
foreach (var i in temp)
{
chart1.Series["Value"].Points.AddXY(i.PRODUCER, i.Total);
}
}
}
}
else
{
using (DataStoreManagementDataContext db = new DataStoreManagementDataContext())
{
var temp = db.GETREVENUEBY2DAY(bunifuDatepicker4.Value.Date, bunifuDatepicker5.Value.Date).ToList();
int total = 0;
int purchase = 0;
for (var day2 = bunifuDatepicker4.Value.Date; day2 <= bunifuDatepicker5.Value.Date; day2 = day2.AddDays(1))
{
if (db.BILLs.Where(x => x.DATE_TIME == day2.Date).ToList().Count() == 0)
{
total = 0;
}
else
{
total = db.BILLs.Where(x => x.DATE_TIME == day2.Date).Sum(x => x.PRICE);
var temp2 = db.GETREVENUEBYDAY(day2.Date).ToList();
purchase = 0;
foreach (var i in temp2)
{
purchase = purchase + (i.PURCHASE_PRICE * (int)i.Amount);
}
}
chart2.Series["SELL"].Points.AddXY(day2.Date.ToString("dd - MM - yy"), total);
chart2.Series["PURCHASE"].Points.AddXY(day2.Date.ToString("dd - MM - yy"), purchase);
}
}
}
}
