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(); }