public void Init()
{
foreach (ColumnHeader column in ListShow.Columns)
{
column.Width = -2;
}
ListShow.Items.Clear();
List <Medicine> medicines = MedicineHelper.GetMedicines();
int i = 0;
foreach (var item in medicines)
{
i++;
ListViewItem listViewItem = new ListViewItem(new string[] { i.ToString(), item.ID_Medicine.ToString(),
item.Name_Medicine,
item.Remain_Amount.ToString(),
item.Min_Expiry.Value.ToShortDateString() + " - " + item.Max_Expiry.Value.ToShortDateString() });
ListShow.Items.Add(listViewItem);
}
ContextMenuStrip contextMenuStripListShow = new ContextMenuStrip();
ToolStripMenuItem itemXoa = new ToolStripMenuItem();
itemXoa.Name = "XoaSanPham";
itemXoa.Text = "Xóa Sản Phẩm";
itemXoa.Click += ItemXoa_Click;
contextMenuStripListShow.Items.Add(itemXoa);
ListShow.ContextMenuStrip = contextMenuStripListShow;
InitComboBoxCategory(ComboBoxChonLoai);
}
public CategoryListBoxControl(Medicine medicine)
{
InitializeComponent();
List <Category> categories = MedicineHelper.GetCategoryOfTheMedicine(medicine.ID_Medicine);
foreach (var item in categories)
{
if (item != null)
{
checkListBox.Items.Add(item.NameCategory, CheckState.Checked);
}
}
foreach (var item in MedicineHelper.GetAllCategory())
{
int check = 1;
if (item != null)
{
foreach (var x in categories)
{
if (x.CategoryID.CompareTo(item.CategoryID) == 0)
{
check = 0;
break;
}
}
if (check == 1)
{
checkListBox.Items.Add(item.NameCategory, CheckState.Unchecked);
}
}
}
}
//0, 2
private void button1_Click(object sender, EventArgs e)
{
GUI_Admin.listIsShow = true;
panelDanhSachNhanVien.Visible = false;
PanelSanPham.Visible = true;
PanelSanPham.BringToFront();
ListShow.Items.Clear();
List <Medicine> medicines = MedicineHelper.GetMedicines();
int i = 0;
foreach (var item in medicines)
{
ListViewItem listViewItem = new ListViewItem(new string[] { i.ToString(), item.ID_Medicine.ToString(),
item.Name_Medicine,
item.Remain_Amount.ToString(),
item.Expiry_Date.ToString() });
ListShow.Items.Add(listViewItem);
i++;
}
ContextMenuStrip contextMenuStripListShow = new ContextMenuStrip();
ToolStripMenuItem itemXoa = new ToolStripMenuItem();
itemXoa.Name = "XoaSanPham";
itemXoa.Text = "Xóa Sản Phẩm";
itemXoa.Click += ItemXoa_Click;
contextMenuStripListShow.Items.Add(itemXoa);
ListShow.ContextMenuStrip = contextMenuStripListShow;
}
private void ButtonChonAnh_Click(object sender, EventArgs e)
{
int Id;
try
{
Id = int.Parse(ListShow.SelectedItems[0].SubItems[1].Text);
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
return;
}
string path = ExtensionHelper.ChoosePath();
if (path != string.Empty)
{
try
{
MedicineHelper.UpdateImage(Id, path);
ImageShow.Image = ChangeBitmapHelper.ChangeBitMap(ImageShow, path);
}
catch
{
MessageBox.Show("Có Lỗi Xảy Ra!");
}
}
}
private void ButtonThemVaoDanhSach_Click(object sender, EventArgs e)
{
Medicine medicine;
BoolClass boolClass = new BoolClass()
{
isChanged = false
};
ThemSanPhamForm themSanPhamForm = new ThemSanPhamForm(boolClass);
themSanPhamForm.ShowDialog();
if (boolClass.isChanged == true)
{
ListShow.Items.Clear();
List <Medicine> medicines = MedicineHelper.GetMedicines();
int i = 0;
foreach (var item in medicines)
{
ListViewItem listViewItem = new ListViewItem(new string[] { i.ToString(), item.ID_Medicine.ToString(),
item.Name_Medicine,
item.Remain_Amount.ToString(),
item.Expiry_Date.ToString() });
ListShow.Items.Add(listViewItem);
i++;
}
}
ShowMedicines.InitComboBoxCategory(ComboBoxChonLoai);
}
public NhapHang()
{
InitializeComponent();
InitilizeManufaturerComboBox();
ShowMedicines.InitComboBoxCategory(ComboBoxChonLoai);
ListNhapHang.Columns[ListNhapHang.Columns.Count - 1].Width = 0;
ListShow.Items.Clear();
List <Medicine> medicines = MedicineHelper.GetMedicines();
int i = 0;
foreach (var item in medicines)
{
ListViewItem listViewItem = new ListViewItem(new string[] { i.ToString(), item.ID_Medicine.ToString(),
item.Name_Medicine,
item.Remain_Amount.ToString(),
item.Expiry_Date.ToString() });
ListShow.Items.Add(listViewItem);
i++;
}
ContextMenuStrip contextMenuStripListShow = new ContextMenuStrip();
ToolStripMenuItem itemXoa = new ToolStripMenuItem();
itemXoa.Name = "XoaSanPham";
itemXoa.Text = "Xóa Sản Phẩm";
itemXoa.Click += ItemXoa_Click;
contextMenuStripListShow.Items.Add(itemXoa);
ListNhapHang.ContextMenuStrip = contextMenuStripListShow;
}
private void ButtonXacNhan_Click(object sender, EventArgs e)
{
foreach (var x in listToAdd)
{
MedicineHelper.ImportMedicine(x.Item1);
}
this.Dispose();
}
private void ButtonSuaThongTinHang_Click(object sender, EventArgs e)
{
int Id;
try
{
Id = int.Parse(ListShow.SelectedItems[0].SubItems[1].Text);
}
catch (Exception ex)
{
return;
}
BoolClass boolClass = new BoolClass();
boolClass.isChanged = false;
Medicine medicine1 = null;
foreach (var medicine in MedicineHelper.GetMedicines())
{
if (medicine.ID_Medicine == Id)
{
medicine1 = medicine;
medicine1.ID_Category = new List <int?>();
medicine1.Name_Category = new List <string>();
foreach (var category in MedicineHelper.GetCategoryOfTheMedicine(medicine.ID_Medicine))
{
medicine1.ID_Category.Add(category.CategoryID);
medicine1.Name_Category.Add(category.NameCategory);
}
break;
}
}
ChangeInformationMedicine changeInformationMedicine = new ChangeInformationMedicine(medicine1, boolClass);
changeInformationMedicine.ShowDialog();
if (boolClass.isChanged == false)
{
return;
}
else
{
MedicineHelper.UpdateMedicine(medicine1, Id);
MedicineHelper.UpdateCategoryWithMedicine(medicine1);
}
ListShow.Items.Clear();
//button1_Click(PictureBoxDanhMucSanPham, null);
Init();
//ComboBoxChonLoai_SelectedValueChanged(ComboBoxChonLoai, null);
SelectShowList(ListShow, new EventArgsForMedicine {
Id = Id
});
}
private void ButtonApDung_Click(object sender, EventArgs e)
{
medicine.Name_Category.Clear();
foreach (var x in control.checkListBox.CheckedItems)
{
medicine.Name_Category.Add(x.ToString());
}
medicine.ID_Category.Clear();
foreach (var x in medicine.Name_Category)
{
medicine.ID_Category.Add(MedicineHelper.GetIdCategoryWithName(x));
}
medicine.Name_Medicine = TextBoxTenSanPham.Text;
try
{
//medicine.Expiry_Date = new DateTime(int.Parse(TextBoxNamHetHan.Text),int.Parse(TextBoxThangHetHan.Text) , int.Parse(TextBoxNgayHetHan.Text));
}
catch (Exception ex)
{
MessageBox.Show("Nhap sai ngày tháng hết hạn", null, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
medicine.Source = TextBoxXuatXu.Text;
try
{
//medicine.Expiry_Date = new DateTime(int.Parse(TextBoxNamSanXuat.Text), int.Parse(TextBoxThangSanXuat.Text), int.Parse(TextBoxNgaySanXuat.Text));
}
catch (Exception ex)
{
MessageBox.Show("Nhap sai ngày tháng sản xuất", null, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
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);
}
medicine.Registration_Number = TextBoxMaDangKi.Text;
Check.isChanged = true;
this.Close();
}
private void ComboBoxChonLoai_SelectedValueChanged(object sender, EventArgs e)
{
if (GUI_Admin.listIsShow)
{
try
{
int idCategory = 0;
idCategory = (ComboBoxChonLoai.SelectedItem as DataRowView).Row.Field <int>("ID_Category");
ListShow.Items.Clear();
using (SqlConnection sqlConnection = new SqlConnection(Form1.connect))
{
if (idCategory > 0)
{
int i = 0;
List <Medicine> medicines = MedicineHelper.GetMedicinesWithCategory(idCategory);
foreach (var item in medicines)
{
ListViewItem listViewItem = new ListViewItem(new string[] { i.ToString(), item.ID_Medicine.ToString(),
item.Name_Medicine,
item.Remain_Amount.ToString(),
item.Expiry_Date.ToString() });
ListShow.Items.Add(listViewItem);
i++;
}
}
else
{
List <Medicine> medicines = MedicineHelper.GetMedicines();
int i = 0;
foreach (var item in medicines)
{
ListViewItem listViewItem = new ListViewItem(new string[] { i.ToString(), item.ID_Medicine.ToString(),
item.Name_Medicine,
item.Remain_Amount.ToString(),
item.Expiry_Date.ToString() });
ListShow.Items.Add(listViewItem);
i++;
}
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
Debug.WriteLine(ex.StackTrace);
}
}
}
private void ComboBoxChonLoai_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int idCategory = 0;
idCategory = (ComboBoxChonLoai.SelectedItem as ComboBoxItem).Value;
ListShow.Items.Clear();
using (SqlConnection sqlConnection = new SqlConnection(Form1.connect))
{
if (idCategory > 0)
{
int i = 0;
List <Medicine> medicines = MedicineHelper.GetMedicinesWithCategory(idCategory);
foreach (var item in medicines)
{
ListViewItem listViewItem = new ListViewItem(new string[] { i.ToString(), item.ID_Medicine.ToString(),
item.Name_Medicine,
item.Remain_Amount.ToString(),
item.Min_Expiry.Value.ToShortDateString() + " - " + item.Max_Expiry.Value.ToShortDateString() });
ListShow.Items.Add(listViewItem);
i++;
}
}
else
{
List <Medicine> medicines = MedicineHelper.GetMedicines();
int i = 0;
foreach (var item in medicines)
{
ListViewItem listViewItem = new ListViewItem(new string[] { i.ToString(), item.ID_Medicine.ToString(),
item.Name_Medicine,
item.Remain_Amount.ToString(),
item.Min_Expiry.Value.ToShortDateString() + " - " + item.Max_Expiry.Value.ToShortDateString() });
ListShow.Items.Add(listViewItem);
i++;
}
}
}
}
catch (Exception ex)
{
}
}
private void ListShow_SelectedIndexChanged(object sender, EventArgs e)
{
int Id;
try
{
if (ListShow.SelectedItems.Count > 0)
{
Id = int.Parse(ListShow.SelectedItems[0].SubItems[1].Text);
}
else
{
return;
}
}
catch (Exception ex)
{
if (e is EventArgsForMedicine)
{
Id = ((EventArgsForMedicine)e).Id;
}
else
{
return;
}
}
Medicine medicine1 = new Medicine();
foreach (var medicine in MedicineHelper.GetMedicines())
{
if (medicine.ID_Medicine == Id)
{
medicine1 = medicine;
break;
}
}
if (medicine1.Remain_Amount != null)
{
TextBoxSoLuongCon.Text = medicine1.Remain_Amount.Value.ToString();
}
TextBoxXuatXu.Text = medicine1.Source;
textBoxTienNhap.Text = medicine1.Cost.ToString();
}
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++;
}
}
private void SelectShowList(object sender, EventArgs e)
{
int Id;
try
{
Id = int.Parse(ListShow.SelectedItems[0].SubItems[1].Text);
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
if (e is EventArgsForMedicine)
{
Id = ((EventArgsForMedicine)e).Id;
}
else
{
return;
}
}
Medicine medicine1 = new Medicine();
medicine1 = MedicineHelper.GetMedicineWithId(Id);
try
{
ImageShow.Image = ChangeBitmapHelper.ChangeBitMap(ImageShow, medicine1.Image_Medicine);
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
ImageShow.Image = null;
}
LabelNgaySanXuat.Text = "Ngày Sản Xuất:" + medicine1.Min_Date_Of_Manufacture.Value.ToShortDateString()
+ " - " + medicine1.Max_Date_Of_Manufacture.Value.ToShortDateString();
LabelDongGoi.Text = "Đóng gói:" + medicine1.Packing;
LabelSoLuongTrongMoiGoi.Text = "Số Lượng trong mỗi gói:" + medicine1.Unit;
LabelGiaThanh.Text = "Giá Thành:" + ExtensionHelper.ChangeToCurrency(medicine1.Cost.ToString());
LabelMaDangKi.Text = "Mã Đăng Kí:" + medicine1.Registration_Number;
LabelXuatXu.Text = "Xuất Xứ:" + medicine1.Source;
labelGiaNhap.Text = "Giá Nhập:Từ " + ExtensionHelper.ChangeToCurrency(medicine1.Min_Import_Cost.ToString()) + " tới" + ExtensionHelper.ChangeToCurrency(medicine1.Max_Import_Cost.ToString());
}
private void TextBoxTimKiem_TextChanged(object sender, EventArgs e)
{
ListShow.Items.Clear();
List <Medicine> medicines = MedicineHelper.GetMedicines();
int i = 0;
foreach (var item in medicines)
{
ListViewItem listViewItem = new ListViewItem(new string[] { i.ToString(), item.ID_Medicine.ToString(),
item.Name_Medicine,
item.Remain_Amount.ToString(),
item.Min_Expiry.Value.ToShortDateString() + " - " + item.Max_Expiry.Value.ToShortDateString() });
ListShow.Items.Add(listViewItem);
}
foreach (ListViewItem item in ListShow.Items)
{
if (!item.SubItems[2].Text.ToLower().Contains(TextBoxTimKiem.Text.ToLower()))
{
ListShow.Items.Remove(item);
}
}
}
private static void Main()
{
IJsonSerializer serializer = new JsonSerializer();
MedicineHelper helper = new MedicineHelper(serializer);
Prescription prescription = new Prescription();
prescription.DoctorName = "Doktor Ad";
prescription.DoctorSurname = "Doctor Soyad";
prescription.Name = "Hasta Ad";
prescription.Surname = "Hasta Soyad";
prescription.PrescriptionNo = "Recete No";
prescription.Tc = "hasta tc";
prescription.SenderApplication = "Demo Otomasyon Uygulamasi";
prescription.Drugs = new List <Drug> {
new Drug {
Barcodes = new List <string> {
"8699546031870"
},
Name = "ILAC ADI",
Report = "91.24",
Price = 15,
Difference = 0,
EndDate = "13/01/2018",
Message = "yok",
Dosage1 = 1,
Dosage2 = 1F,
Period1 = 1,
Period2 = PeriodTypes.Gunde,
Quantity = 10,
},
new Drug {
Barcodes = new List <string> {
"8699546032297"
},
Name = "ILAC ADI",
Report = "91.24",
Price = 15,
Difference = 0,
EndDate = "13/01/2018",
Message = "yok",
Dosage1 = 8,
Dosage2 = 0.5F,
Period1 = 6,
Period2 = PeriodTypes.Haftada,
Quantity = 3,
},
};
//Örnek fiyat etiketi
prescription.Amount = new PrescriptionAmount();
prescription.Amount.DrugContribution = 2.1F;
prescription.Amount.ExaminationContribution_Hand = 0;
prescription.Amount.ExaminationContribution_Salary = 59;
prescription.Amount.PrescriptionContribution_Hand = 0;
prescription.Amount.PrescriptionContribution_Salary = 3;
prescription.Amount.PharmacyDiscountAmount = 1.92F;
prescription.Amount.PriceDifference = 0;
prescription.Amount.Tax18 = 0;
prescription.Amount.Tax8 = 0;
prescription.Amount.TotalPrice = 40;
prescription.Amount.TotalAmountDueToPharmacy = 10;
prescription.Amount.RetirementStatus = true;
helper.Send(prescription);
}
private void button1_Click(object sender, EventArgs e)
{
int Id;
try
{
Id = int.Parse(ListShow.SelectedItems[0].SubItems[1].Text);
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
if (e is EventArgsForMedicine)
{
Id = ((EventArgsForMedicine)e).Id;
}
else
{
MessageBox.Show("Chọn thuốc để nhập !");
return;
}
}
Medicine medicine1 = new Medicine();
medicine1 = MedicineHelper.GetMedicineWithId(Id);
try
{
DateTime dateTime = new DateTime(int.Parse(TextBoxNamSanXuat.Text),
int.Parse(TextBoxThangSanXuat.Text),
int.Parse(TextBoxNgaySanXuat.Text));
medicine1.Date_Of_Manufacture = dateTime;
if (medicine1.Date_Of_Manufacture >= DateTime.Now)
{
throw new Exception();
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
MessageBox.Show("Lỗi Nhập Vào Ngày Sản Xuất !");
return;
}
try
{
DateTime dateTime1;
DateTime dateTime;
DateTime dateTime2;
int NgaySuDung = 0;
int ThangSuDung = 0;
int NamSuDung = 0;
try
{
NgaySuDung = int.Parse(TextBoxNgaySuDung.Text);
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
try
{
ThangSuDung = int.Parse(TextBoxThangSuDung.Text);
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
try
{
NamSuDung = int.Parse(TextBoxNamSuDung.Text);
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
if (NgaySuDung == 0 && ThangSuDung == 0 && NamSuDung == 0)
{
throw new Exception("Lỗi Nhập Vào Hạn Sử Dụng !");
}
if (medicine1.Date_Of_Manufacture != null)
{
dateTime2 = new DateTime(medicine1.Date_Of_Manufacture.Value.Year,
medicine1.Date_Of_Manufacture.Value.Month,
medicine1.Date_Of_Manufacture.Value.Day);
dateTime1 = new DateTime(dateTime2.AddYears(NamSuDung).Year,
dateTime2.AddMonths(ThangSuDung).Month,
dateTime2.AddDays(NgaySuDung).Day);
medicine1.Expiry_Date = dateTime1;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
try
{
int amount = int.Parse(textBoxSoLuong.Text);
medicine1.Remain_Amount = amount;
}
catch (Exception ex)
{
MessageBox.Show("Lỗi Nhập Vào Số Lượng !");
return;
}
medicine1.ID_Category = new List <int?>();
medicine1.ID_Manufacturer = new List <int?>();
try
{
int idManufacturer = (int)(ComboBoxCongty.SelectedItem as ComboBoxItem).Value;
if (!medicine1.ID_Manufacturer.Contains(idManufacturer))
{
medicine1.ID_Manufacturer.Add(idManufacturer);
}
}
catch (Exception ex)
{
MessageBox.Show("Hãy Chọn Công Ty Sản Xuất");
return;
Debug.WriteLine(ex.ToString());
}
try
{
decimal Cost = decimal.Parse(textBoxTienNhap.Text);
medicine1.Cost = Cost;
}
catch
{
MessageBox.Show("Nhập vào số tiền mỗi đơn vị thuốc");
return;
}
//try
//{
// int idCategory = (ComboBoxChonLoai.SelectedItem as ComboBoxItem).Value;
// if (!medicine1.ID_Category.Contains(idCategory))
// medicine1.ID_Category.Add(idCategory);
//}
//catch (Exception ex)
//{
// Debug.WriteLine(ex.ToString());
//}
listToAdd.Add(new Tuple <Medicine, int>(medicine1, iteratorAdd));
ListViewItem listViewItem = new ListViewItem(new string[] { i.ToString(), medicine1.ID_Medicine.ToString(),
medicine1.Name_Medicine,
medicine1.Remain_Amount.ToString(),
medicine1.Expiry_Date.Value.ToShortDateString(), ExtensionHelper.ChangeToCurrency((medicine1.Cost.Value * medicine1.Remain_Amount.Value).ToString()), iteratorAdd.ToString() });
ListNhapHang.Items.Add(listViewItem);
iteratorAdd++;
i++;
decimal Total = 0;
foreach (ListViewItem row in ListNhapHang.Items)
{
Total += decimal.Parse(ExtensionHelper.ChangeToNormalDecimal(row.SubItems[5].Text));
}
labelTongTien.Text = ExtensionHelper.ChangeToCurrency(Total.ToString()) + " VND";
}
