public HttpResponseMessage PostGetCityDDL(mstcity objmstcity)
{
CommonDAL _objCommonDAL = new CommonDAL();
Response objResponse = new Response();
mstcity _objmstcity = new mstcity();
List <city> _objcitylist = new List <city>();
try
{
DataSet dsResult = new DataSet();
string jsonData = string.Empty;
dsResult = _objCommonDAL.GetCityDDLDal(objmstcity);
if (dsResult != null)
{
if (dsResult.Tables[0] != null)
{
if (dsResult.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++)
{
_objcitylist.Add(new city
{
cityid = dsResult.Tables[0].Rows[i]["cityId"].ToString(),
cityname = dsResult.Tables[0].Rows[i]["cityname"].ToString()
});
}
_objmstcity.citylist = _objcitylist;
objResponse.Data = _objmstcity;
objResponse.Success = true;
return(Request.CreateResponse(HttpStatusCode.OK, objResponse));
}
else
{
_objmstcity.citylist = _objcitylist;
objResponse.Data = _objmstcity;
objResponse.Success = true;
}
}
}
return(Request.CreateResponse(HttpStatusCode.OK, objResponse));
}
catch (Exception ex)
{
#region set exception response
string logMsg = Environment.NewLine + DateTime.Now + Environment.NewLine + "Method Name: GetGetCityDDL | Contoller Name: common Controller" + Environment.NewLine;
logMsg += "stateid: " + objmstcity.stateid + "|" + DateTime.Now + "|" + ex.ToString() + "-" + Environment.NewLine;
ErrorHandler.ErrorLog(logMsg);
#endregion set exception response
objResponse.Success = false;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.BadRequest, objResponse);
return(response);
}
}
public DataSet GetCityDDLDal(mstcity objmstcity)
{
try
{
SqlParameter[] P = new SqlParameter[] {
new SqlParameter("@stateID", objmstcity.stateid)
};
DataSet dtResult = new DataSet();
dtResult = DataLib.GetStoredProcData(DataLib.Connection.SetConnectionString, SPKeys.SPGetMstcity, P);
return(dtResult);
}
catch { throw; }
}
