private void loadRoom()
{
connectDBEntity mod = new connectDBEntity();
var pHONGTROs = mod.PHONGTRO.Select(a => new { a.MaPhong, a.TenPhong }).ToList();
foreach (var item in pHONGTROs)
{
Comboboxitem it = new Comboboxitem();
it.Text = item.TenPhong;
it.Value = item.MaPhong;
cboRoom.Items.Add(it);
}
}
public AddClient()
{
InitializeComponent();
SqlConnection conn = new SqlConnection(conn_str);
conn.Open();
string query = "SELECT id, misamarti from dbo.Darbazi";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.CommandText = query;
SqlDataReader drd = cmd.ExecuteReader();
while (drd.Read())
{
Comboboxitem item = new Comboboxitem();
item.text = drd["misamarti"].ToString();
item.value = drd["id"];
gymBox.Items.Add(item);
}
drd.Close();
query = "SELECT id, fasi from dbo.Abonimentebi";
SqlCommand cmd2 = new SqlCommand(query, conn);
cmd2.Connection = conn;
cmd2.CommandText = query;
SqlDataReader drd2 = cmd2.ExecuteReader();
while (drd2.Read())
{
Comboboxitem item = new Comboboxitem();
item.text = drd2["fasi"].ToString() + " lariani";
item.value = drd2["id"];
abBox.Items.Add(item);
}
drd2.Close();
conn.Close();
}
