public Kho GetKhobyID_Kho(int ID_Kho)
{
Kho s = new Kho();
foreach (Kho i in GetAllKho())
{
if (i.ID_Kho == ID_Kho)
{
s = i;
}
}
return(s);
}
public List <Kho> GetKho(string DiaChi, string Ten)
{
Kho data = new Kho();
foreach (Khuvuc i in CSDL_OOP.Instance.GetAllKhuvuc())
{
if (i.DiaChi == DiaChi)
{
data.ID_KV = i.ID_KV;
}
}
List <Kho> k = new List <Kho>();
foreach (DataRow i in CSDL.Instance.DTKho.Rows)
{
if (data.ID_KV == 0)
{
if (Ten != "")
{
if (i["Ten"].ToString().Contains(Ten))
{
k.Add(GetKho(i));
}
}
else
{
k.Add(GetKho(i));
}
}
else
{
if (Ten != "")
{
if (i["Ten"].ToString().Contains(Ten) && Convert.ToInt32(i["ID_KV"]) == data.ID_KV)
{
k.Add(GetKho(i));
}
}
else
{
if (Convert.ToInt32(i["ID_KV"]) == data.ID_KV)
{
k.Add(GetKho(i));
}
}
}
}
return(k);
}
public void ExecuteDB(Kho s)
{
bool check = false;
foreach (Kho i in GetAllKho())
{
if (i.ID_Kho == s.ID_Kho)
{
check = true;
}
}
if (check)
{
CSDL.Instance.EditDataRow(s);
}
else
{
CSDL.Instance.AddDataRow(s);
}
}
private void btOK_Click(object sender, EventArgs e)
{
Kho s = new Kho();
s.ID_Kho = Convert.ToInt32(tbIDKho.Text);
s.Ten = tbTen.Text;
Khuvuc data = new Khuvuc();
foreach (Khuvuc i in CSDL_OOP.Instance.GetAllKhuvuc())
{
if (i.DiaChi == data.DiaChi)
{
s.ID_KV = i.ID_KV;
}
}
data.DiaChi = cbbKhuvuc.SelectedItem.ToString();
s.DienTich = Convert.ToDouble(tbDienTich.Text);
s.TrangThai = cbbTrangThai.SelectedItem.ToString();
CSDL_OOP.Instance.ExecuteDB(s);
d(0, null);
this.Dispose();
}
public List <Kho> Sort(string s, int ID_KV, string Name)
{
List <Kho> listKho = CSDL_OOP.Instance.GetListKho(ID_KV, Name);
Mydel compare;
for (int i = 0; i < listKho.Count - 1; i++)
{
for (int j = i + 1; j < listKho.Count; j++)
{
switch (s)
{
case "ID_Kho":
{
compare = new Mydel(CSDL.CompareIDKho);
if (compare(listKho[i], listKho[j]))
{
Kho temp = listKho[i];
listKho[i] = listKho[j];
listKho[j] = temp;
}
break;
}
case "Ten":
{
compare = new Mydel(CSDL.CompreTenKho);
if (compare(listKho[i], listKho[j]))
{
Kho temp = listKho[i];
listKho[i] = listKho[j];
listKho[j] = temp;
}
break;
}
case "DienTich":
{
compare = new Mydel(CSDL.CompareDienTichKho);
if (compare(listKho[i], listKho[j]))
{
Kho temp = listKho[i];
listKho[i] = listKho[j];
listKho[j] = temp;
}
break;
}
case "TrangThai":
{
compare = new Mydel(CSDL.CompareTrangThai);
if (compare(listKho[i], listKho[j]))
{
Kho temp = listKho[i];
listKho[i] = listKho[j];
listKho[j] = temp;
}
break;
}
case "ID_KV":
{
compare = new Mydel(CSDL.CompareID_KV);
if (compare(listKho[i], listKho[j]))
{
Kho temp = listKho[i];
listKho[i] = listKho[j];
listKho[j] = temp;
}
break;
}
}
}
}
return(listKho);
}
