public DataSet GetCityList(City_class model)
{
DataSet dt = new DataSet();
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("sp_get_cityies", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@stateID", model.StateID);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
catch (Exception ex)
{
dt = null;
}
return(dt);
}
public Response GetCityList(City_class model)
{
try
{
var response = new Response();
DataSet ds = null;
ds = blObj.GetCityList(model);
if (ds != null && ds.Tables.Count > 0)
{
List <City_class> citylist = new List <City_class>();
if (ds.Tables[0].Rows[0][0].ToString() == "200")
{
if (ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
City_class data = new City_class();
data.id = dr["id"].ToString();
data.CityName = dr["cityname"].ToString();
data.StateID = dr["state_id"].ToString();
citylist.Add(data);
}
response = new Response
{
ResponseCode = ds.Tables[0].Rows[0]["Statuscode"].ToString(),
ResponseMessage = ds.Tables[0].Rows[0]["Message"].ToString(),
ResponseList = new
{
citylist
}
};
}
}
else
{
response = new Response
{
ResponseCode = ds.Tables[0].Rows[0]["Statuscode"].ToString(),
ResponseMessage = ds.Tables[0].Rows[0]["Message"].ToString(),
};
}
}
else
{
response = new Response
{
ResponseCode = Common.ReturnCode("ErrorCode"),
ResponseMessage = Common.ReturnCode("ErrorMessage")
};
}
return(response);
}
catch (Exception ex)
{
return(new Response
{
ResponseCode = Common.ReturnCode("ErrorCode"),
ResponseMessage = Common.ReturnCode("ErrorMessage")
});
}
}
