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