public ActionResult GetDropdown_Users()
{
List <DropDown2> list = new List <DropDown2>();
SqlCommand cmdSql = new SqlCommand();
cmdSql.Connection = conn;
cmdSql.CommandTimeout = 0;
cmdSql.CommandType = CommandType.StoredProcedure;
cmdSql.CommandText = @"dbo.Get_Dropdowns";
cmdSql.Parameters.Clear();
cmdSql.Parameters.Add("@ParentID", SqlDbType.NVarChar).Value = "";
cmdSql.Parameters.Add("@Table", SqlDbType.NVarChar).Value = "M_Users";
cmdSql.CommandTimeout = 0;
conn.Open();
cmdSql.ExecuteNonQuery();
using (SqlDataReader rdr = cmdSql.ExecuteReader())
{
while (rdr.Read())
{
DropDown2 item = new DropDown2();
item.ID = rdr["EmployeeNo"].ToString();
item.ItemName = rdr["ItemName"].ToString();
list.Add(item);
}
}
conn.Close();
return(Json(new { list = list }, JsonRequestBehavior.AllowGet));
}
private async void OnExpanderTapped2(object sender, EventArgs e)
{
if (DropDown2.Rotation == 0)
{
await DropDown2.RotateTo(180, 1);
}
else
{
await DropDown2.RotateTo(0, 1);
}
}
