private void LoadPhoneSample()
{
using (var ctx = new PhoneStoreManageEntities())
{
var query = from q in ctx.MauDienThoais
select new
{
q.MaMDT,
q.HangDienThoai.TenHDT,
q.TenDT,
q.NamSX,
q.KM,
q.MoTa
};
if (cbbBrandFilter.SelectedIndex > -1)
{
query = from q in query
where
q.TenHDT == cbbBrandFilter.SelectedItem.ToString()
select q;
}
dgvPhoneSamples.DataSource = query.ToList();
dgvPhoneSamples.Columns[0].Visible = false;
dgvPhoneSamples.Columns[1].Visible = false;
dgvPhoneSamples.Columns[5].Visible = false;
dgvPhoneSamples.Columns[2].HeaderText = "Tên điện thoại";
dgvPhoneSamples.Columns[3].HeaderText = "Năm sản xuất";
dgvPhoneSamples.Columns[4].HeaderText = "Khuyến mãi";
dgvPhoneSamples.Refresh();
}
}
private void LoadInfor()
{
using (var ctx = new PhoneStoreManageEntities())
{
var maNV = (from acc in ctx.Accounts where acc.Username == username select acc.MaNV).FirstOrDefault();
var query = (from emp in ctx.NhanViens
where emp.MaNV == maNV
select emp);
txtID.Text = maNV.ToString();
txtName.Text = (from q in query select q.TenNV).FirstOrDefault();
datBirth.Value = (from q in query select q.NgaySinh).FirstOrDefault().Value;
if ((from q in query select q.GioiTinh).FirstOrDefault().ToString() == "Nam")
{
radMale.Checked = true;
}
else
{
radFemale.Checked = true;
}
txtPhone.Text = (from q in query select q.SoDienThoai).FirstOrDefault().ToString();
txtPos.Text = (from q in query select q.ChucVu.TenCV).FirstOrDefault().ToString();
txtSalary.Text = (from q in query select q.Luong).FirstOrDefault().ToString();
txtAdress.Text = (from q in query select q.DiaChi).FirstOrDefault().ToString();
txtContractID.Text = (from q in query select q.MaHopDong).FirstOrDefault().ToString();
txtContractType.Text = (from q in query select q.HopDong.TenLoaiHopDong).FirstOrDefault().ToString();
datStarted.Value = (from q in query select q.HopDong.Ngaybatdau).FirstOrDefault().Value;
datEnd.Value = (from q in query select q.HopDong.Ngayketthuc).FirstOrDefault().Value;;
txtUsername.Text = username;
}
}
private void LoadBillList()
{
using (var ctx = new PhoneStoreManageEntities())
{
var query = from q in ctx.HoaDons
select new
{
q.MaHD,
q.MaNV,
q.NhanVien.TenNV,
q.KhachHang.TenKH,
q.NgayMua,
q.HanBH,
q.PTMuaHang,
q.PTThanhToan,
q.Tongtien
};
dgvBill.DataSource = query.ToList();
dgvBill.Columns[3].Visible = false;
dgvBill.Columns[4].Visible = false;
dgvBill.Columns[6].Visible = false;
dgvBill.Columns[7].Visible = false;
dgvBill.Columns[0].HeaderText = "Mã HD";
dgvBill.Columns[1].HeaderText = "Mã NV";
dgvBill.Columns[2].HeaderText = "Nhân viên";
dgvBill.Columns[5].HeaderText = "Bảo hành";
dgvBill.Columns[8].HeaderText = "Tổng tiền";
dgvBill.Refresh();
}
}
void ChoosePhones()
{
var cRow = dgvPhones.CurrentCell.RowIndex;
var PhoneID = Int32.Parse(dgvPhones.Rows[cRow].Cells[0].FormattedValue.ToString());
using (var ctx = new PhoneStoreManageEntities())
{
var lastDBillID = (from db in ctx.ChiTietHoadons orderby db.MaCTHD descending select db.MaCTHD).FirstOrDefault();
var newDeBill = new ChiTietHoadon
{
MaCTHD = lastDBillID + 1,
MaHD = billID,
MaDT = PhoneID
};
ctx.ChiTietHoadons.Add(newDeBill);
ctx.SaveChanges();
//var countPhone = (from db in ctx.ChiTietHoadons where db.MaHD == billID && db.MaDT == PhoneID select db).Count();
var detailBill = (from db in ctx.ChiTietHoadons
where db.MaHD == billID
select new
{
db.DienThoai.MaDT,
//db.MaHD,
db.DienThoai.MauDienThoai.TenDT,
db.DienThoai.Mau,
db.DienThoai.Gia
}); //.Distinct();
dgvDetailBillPhones.DataSource = detailBill.ToList();
dgvDetailBillPhones.Columns[0].Visible = false;
dgvDetailBillPhones.Refresh();
LoadPhones();
}
}
private void CreateBills()
{
using (var ctx = new PhoneStoreManageEntities())
{
var cus = (from c in ctx.KhachHangs where c.SoDienThoai == txtSearchCus.Text select c).FirstOrDefault();
cus.TenKH = txtCustomer.Text;
cus.GioiTinh = radMale.Checked ? "Nam" : "Nữ";
cus.NgaySinh = datBirth.Value;
cus.Email = txtEmail.Text;
cus.DiaChi = txtAdress.Text;
var lastBillID = (from bill in ctx.HoaDons orderby bill.MaHD descending select bill.MaHD).FirstOrDefault();
var newbill = new HoaDon
{
MaHD = lastBillID + 1,
MaKH = cus.MaKH,
MaNV = Int32.Parse(txtEmployeeID.Text),
NgayMua = datBuy.Value,
HanBH = datWarranty.Value,
PTMuaHang = cbbBuyMethod.SelectedItem.ToString(),
PTThanhToan = cbbPayMethod.SelectedItem.ToString(),
Tongtien = 0
};
ctx.HoaDons.Add(newbill);
ctx.SaveChanges();
billID = lastBillID + 1;
}
}
private void Delete()
{
using (var ctx = new PhoneStoreManageEntities())
{
DialogResult answer = MessageBox.Show("Bạn chắc chắn muốn xóa khách hàng chứ?", "Cảnh báo!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (answer == DialogResult.Yes)
{
try
{
var cusID = Convert.ToInt32(txtID.Text);
var bill = (from b in ctx.HoaDons where b.MaKH == cusID select b).FirstOrDefault();
var warr = (from w in ctx.SuaChuas where w.MaNV == cusID select w).FirstOrDefault();
if (bill == null && warr == null)
{
var cus = (from c in ctx.KhachHangs where c.MaKH == cusID select c).FirstOrDefault();
ctx.KhachHangs.Remove(cus);
ctx.SaveChanges();
MessageBox.Show("Thao tác thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Không thể xóa khách hàng tồn tại trong hóa đơn", "Thông báo!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch
{
MessageBox.Show("Bạn chưa chọn khách hàng, hãy chọn khách hàng cần xóa trước khi thực hiện thao tác!", "Thống báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void FillInfor(DataGridViewCellEventArgs e)
{
if (e.RowIndex > -1)
{
dgvME.CurrentRow.Selected = true;
var MEID = Convert.ToInt32(dgvME.Rows[e.RowIndex].Cells[0].FormattedValue);
txtID.Text = MEID.ToString();
txtName.Text = dgvME.Rows[e.RowIndex].Cells[1].FormattedValue.ToString();
if (dgvME.Rows[e.RowIndex].Cells[2].FormattedValue.ToString() == "Nam")
{
radMale.Checked = true;
}
else
{
radFemale.Checked = true;
}
datBirth.Value = Convert.ToDateTime(dgvME.Rows[e.RowIndex].Cells[3].FormattedValue);
txtPhone.Text = dgvME.Rows[e.RowIndex].Cells[4].FormattedValue.ToString();
txtSalary.Text = dgvME.Rows[e.RowIndex].Cells[5].FormattedValue.ToString();
txtEmail.Text = dgvME.Rows[e.RowIndex].Cells[6].FormattedValue.ToString();
txtAdress.Text = dgvME.Rows[e.RowIndex].Cells[7].FormattedValue.ToString();
cbbPosition.SelectedItem = dgvME.Rows[e.RowIndex].Cells[8].FormattedValue.ToString();
cbbContract.SelectedItem = dgvME.Rows[e.RowIndex].Cells[9].FormattedValue.ToString();
datStart.Value = Convert.ToDateTime(dgvME.Rows[e.RowIndex].Cells[10].FormattedValue);
datEnd.Value = Convert.ToDateTime(dgvME.Rows[e.RowIndex].Cells[11].FormattedValue);
using (var ctx = new PhoneStoreManageEntities())
{
var acc = from ac in ctx.Accounts where ac.MaNV == MEID select ac;
txtUsername.Text = (from ac in acc select ac.Username).FirstOrDefault();
txtPassword.Text = (from ac in acc select ac.Password).FirstOrDefault();
}
}
}
private void LoadWarranty()
{
using (var ctx = new PhoneStoreManageEntities())
{
var query = from wa in ctx.SuaChuas
select new
{
wa.MaSC,
wa.MaHD,
wa.MaNV,
wa.NhanVien.TenNV,
wa.TenDienThoai,
wa.KhachHang.TenKH,
wa.NgayNhan,
wa.PhiSC,
wa.PTThanhToan,
wa.NoiDung
};
dgvWa.DataSource = query.ToList();
dgvWa.Columns[1].Visible = false;
dgvWa.Columns[5].Visible = false;
dgvWa.Columns[8].Visible = false;
dgvWa.Columns[9].Visible = false;
dgvWa.Columns[0].HeaderText = "Mã HD";
dgvWa.Columns[2].HeaderText = "Mã NV";
dgvWa.Columns[3].HeaderText = "Nhân viên";
dgvWa.Columns[4].HeaderText = "Điện thoại";
dgvWa.Columns[6].HeaderText = "Ngày nhận";
dgvWa.Columns[7].HeaderText = "Phí SC";
dgvWa.Refresh();
}
}
void CreateWarranty()
{
using (var ctx = new PhoneStoreManageEntities())
{
var cus = (from c in ctx.KhachHangs where c.SoDienThoai == txtWaPhoneNum.Text select c).FirstOrDefault();
cus.TenKH = txtWaCustomer.Text;
cus.GioiTinh = radWaMale.Checked ? "Nam" : "Nữ";
cus.NgaySinh = datWaBirth.Value;
cus.Email = txtWaEmail.Text;
cus.DiaChi = txtWaAdress.Text;
var lastWaID = (from wa in ctx.SuaChuas orderby wa.MaSC descending select wa.MaSC).FirstOrDefault();
try
{
if (billID != 0)
{
ctx.pro_CreateWarrantys(lastWaID + 1, txtWaPhoneName.Text, datWaReceive.Value, Int32.Parse(txtWaCharge.Text),
cbbWaPayMethod.SelectedItem.ToString(), txtWaNotices.Text, cusID, Int32.Parse(txtWaEmpID.Text), billID);
}
else
{
ctx.pro_CreateWarrantys(lastWaID + 1, txtWaPhoneName.Text, datWaReceive.Value, Int32.Parse(txtWaCharge.Text),
cbbWaPayMethod.SelectedItem.ToString(), txtWaNotices.Text, cusID, Int32.Parse(txtWaEmpID.Text), null);
}
MessageBox.Show("Thêm thành công!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch
{
MessageBox.Show("Thêm không thành công\n Hãy kiểm tra lại các trường thông tin!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
ctx.SaveChanges();
}
}
private void DeleteWaratary()
{
using (var ctx = new PhoneStoreManageEntities())
{
try
{
var wabillID = Convert.ToInt32(txtWaWaBillID.Text);
DialogResult answer = MessageBox.Show("Bạn chắc chắn muốn xóa hóa đơn chứ?", "Question?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (answer == DialogResult.Yes)
{
if (wabillID != 0)
{
var wabill = (from wb in ctx.SuaChuas where wb.MaSC == wabillID select wb).FirstOrDefault();
ctx.SuaChuas.Remove(wabill);
ctx.SaveChanges();
MessageBox.Show("Thao tác thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch
{
MessageBox.Show("Bạn chưa chọn điện thoại, hãy chọn điện thoại cần xóa trước khi thực hiện thao tác!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void LoadComboBox()
{
using (var ctx = new PhoneStoreManageEntities())
{
var pos = from p in ctx.ChucVus select p.TenCV;
cbbPosition.Items.AddRange(pos.ToArray());
}
}
public static int Permit(string username)
{
using (var ctx = new PhoneStoreManageEntities())
{
var per = (from a in ctx.Accounts where a.Username == username select a.NhanVien.ChucVu.MaCV).FirstOrDefault();
return(per);
}
}
private void LoadPrice()
{
using (var ctx = new PhoneStoreManageEntities())
{
var phone = (from p in ctx.DienThoais where p.MaMDT == phoneSampleID && p.Mau == cbbColor.SelectedItem.ToString() select p).FirstOrDefault();
txtEntryPrice.Text = phone.GiaNhap.ToString();
txtSalePrice.Text = phone.GiaBan.ToString();
txtNumber.Text = phone.SoLuong.ToString();
}
}
private void LoadEmployees()
{
using (var ctx = new PhoneStoreManageEntities())
{
var ems = from e in ctx.NhanViens
select new
{
e.MaNV,
e.TenNV,
e.GioiTinh,
e.NgaySinh,
e.SoDienThoai,
e.Luong,
e.Email,
e.DiaChi,
e.ChucVu.TenCV,
e.HopDong.TenLoaiHopDong,
e.HopDong.Ngaybatdau,
e.HopDong.Ngayketthuc
};
if (txtSearchEmp.Text != "")
{
var empID = Convert.ToInt32(txtSearchEmp.Text);
var result = from ne in ems where ne.MaNV == empID select ne;
dgvME.DataSource = result.ToList();
}
else
{
dgvME.DataSource = ems.ToList();
}
dgvME.Columns[2].Visible = false;
dgvME.Columns[3].Visible = false;
dgvME.Columns[4].Visible = false;
dgvME.Columns[6].Visible = false;
dgvME.Columns[7].Visible = false;
dgvME.Columns[10].Visible = false;
dgvME.Columns[11].Visible = false;
dgvME.Columns[0].HeaderText = "Mã NV";
dgvME.Columns[1].HeaderText = "Nhân viên";
dgvME.Columns[5].HeaderText = "Lương";
dgvME.Columns[8].HeaderText = "Chức vụ";
dgvME.Columns[9].HeaderText = "Hợp đồng";
dgvME.Columns[0].FillWeight = 100;
dgvME.Columns[1].FillWeight = 200;
dgvME.Columns[5].FillWeight = 100;
dgvME.Columns[8].FillWeight = 100;
dgvME.Columns[9].FillWeight = 100;
dgvME.Refresh();
}
}
private void LoadComboBox()
{
using (var ctx = new PhoneStoreManageEntities())
{
var brands = from b in ctx.HangDienThoais select b.TenHDT;
cbbBrand.Items.AddRange(brands.ToArray());
var colors = from c in ctx.DienThoais group c by c.Mau into sc select sc.Key;
cbbColors.Items.AddRange(colors.ToArray());
}
}
private void Business()
{
using (var ctx = new PhoneStoreManageEntities())
{
List <string> label = new List <string> {
"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"
};
double[] entrys = new double[12];
double[] sales = new double[12];
var dbills = from db in ctx.ChiTietHoadons select db;
foreach (var db in dbills)
{
var entry = Convert.ToDouble(db.DienThoai.GiaNhap) / 1000000;
var sale = Convert.ToDouble(db.DienThoai.GiaBan) / 1000000;
var date = db.HoaDon.NgayMua;
entrys[date.Value.Month - 1] += entry;
sales[date.Value.Month - 1] += sale;
}
cscChart.Series = new SeriesCollection
{
new LineSeries
{
Title = "Tổng thu",
Values = new ChartValues <double>()
},
new LineSeries
{
Title = "Tổng chi",
Values = new ChartValues <double>()
}
};
cscChart.Series[0].Values.AddRange(sales.Cast <object>());
cscChart.Series[1].Values.AddRange(entrys.Cast <object>());
cscChart.AxisX.Add(new Axis
{
Title = "Thời gian",
Labels = label,
MinValue = 0,
MaxValue = 11
});
cscChart.AxisY.Add(new Axis
{
Title = "Tổng tiền (triệu)",
LabelFormatter = value => value.ToString("N"),
});
cscChart.LegendLocation = LegendLocation.Right;
}
}
private void LoadComboBox()
{
using (var ctx = new PhoneStoreManageEntities())
{
cbbBrandFilter.Items.Clear();
cbbEditBrand.Items.Clear();
cbbColor.Items.Clear();
var brands = from b in ctx.HangDienThoais select b.TenHDT;
cbbBrandFilter.Items.AddRange(brands.ToArray());
cbbEditBrand.Items.AddRange(brands.ToArray());
}
}
void InitLoad()
{
DateTime time = DateTime.Now;
datWaReceive.Value = new DateTime(time.Year, time.Month, time.Day);
using (var ctx = new PhoneStoreManageEntities())
{
var emp = (from em in ctx.Accounts where em.Username == username select em).FirstOrDefault();
txtWaEmpID.Text = emp.MaNV.ToString();
txtWaEmpName.Text = emp.NhanVien.TenNV.ToString();
}
}
private void ModifyInfor()
{
using (var ctx = new PhoneStoreManageEntities())
{
var maNV = Int32.Parse(txtID.Text);
var query = (from q in ctx.NhanViens where q.MaNV == maNV select q).FirstOrDefault();
var acc = (from a in ctx.Accounts where a.Username == username select a).FirstOrDefault();
query.SoDienThoai = txtPhone.Text;
query.DiaChi = txtAdress.Text;
if (txtPass.Text == acc.Password)
{
if (pnlChangePass.Visible)
{
if (txtNewPass.Text.Length > 5)
{
if (txtNewPass.Text == txtReNewPass.Text)
{
acc.Password = txtNewPass.Text;
ctx.SaveChanges();
txtPass.Text = "";
btnSave.Enabled = false;
pnlChangePass.Visible = false;
MessageBox.Show("Thay đổi thông tin thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Mật khẩu không khớp!\nVui lòng kiểm tra lại", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Mật khẩu phải có ít nhất 6 kí tự\nVui lòng kiểm tra lại", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
ctx.SaveChanges();
txtPass.Text = "";
btnSave.Enabled = false;
pnlChangePass.Visible = false;
MessageBox.Show("Thay đổi thông tin thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Mật khẩu không đúng\nVui lòng kiểm tra lại!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
private void Modify()
{
using (var ctx = new PhoneStoreManageEntities())
{
if (addFlag)
{
try
{
var lastCusID = (from c in ctx.KhachHangs orderby c.MaKH descending select c.MaKH).FirstOrDefault();
var newCus = new KhachHang
{
MaKH = lastCusID + 1,
TenKH = txtName.Text,
NgaySinh = datBirth.Value,
GioiTinh = radMale.Checked ? "Nam" : "Nữ",
SoDienThoai = txtPhone.Text,
Email = txtEmail.Text,
DiaChi = txtAdress.Text
};
ctx.KhachHangs.Add(newCus);
MessageBox.Show("Thao tác thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch
{
MessageBox.Show("Thông tin nhập chưa đúng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
try
{
var cusID = Convert.ToInt32(txtID.Text);
var cus = (from c in ctx.KhachHangs where c.MaKH == cusID select c).FirstOrDefault();
cus.TenKH = txtName.Text;
cus.NgaySinh = datBirth.Value;
cus.GioiTinh = radMale.Checked ? "Nam" : "Nữ";
cus.SoDienThoai = txtPhone.Text;
cus.Email = txtEmail.Text;
cus.DiaChi = txtAdress.Text;
MessageBox.Show("Thao tác thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch
{
MessageBox.Show("Bạn chưa chọn khách hàng, hãy chọn khách hàng cần sửa trước khi thực hiện thao tác!", "Thống báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
ctx.SaveChanges();
}
}
private void DeleteBill()
{
using (var ctx = new PhoneStoreManageEntities())
{
DeleteDetailBill();
var bill = (from b in ctx.HoaDons where b.MaHD == billID select b).FirstOrDefault();
if (bill != null)
{
ctx.HoaDons.Remove(bill);
ctx.SaveChanges();
MessageBox.Show("Thao tác thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
void CheckedInfor(DataGridViewCellEventArgs e)
{
if (e.RowIndex > -1)
{
dgvWaPhoneBill.CurrentRow.Selected = true;
txtWaPhoneName.Text = dgvWaPhoneBill.Rows[e.RowIndex].Cells[0].FormattedValue.ToString();
using (var ctx = new PhoneStoreManageEntities())
{
cbbWaPayMethod.SelectedItem = (from b in ctx.HoaDons where b.MaHD == billID select b.PTThanhToan).FirstOrDefault();
}
}
}
private void LoadEmployee()
{
using (var ctx = new PhoneStoreManageEntities())
{
var employee = from emp in ctx.NhanViens
join acc in ctx.Accounts on emp.MaNV equals acc.MaNV
where acc.Username == username
select emp;
txtEmployeeID.Text = (from emp in employee select emp.MaNV).FirstOrDefault().ToString();
txtEmployeeName.Text = (from emp in employee select emp.TenNV).FirstOrDefault().ToString();
DateTime time = DateTime.Now;
datBuy.Value = new DateTime(time.Year, time.Month, time.Day);
datWarranty.Value = new DateTime(time.Year + 1, time.Month, time.Day);
}
}
private void Delete()
{
using (var ctx = new PhoneStoreManageEntities())
{
DialogResult answer = MessageBox.Show("Nhân viên, hợp đồng\nBạn chắc chắn chứ?", "Cảnh báo!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (answer == DialogResult.Yes)
{
try
{
if (username != "Admin")
{
var empID = Convert.ToInt32(txtID.Text);
var bill = (from b in ctx.HoaDons where b.MaNV == empID select b).FirstOrDefault();
var warr = (from w in ctx.SuaChuas where w.MaNV == empID select w).FirstOrDefault();
if (bill == null && warr == null)
{
var acc = (from ac in ctx.Accounts where ac.MaNV == empID select ac).FirstOrDefault();
var emp = (from cu in ctx.NhanViens where cu.MaNV == empID select cu).FirstOrDefault();
var con = (from co in ctx.HopDongs where co.MaHopDong == emp.MaHopDong select co).FirstOrDefault();
if (acc != null)
{
ctx.Accounts.Remove(acc);
}
ctx.HopDongs.Remove(con);
ctx.NhanViens.Remove(emp);
ctx.SaveChanges();
MessageBox.Show("Thao tác thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Không thể xóa nhân viên tồn tại trong hóa đơn", "Thông báo!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Không thể xóa nhân viên quản trị!", "Thông báo!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch
{
MessageBox.Show("Bạn chưa chọn nhân viên, hãy chọn nhân viên cần xóa trước khi thực hiện thao tác!", "Thống báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
void LoadComboBox()
{
using (var ctx = new PhoneStoreManageEntities())
{
var brands = from b in ctx.HangDienThoais select b.TenHDT;
foreach (var brand in brands)
{
cbbBrand.Items.Add(brand);
}
var colors = from c in ctx.DienThoais group c by c.Mau into sc select sc.Key;
foreach (var color in colors)
{
cbbColors.Items.Add(color);
}
}
}
private void LoadcbbColor()
{
using (var ctx = new PhoneStoreManageEntities())
{
cbbColor.Items.Clear();
cbbColor.Text = "";
txtNumber.Text = "";
txtEntryPrice.Text = "";
txtSalePrice.Text = "";
try
{
var colors = from c in ctx.DienThoais where c.MaMDT == phoneSampleID group c by c.Mau into sc select sc.Key;
cbbColor.Items.AddRange(colors.ToArray());
cbbColor.SelectedIndex = 0;
}
catch { }
}
}
void CheckLogin()
{
using (var ctx = new PhoneStoreManageEntities())
{
var user = (from acc in ctx.Accounts where acc.Username == txtUsername.Text select acc.Username).FirstOrDefault();
var pass = (from acc in ctx.Accounts where acc.Username == user select acc.Password).FirstOrDefault();
if (String.Compare(user, txtUsername.Text, true) == 0 && String.Compare(pass, txtPassword.Text, false) == 0)
{
Home home = new Home(user);
home.Show();
}
else
{
MessageBox.Show("Username or password is incorrect\nPlease try again!", "Warning!",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
void LoadCustomers()
{
using (var ctx = new PhoneStoreManageEntities())
{
var customer = from c in ctx.KhachHangs where c.SoDienThoai == txtPhoneNum.Text select c;
try
{
txtCustomer.Text = (from c in customer select c.TenKH).FirstOrDefault().ToString();
datBirth.Value = (from c in customer select c.NgaySinh).FirstOrDefault().Value;
txtEmail.Text = (from c in customer select c.Email).FirstOrDefault().ToString();
txtAdress.Text = (from c in customer select c.DiaChi).FirstOrDefault().ToString();
if ((from c in customer select c.GioiTinh).FirstOrDefault().ToString() == "Nam")
{
radMale.Checked = true;
}
else
{
radFemale.Checked = true;
}
}
catch
{
txtCustomer.Text = "";
datBirth.Value = new DateTime(2000, 1, 1);
txtEmail.Text = "";
txtAdress.Text = "";
radMale.Checked = false;
radFemale.Checked = false;
DialogResult answer = MessageBox.Show("Không tìn thấy khách hàng. Bạn có muốn tạo mới không?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (answer == DialogResult.Yes)
{
var lastCusID = (from cus in ctx.KhachHangs orderby cus.MaKH descending select cus.MaKH).FirstOrDefault();
//var lastID = (from hd in ctx.HoaDons orderby hd.MaHD descending select hd.MaHD).FirstOrDefault();
var newCus = new KhachHang {
MaKH = lastCusID + 1, SoDienThoai = txtPhoneNum.Text
};
ctx.KhachHangs.Add(newCus);
ctx.SaveChanges();
}
}
}
}
private void LoadCustomers()
{
using (var ctx = new PhoneStoreManageEntities())
{
var customer = from c in ctx.KhachHangs where c.SoDienThoai == txtSearchCus.Text select c;
try
{
txtCustomer.Text = (from c in customer select c.TenKH).FirstOrDefault().ToString();
datBirth.Value = (from c in customer select c.NgaySinh).FirstOrDefault().Value;
txtEmail.Text = (from c in customer select c.Email).FirstOrDefault().ToString();
txtAdress.Text = (from c in customer select c.DiaChi).FirstOrDefault().ToString();
if ((from c in customer select c.GioiTinh).FirstOrDefault().ToString() == "Nam")
{
radMale.Checked = true;
}
else
{
radFemale.Checked = true;
}
btnSelect.Enabled = true;
}
catch
{
ClearControls();
DialogResult answer = MessageBox.Show("Không tìn thấy khách hàng. Bạn có muốn tạo mới không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (answer == DialogResult.Yes)
{
var lastCusID = (from cus in ctx.KhachHangs orderby cus.MaKH descending select cus.MaKH).FirstOrDefault();
var newCus = new KhachHang {
MaKH = lastCusID + 1, SoDienThoai = txtSearchCus.Text
};
ctx.KhachHangs.Add(newCus);
ctx.SaveChanges();
btnSelect.Enabled = true;
}
else
{
btnSelect.Enabled = false;
}
}
}
}
private void Bills()
{
using (var ctx = new PhoneStoreManageEntities())
{
List <string> label = new List <string> {
"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"
};
int[] values = new int[12];
var dbills = from db in ctx.ChiTietHoadons select db;
foreach (var db in dbills)
{
var date = db.HoaDon.NgayMua;
values[date.Value.Month - 1]++;
}
cscChart.Series = new SeriesCollection
{
new LineSeries
{
Title = "Điện thoại",
Values = new ChartValues <int>()
}
};
cscChart.Series[0].Values.AddRange(values.Cast <object>());
cscChart.AxisX.Add(new Axis
{
Title = "Thời gian",
Labels = label,
MinValue = 0,
MaxValue = 11
});
cscChart.AxisY.Add(new Axis
{
Title = "Số lượng",
LabelFormatter = value => value.ToString("N")
});
cscChart.LegendLocation = LegendLocation.Right;
}
}
