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