private void ButtonThem_Click(object sender, EventArgs e)
{
if (medicine == null)
{
medicine = new Medicine();
control = new CategoryListBoxControl(medicine);
}
medicine.Name_Medicine = TextBoxTenSanPham.Text;
medicine.Source = TextBoxXuatXu.Text;
medicine.Packing = TextBoxDongGoi.Text;
medicine.Unit = TextBoxSoLuongTrongMoiGoi.Text;
try
{
medicine.Cost = Decimal.Parse(TextBoxGiaThanh.Text);
}
catch (Exception ex)
{
MessageBox.Show("Nhap sai thành tiền sản phẩm", null, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
medicine.Registration_Number = TextBoxMaDangKi.Text;
medicine.ID_Category = new List <int?> {
(ComboBoxLoaiHang.SelectedItem as ComboBoxItem).Value
};
using (SqlConnection sqlConnection = new SqlConnection(Form1.connect))
{
sqlConnection.Open();
string query = "exec InsertMedicine @name,@source,@packing,@unit,@cost,@registationNumber,@idCategory";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlCommand.Parameters.AddRange(new SqlParameter[] { new SqlParameter("name", medicine.Name_Medicine)
, new SqlParameter("source", medicine.Source)
, new SqlParameter("packing", medicine.Packing), new SqlParameter("unit", medicine.Unit)
, new SqlParameter("cost", medicine.Cost)
, new SqlParameter("registationNumber", medicine.Registration_Number)
, new SqlParameter("idCategory", medicine.ID_Category[0]) });
sqlCommand.ExecuteScalar();
}
this.Close();
boolClass.isChanged = true;
}
public ChangeInformationMedicine(Medicine medicine, BoolClass check)
{
InitializeComponent();
control = new CategoryListBoxControl(medicine);
control.SetBounds(200, 10, control.Width, control.Height);
this.Controls.Add(control);
control.BringToFront();
TextBoxMaSanPham.Text = medicine.ID_Medicine.ToString();
TextBoxMaSanPham.ReadOnly = true;
TextBoxTenSanPham.Text = medicine.Name_Medicine;
//TextBoxNgayHetHan.Text = medicine.Expiry_Date.Value.Day.ToString();
//TextBoxNamHetHan.Text = medicine.Expiry_Date.Value.Year.ToString();
//TextBoxThangHetHan.Text = medicine.Expiry_Date.Value.Month.ToString();
TextBoxSoLuongCon.Text = medicine.Remain_Amount.ToString();
TextBoxXuatXu.Text = medicine.Source;
//TextBoxNgaySanXuat.Text = medicine.Date_Of_Manufacture.Value.Day.ToString();
//TextBoxThangSanXuat.Text = medicine.Date_Of_Manufacture.Value.Month.ToString();
//TextBoxNamSanXuat.Text = medicine.Date_Of_Manufacture.Value.Year.ToString();
//TextBoxNgayNhap.Text = medicine.Import_Date.Value.Day.ToString();
//TextBoxThangNhap.Text = medicine.Import_Date.Value.Month.ToString();
//TextBoxNamNhap.Text = medicine.Import_Date.Value.Year.ToString();
TextBoxDongGoi.Text = medicine.Packing;
TextBoxSoLuongTrongMoiGoi.Text = medicine.Unit;
TextBoxGiaThanh.Text = medicine.Cost.ToString();
TextBoxMaDangKi.Text = medicine.Registration_Number.ToString();
this.medicine = medicine;
this.Check = check;
int i = 1;
foreach (var item in MedicineHelper.GetImportHistory(medicine.ID_Medicine))
{
ListViewItem listViewItem = new ListViewItem(new string[] { i.ToString(), item.Import_Date.ToString(),
item.Date_Of_Manufacture.ToShortDateString(),
item.Expiry_Date.ToShortDateString(),
item.ID_Import.ToString() });
ListImport.Items.Add(listViewItem);
i++;
}
}
