private List <CityProperty> BindCityObject(DataTable dataTable)
{
var objCityList = new List <CityProperty>();
try
{
if (dataTable != null && dataTable.Rows.Count > 0)
{
for (var j = 0; j < dataTable.Rows.Count; j++)
{
var objCity = new CityProperty
{
CityId = (dataTable.Rows[j]["AjCityId"] is DBNull) ? 0 : Convert.ToInt32(dataTable.Rows[j]["AjCityId"]),
CityName = (dataTable.Rows[j]["AjCityName"] is DBNull) ? null : Convert.ToString(dataTable.Rows[j]["AjCityName"]),
CountryId = (dataTable.Rows[j]["AjCountryId"] is DBNull) ? 0 : Convert.ToInt32(dataTable.Rows[j]["AjCountryId"]),
CountryName = (dataTable.Rows[j]["AjCountryName"] is DBNull) ? null : Convert.ToString(dataTable.Rows[j]["AjCountryName"]),
StateId = (dataTable.Rows[j]["AjStateId"] is DBNull) ? 0 : Convert.ToInt32(dataTable.Rows[j]["AjStateId"]),
StateName = (dataTable.Rows[j]["AjStateName"] is DBNull) ? null : Convert.ToString(dataTable.Rows[j]["AjStateName"]),
ZoneId = (dataTable.Rows[j]["AjZoneId"] is DBNull) ? 0 : Convert.ToInt32(dataTable.Rows[j]["AjZoneId"]),
ZoneName = (dataTable.Rows[j]["AjZoneName"] is DBNull) ? null : Convert.ToString(dataTable.Rows[j]["AjZoneName"])
};
objCityList.Add(objCity);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindCityObject in City.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objCityList);
}
set => SetValue(CityProperty, value);
