private void btnDongY_Click(object sender, EventArgs e) { String message = string.Empty; if (string.IsNullOrEmpty(TxtTenNguyenLieu.Text.Trim())) message += "Tên nguyên liệu không được bỏ trống.\n"; if (cbxDonViTinh.SelectedItem == null) message += "Đơn vị tính không được bỏ trống.\n"; if (!string.IsNullOrEmpty(message)) { MessageDialogHelper.CreateErrorMessage(message); return; } MaterialData materialData = new MaterialData(); materialData.MaterialName = TxtTenNguyenLieu.Text.Trim(); materialData.Price = (decimal)dipDonGia.Value; materialData.Unit = cbxDonViTinh.SelectedItem as UnitData; materialBll.MaterialToSave = materialData; if (materialBll.AddMaterial()) { if (MessageDialogHelper.CreateInformationMessage("Lưu thành công.") == DialogResult.OK) this.Close(); } }
public int UpdateInventory(MaterialData material) { Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>(); sqlStoredProcedureParams.Add("maNguyenLieu", material.MaterialId); sqlStoredProcedureParams.Add("thoiGian", DateTime.Now); sqlStoredProcedureParams.Add("soLuongThucTe", material.Quantity); return provider.ExecuteNonQuery("XUATNHAPNGUYENLIEU_proc_hieuchinh", sqlStoredProcedureParams); }
public int ImportMaterial(MaterialData material) { Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>(); sqlStoredProcedureParams.Add("maNguyenLieu", material.MaterialId); sqlStoredProcedureParams.Add("thoiGian", DateTime.Now); sqlStoredProcedureParams.Add("soLuong", material.Quantity); sqlStoredProcedureParams.Add("giaHienTai", material.Price); return provider.ExecuteNonQuery("XUATNHAPNGUYENLIEU_proc_nhap", sqlStoredProcedureParams); }
public int UpdateMaterial(MaterialData material) { Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>(); sqlStoredProcedureParams.Add("MaNguyenLieu", material.MaterialId); sqlStoredProcedureParams.Add("TenNguyenLieu", material.MaterialName); sqlStoredProcedureParams.Add("MaDonVi", material.Unit.UnitId); sqlStoredProcedureParams.Add("giaNhap", material.Price); sqlStoredProcedureParams.Add("SoLuong", material.Quantity); return provider.ExecuteNonQuery("NGUYENLIEU_proc_update", sqlStoredProcedureParams); }
public List<MaterialData> GetAllMaterial() { List<MaterialData> listMaterial = new List<MaterialData>(); DataTable dt = provider.ExecuteReader("NGUYENLIEU_proc_load"); foreach (DataRow row in dt.Rows) { MaterialData material = new MaterialData(); material.MaterialId = row["MaNguyenLieu"].ToString(); material.MaterialName = row["TenNguyenLieu"].ToString(); material.Price = Decimal.Parse(row["GiaNhap"].ToString()); material.Quantity = int.Parse(row["SoLuong"].ToString()); material.Unit = new UnitData { UnitId = row["MaDonVi"].ToString(), UnitName = row["TenDonVi"].ToString() }; listMaterial.Add(material); } listMaterial.Sort(((x, y) => String.Compare(x.MaterialId, y.MaterialId))); return listMaterial; }
public int DeleteMaterial(MaterialData material) { Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>(); sqlStoredProcedureParams.Add("maNguyenLieu", material.MaterialId); return provider.ExecuteNonQuery("NGUYENLIEU_proc_delete", sqlStoredProcedureParams); }