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; } }