public citydetails bindcity()
{
List <bindcity> citylist = new List <bindcity>();
citydetails details = new citydetails();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_api_bindcity", con))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow dtrow in dt.Rows)
{
var slist = new bindcity();
slist.citycode = Convert.ToInt32(dtrow["code"]);
slist.cityname = Convert.ToString(dtrow["name"]);
citylist.Add(slist);
}
details.citydetail = citylist;
}
}
}
return(details);
}
public citydetails bindworkshopcity()
{
List <bindcity> citylist = new List <bindcity>();
citydetails details = new citydetails();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("select Code,DESCN from codemaster where TYPE='loc'", con))
{
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow dtrow in dt.Rows)
{
var slist = new bindcity();
slist.citycode = Convert.ToInt32(dtrow["code"]);
slist.cityname = Convert.ToString(dtrow["DESCN"]);
citylist.Add(slist);
}
details.citydetail = citylist;
}
}
}
return(details);
}
