///Create Procedure Data Controller public int createGeoLocationCity(geoLocationModel currentLocation) { int success; try { DbCommand sp_createct2GeoLocationCity = db.GetStoredProcCommand("sp_createct2GeoLocationCity"); sp_createct2GeoLocationCity.Connection = db.CreateConnection(); sp_createct2GeoLocationCity.Connection.Open(); foreach (cityModel city in currentLocation.cities) { db.AddInParameter(sp_createct2GeoLocationCity, "@cityDescription", SqlDbType.VarChar, city.cityDescription); db.AddInParameter(sp_createct2GeoLocationCity, "@stateIDFK", SqlDbType.VarChar, currentLocation.stateID); success = sp_createct2GeoLocationCity.ExecuteNonQuery(); } return(1); } catch (Exception ex) { return(0); } }
public int createGeoLocationState(geoLocationModel currentLocation) { int stateID = 0; int cityID = 0; DbCommand sp_createct2GeoLocationState = db.GetStoredProcCommand("sp_createct2GeoLocationState"); sp_createct2GeoLocationState.Connection = db.CreateConnection(); sp_createct2GeoLocationState.Connection.Open(); db.AddInParameter(sp_createct2GeoLocationState, "@stateDescription", SqlDbType.VarChar, currentLocation.stateDescription); stateID = sp_createct2GeoLocationState.ExecuteNonQuery(); if (stateID == 0) { // do nothing } else { currentLocation.stateID = stateID; cityID = createGeoLocationCity(currentLocation); } return(stateID); }
public bool DeleteState(geoLocationModel removingState) { DbCommand sp_deletect2GeoLocationState = db.GetStoredProcCommand("sp_deletect2GeoLocationState"); db.AddInParameter(sp_deletect2GeoLocationState, "@stateID", SqlDbType.Int, removingState.stateID); return(false); }
public bool UpdateState(geoLocationModel currentState) { DbCommand sp_updatect2GeoLocationState = db.GetStoredProcCommand("sp_updatect2GeoLocationState"); db.AddInParameter(sp_updatect2GeoLocationState, "@stateID", SqlDbType.Int, currentState.stateID); db.AddInParameter(sp_updatect2GeoLocationState, "@stateDescription", SqlDbType.VarChar, currentState.stateDescription); return(false); }