public ErrType Them1PhieuThu(PhieuThu phieu)
{
using (Connection db = new Connection())
{
using (var transaction = db.Database.BeginTransaction())
{
int thanhTien = 0;
Console.WriteLine("so luong nguyen lieu ban: ");
int n = int.Parse(Console.ReadLine());
for (int i = 0; i < n; i++)
{
ChiTietPhieuThu ct = new ChiTietPhieuThu();
ct.PhieuThuID = phieu.PhieuThuID;
ct.NguyeLieuID = InputHelper.NhapInt("nhap ma nguyen lieu: ", "err");
ct.SoLuongBan = InputHelper.NhapInt("nhap so luong cua nguyen lieu duoc ban: ", "err");
db.ChiTietPhieuThus.Add(ct);
NguyenLieu a = db.NguyenLieus.Find(ct.NguyeLieuID);
thanhTien += ct.SoLuongBan * a.GiaBan;
a.SoLuongKho -= ct.SoLuongBan;
db.SaveChanges();
}
phieu.ThanhTien = thanhTien;
db.PhieuThus.Add(phieu);
db.SaveChanges();
transaction.Commit();
return(ErrType.Succes);
}
}
}
private void btnSua_Click(object sender, EventArgs e)
{
try
{
NguyenLieu nv = db.NguyenLieux.Find(int.Parse(txtMaNL.Text));
nv.TenNL = txtTenNL.Text;
nv.GiaTien = int.Parse(txtGiaTien.Text);
nv.SoLuong = float.Parse(txtSoLuong.Text);
SqlParameter[] idparam =
{
new SqlParameter {
ParameterName = "MaNL", Value = int.Parse(txtMaNL.Text)
},
new SqlParameter {
ParameterName = "TenNL", Value = txtTenNL.Text
},
new SqlParameter {
ParameterName = "GiaTien", Value = int.Parse(txtGiaTien.Text)
},
new SqlParameter {
ParameterName = "SoLuong", Value = float.Parse(txtSoLuong.Text)
},
};
db.Database.ExecuteSqlCommand("suanl @manl , @tennl , @giatien , @soluong ", idparam);
db.SaveChanges();
MessageBox.Show("Sua thanh cong");
show();
}
catch (Exception ex)
{
MessageBox.Show("" + ex.Message);
}
}
private void Xoa()
{
try
{
vitri = (NguyenLieu)gridViewNguyenLieu.GetFocusedRow();
if (vitri == null)
{
return;
}
else if (db.ChangeTracker.HasChanges())
{
XtraMessageBox.Show("Bạn phải lưu dữ liệu vừa thêm/sửa trước khi xoá!", "Xoá", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if ((XtraMessageBox.Show("Bạn có muốn xoá dữ liệu " + NguyenLieu.TableName + " này không?", "Xoá", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes))
{
db.NguyenLieux.Remove(vitri);
db.SaveChanges();
XtraMessageBox.Show("Đã xoá thành công!", "Xoá", MessageBoxButtons.OK, MessageBoxIcon.Information);
NapDuLieu();
}
else
{
XtraMessageBox.Show("Chưa xoá được!", "Xoá", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Không xoá được!" + Environment.NewLine + "Lỗi: " + ex.ToString(), "Xoá", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void hienThiThongTin(NguyenLieu nguyenLieu)
{
txtMaNguyenLieu.Text = nguyenLieu.maNguyenLieu;
txtTenNguyenLieu.Text = nguyenLieu.tenNguyenLieu;
cmbLoaiNguyenLieu.SelectedItem = nguyenLieu.LoaiNguyenLieu.tenLoaiNguyenLieu;
txtMaLoai.Text = nguyenLieu.LoaiNguyenLieu.maLoaiNguyenLieu;
}
public string xulyMaNguyenLieu()
{
string rs = "";
int count = db.NguyenLieus.Count();
if (count == 0)
{
rs = "NL_1";
}
else
{
string flag = "";
int songuyenlieu = 1;
do
{
rs = "NL_" + (songuyenlieu++);
NguyenLieu tnl = db.NguyenLieus.Where(a => a.MaNguyenLieu == rs).FirstOrDefault();
if (tnl == null)
{
break;
}
else
{
flag = tnl.MaNguyenLieu;
}
} while (flag == rs);
}
return(rs);
}
private void btnLuu_Click(object sender, RoutedEventArgs e)
{
try
{
//string maLoaiNguyenLieu = CLoaiNguyenLieu_BUS.findMaLoaibyTenLoai(cmbLoaiNguyenLieu.SelectedItem.ToString());
NguyenLieu nguyenLieu = new NguyenLieu();
nguyenLieu.maNguyenLieu = txtMaNguyenLieu.Text;
nguyenLieu.tenNguyenLieu = txtTenNguyenLieu.Text;
nguyenLieu.maLoaiNguyenLieu = txtMaLoai.Text;
nguyenLieu.trangThai = 0;
if (CNguyenLieu_BUS.edit(nguyenLieu))
{
MessageBox.Show("Sửa thành công");
this.Close();
}
}
catch (ArgumentNullException)
{
MessageBox.Show("Lỗi! Để dữ liệu rỗng");
}
catch (FormatException)
{
MessageBox.Show("Lỗi! Không đúng kiểu dữ liệu, Đơn giá và số lượng phải là số");
}
catch (OverflowException)
{
MessageBox.Show("Lỗi! Đơn giá hoặc số lượng có độ dài quá giới hạn cho phép");
}
}
public frmThongTinNguyenLieu(NguyenLieu nguyenLieu = null, int flag = 1)
{
InitializeComponent();
hienThi();
// khi người dùng nhấn thêm thì ấn nút sửa đi
if (flag == 1)
{
txtMaNguyenLieu.Text = CServices.taoMa <NguyenLieu>(CNguyenLieu_BUS.toList());
btnSua.IsEnabled = false;
btnLuu.IsEnabled = false;
}
// khi người dùng nhấn nút sửa
else if (flag == 2)
{
btnThem.IsEnabled = false;
btnSua.IsEnabled = false;
}
// là khi người dùng bấm nút xem chi tiết
else
{
btnThem.IsEnabled = false;
btnLuu.IsEnabled = false;
isEnabledThongTin(false);
}
if (nguyenLieu != null)
{
NguyenLieuSelect = nguyenLieu;
hienThiThongTin(NguyenLieuSelect);
}
}
public ActionResult Recipe_add(CongThuc ct, string LoaiCongThuc, string[] NL, string[] SL, string[] NoiDung)
{
NguoiDung nd = (NguoiDung)Session["NguoiDung"];
var lct = db.LoaiCongThucs.FirstOrDefault(x => x.TenLoaiCT == LoaiCongThuc);
ct.Video.Trim();
ct.MaLoaiCongThuc = lct.MaLoaiCongThuc;
ct.MaNguoiTao = nd.UserID;
ct.NgayTao = DateTime.Now;
db.CongThucs.Add(ct);
db.SaveChanges();
for (int i = 0; i < NL.Count(); i++)
{
if (NL[i] != null)
{
NguyenLieu nl = new NguyenLieu();
nl.MaCongThuc = db.CongThucs.FirstOrDefault(x => x.TenCongThuc == ct.TenCongThuc).ID_congthuc;
nl.TenNguyenLieu = NL[i];
nl.SoLuong = SL[i];
db.NguyenLieux.Add(nl);
}
}
for (int i = 0; i < NoiDung.Count(); i++)
{
if (NoiDung[i] != null)
{
NoiDungCT ndct = new NoiDungCT();
ndct.MaCongThuc = db.CongThucs.FirstOrDefault(x => x.TenCongThuc == ct.TenCongThuc).ID_congthuc;
ndct.NoiDung = NoiDung[i];
db.NoiDungCTs.Add(ndct);
}
}
db.SaveChanges();
return(RedirectToAction("Recipe"));
}
public void Delete()
{
DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete it?", "Delete Value", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
string maNL = this.textEditMaNL.Text;
NguyenLieu nl = new NguyenLieu();
nl.MaNguyenLieu = maNL;
int res = Bus.DeleteNguyenLieu(nl);
if (res == 1)
{
MessageBox.Show("Xóa thành công");
LoadData();
}
else
{
MessageBox.Show("Xóa không thành công");
}
}
else
{
}
this.panelNguyenLieu.Enabled = false;
}
public void Save()
{
try {
string maNL, donVi, tenNL;
int donGia;
maNL = this.textEditMaNL.Text;
tenNL = this.textEditTenNL.Text;
donVi = this.textEditDonVi.Text;
donGia = int.Parse(this.textEditDonGia.Text);
NguyenLieu nl = new NguyenLieu(maNL, tenNL, donVi, donGia);
if (this.currentAction == "Add")
{
int res = Bus.InsertNguyenLieu(nl);
if (res == 1)
{
LoadData();
MessageBox.Show("Đã thêm mới thành công");
}
}
if (this.currentAction == "Edit")
{
int res = Bus.UpdateNguyenLieu(nl);
if (res == 1)
{
LoadData();
MessageBox.Show("Đã sửa thành công");
}
}
this.panelNguyenLieu.Enabled = false;
}
catch (Exception e) {
MessageBox.Show(e.Message);
}
}
public NguyenLieu timNLtheoTen(string tennl)
{
DataTable table = DataProvider.Instance.executeQuery("select * from nguyenlieu where tennl = N'" + tennl + "'");
NguyenLieu nl = new NguyenLieu(table.Rows[0]);
return(nl);
}
private void insertCL()
{
QLBanMonAnClassesDataContext db = new QLBanMonAnClassesDataContext();
if (txtMaNguyenLieu.Text == "")
{
MessageBox.Show("Mời nhập Mã chất liệu!");
txtMaNguyenLieu.Focus();
return;
}
else
{
NguyenLieu cl1 = db.NguyenLieus.Where(p => p.MaNguyenLieu == txtMaNguyenLieu.Text).SingleOrDefault();
if (cl1 != null)
{
MessageBox.Show("Mã Chất liệu này đã có ! Bạn phải nhập mã khác !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtMaNguyenLieu.Focus();
return;
}
}
if (txtTenNguyenLieu.Text == "")
{
MessageBox.Show("Mời nhập Tên chất liệu!");
txtTenNguyenLieu.Focus();
return;
}
NguyenLieu cl = new NguyenLieu();
cl.MaNguyenLieu = txtMaNguyenLieu.Text;
cl.TenNguyenLieu = txtTenNguyenLieu.Text;
db.NguyenLieus.InsertOnSubmit(cl);
db.SubmitChanges();
}
public NguyenLieu timNLTheoMa(string manl)
{
DataTable table = DataProvider.Instance.executeQuery("select * from nguyenlieu where manl = '" + manl + "'");
NguyenLieu nl = new NguyenLieu(table.Rows[0]);
return(nl);
}
public static bool edit(NguyenLieu nguyenLieu)
{
NguyenLieu temp = find(nguyenLieu.maNguyenLieu);
if (temp == null || !CServices.kiemTraThongTin(nguyenLieu))
{
return(false);
}
try
{
temp.maNguyenLieu = nguyenLieu.maNguyenLieu;
temp.tenNguyenLieu = CServices.formatChuoi(nguyenLieu.tenNguyenLieu);
temp.maLoaiNguyenLieu = nguyenLieu.maLoaiNguyenLieu;
temp.trangThai = nguyenLieu.trangThai;
quanLyQuanCoffee.SaveChanges();
}
catch (DbUpdateException)
{
MessageBox.Show("Lỗi! không thể sửa thông tin nguyên liệu");
return(false);
}
return(true);
}
public frmThongTinChiTietNguyenLieu(NguyenLieu nguyenLieu = null)
{
InitializeComponent();
//List<ChiTietPhieuNhap> list = CChiTietPhieuNhapNguyenLieu_BUS.findList(nguyenLieu.maNguyenLieu);
List <ChiTietNguyenLieu> chiTietNguyenLieus = new List <ChiTietNguyenLieu>();
if (nguyenLieu != null)
{
chiTietNguyenLieus = nguyenLieu.ChiTietNguyenLieux.ToList();
}
//foreach (ChiTietNguyenLieu chiTietNguyenLieu in chiTietNguyenLieus)
//{
// chiTietNguyenLieu.ChiTietPhieuNhaps.ToList();
//}
txtMaNguyenLieu.Text = nguyenLieu.maNguyenLieu;
txtTenNguyenLieu.Text = nguyenLieu.tenNguyenLieu;
txtTenLoai.Text = nguyenLieu.LoaiNguyenLieu.tenLoaiNguyenLieu;
if (chiTietNguyenLieus.Count() > 0)
{
hienThi(chiTietNguyenLieus);
}
}
public async Task <ActionResult <NguyenLieu> > PostNguyenLieu(NguyenLieu nguyenLieu)
{
_context.NguyenLieus.Add(nguyenLieu);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetNguyenLieu", new { id = nguyenLieu.Id }, nguyenLieu));
}
public async Task <IActionResult> PutNguyenLieu(int id, NguyenLieu nguyenLieu)
{
if (id != nguyenLieu.Id)
{
return(BadRequest());
}
_context.Entry(nguyenLieu).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!NguyenLieuExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public static void ThemNguyenLieu(NguyenLieu nguyenLieu)
{
try
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("ThemNguyenLieu");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaNL", nguyenLieu.MaNguyenLieu);
cmd.Parameters.AddWithValue("@TenNL", nguyenLieu.TenNguyenLieu);
cmd.Parameters.AddWithValue("@MaLoaiNL", nguyenLieu.MaLoai);
cmd.Parameters.AddWithValue("@NangLuong", nguyenLieu.NangLuong);
cmd.Parameters.AddWithValue("@DonViTinh", nguyenLieu.DonViTinh);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
}
catch (Exception e)
{
MessageBox.Show("Phát sinh lỗi khi lưu nguyên liệu, vui lòng kiểm tra nguyên liệu và thử lại", "Thông báo", MessageBoxButtons.OK);
}
}
private void CapNhatDinhLuong()
{
nguyenLieu = (NguyenLieu)gridViewNguyenLieu.GetFocusedRow();
//kiểm tra xem món hiện tại có danh sách định lượng hay chưa
var dl = listDinhLuongs.Where(s => s.IdMon == mon.IdMon).FirstOrDefault();
if (dl == null)
{//nếu chưa thì thêm mới
listDinhLuongs.Add(new DinhLuong {
IdMon = mon.IdMon, IdNguyenLieu = nguyenLieu.IdNguyenLieu, SoLuongNguyenLieu = 1
});
}
else
{ //nếu có rồi thì kiểm tra nguyên liệu được chọn có trong danh sách định lượng hay chưa
var nl = listDinhLuongs.Where(s => s.IdMon == mon.IdMon && s.IdNguyenLieu == nguyenLieu.IdNguyenLieu).FirstOrDefault();
if (nl == null) //nếu chưa có thì thêm mới
{
listDinhLuongs.Add(new DinhLuong {
IdMon = mon.IdMon, IdNguyenLieu = nguyenLieu.IdNguyenLieu, SoLuongNguyenLieu = 1
});
}
else
{
nl.SoLuongNguyenLieu += 1;
}
}
gridViewDinhLuong.RefreshData();
}
public ErrType LayDSPhieuThu()
{
using (Connection db = new Connection())
{
var dsphieu = db.PhieuThus.OrderBy(x => x.NgayLap).ToList();
if (dsphieu.Count() != 0)
{
dsphieu.ForEach(x => {
x.Hien();
List <NguyenLieu> LST = new List <NguyenLieu>();
var chitiet = db.ChiTietPhieuThus.Where(y => y.PhieuThuID == x.PhieuThuID).ToList();
chitiet.ForEach(y => {
NguyenLieu a = db.NguyenLieus.Find(y.NguyeLieuID);
LST.Add(a);
});
LST.ForEach(y => y.Hien());
});
return(ErrType.Succes);
}
else
{
return(ErrType.Empty);
}
}
}
internal static int DeleteNguyenLieu(NguyenLieu nguyenLieu)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@MaNL", nguyenLieu.MaNguyenLieu)
};
return(DataProvider.ExecuteNonQuery(config.PROC_DELETE_NGUYEN_LIEU, para));
}
public ActionResult DeleteConfirmed(int id)
{
NguyenLieu nguyenLieu = db.NguyenLieux.Find(id);
db.NguyenLieux.Remove(nguyenLieu);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public string getDVTinh(string tenNL)
{
db = new QLCafeDataContext();
NguyenLieu lst = new NguyenLieu();
lst = db.NguyenLieus.Where(o => o.tenNL == tenNL).FirstOrDefault();
return(lst.dvtinh);
}
public bool XoaNL(NguyenLieu nl)
{
string[] param = { "@MaNL" };
object[] values = { nl.MaNL };
string query = "Delete from tblNguyenLieu where MaNL=@MaNL";
return(db.ExecuteNonQueryPara(query, param, values));
}
private void dgDSNguyenLieu_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (dgDSNguyenLieu.SelectedItem != null)
{
nguyenLieuSelect = new NguyenLieu();
nguyenLieuSelect = CNguyenLieu_BUS.find(dgDSNguyenLieu.SelectedValue.ToString());
}
}
public bool SuaNL(NguyenLieu nl)
{
string[] param = { "@MaNL", "@TenNL", "@DonGia", "@DonViTinh", "@SoLuongCon" };
object[] values = { nl.MaNL, nl.TenNL, nl.DonGia, nl.DonViTinh, nl.SoLuongCon };
string query = "Update tblNguyenLieu set TenNL=@TenNL,DonGia=@DonGia,DonViTinh=@DonViTinh,SoLuongCon=@SoLuongCon where MaNL=@MaNL";
return(db.ExecuteNonQueryPara(query, param, values));
}
public bool ThemNL(NguyenLieu nl)
{
string[] param = { "@MaNL", "@TenNL", "@DonGia", "@DonViTinh", "@SoLuongCon" };
object[] values = { nl.MaNL, nl.TenNL, nl.DonGia, nl.DonViTinh, nl.SoLuongCon };
string query = "Insert into tblNguyenLieu(MaNL,TenNL,DonGia,DonViTinh,SoLuongCon) values(@MaNL,@TenNL,@DonGia,@DonViTinh,@SoLuongCon)";
return(db.ExecuteNonQueryPara(query, param, values));
}
private void DeleteCL()
{
QLBanMonAnClassesDataContext db = new QLBanMonAnClassesDataContext();
NguyenLieu cl = db.NguyenLieus.Where(p => p.MaNguyenLieu == txtMaNguyenLieu.Text).SingleOrDefault();
db.NguyenLieus.DeleteOnSubmit(cl);
db.SubmitChanges();
}
private void EditNguyenLieu()
{
QLBanMonAnClassesDataContext db = new QLBanMonAnClassesDataContext();
NguyenLieu cl = db.NguyenLieus.Where(p => p.MaNguyenLieu == txtMaNguyenLieu.Text).SingleOrDefault();
cl.TenNguyenLieu = txtTenNguyenLieu.Text;
db.SubmitChanges();
LoadDTGV_Chat_Lieu();
}
private void btn_capNhat_Click(object sender, EventArgs e)
{
NguyenLieu nguyenLieu = new NguyenLieu();
nguyenLieu.TenNguyenLieu = txtTenNguyenLieu.Text;
nguyenLieu.MaNguyenLieu = grid_NguyenLieu.CurrentRow.Cells[0].Value.ToString();
bus_NguyenLieu.CapNhat(nguyenLieu);
grid_NguyenLieu.DataSource = bus_NguyenLieu.layNguyenLieu();
}
