public DataSet GetStatesList(State_class model)
{
DataSet dt = new DataSet();
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("sp_get_states", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@countryID", model.CountryID);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
catch (Exception ex)
{
dt = null;
}
return(dt);
}
public Response GetStateList(State_class model)
{
try
{
var response = new Response();
DataSet ds = null;
ds = blObj.GetStatesList(model);
if (ds != null && ds.Tables.Count > 0)
{
List <State_class> statelist = new List <State_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)
{
State_class data = new State_class();
data.id = dr["id"].ToString();
data.StateName = dr["statename"].ToString();
data.CountryID = dr["countryid"].ToString();
statelist.Add(data);
}
response = new Response
{
ResponseCode = ds.Tables[0].Rows[0]["Statuscode"].ToString(),
ResponseMessage = ds.Tables[0].Rows[0]["Message"].ToString(),
ResponseList = new
{
statelist
}
};
}
}
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")
});
}
}
