public int DeleteCity(EntityCity entCity)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@PKId", DbType.String, entCity.CityCode);
cnt = mobjDataAcces.ExecuteQuery("sp_DeleteCity", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("CityBLL - DeleteCity(EntityCity entCity)", ex);
}
return(cnt);
}
public int InsertCity(EntityCity entCity)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@StateId", DbType.Int32, entCity.State);
Commons.ADDParameter(ref lstParam, "@CityDesc", DbType.String, entCity.CityDesc);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entCity.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertCity ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("CityBLL - InsertCity(EntityCity entCity)", ex);
}
return(cnt);
}
