/// <summary> /// Execute stored procedure to save geo data /// </summary> private static void ExecuteSaveProcedure(GeoDataInstance objParams, SqlConnection SqlConn) { SqlCommand objCommand = new SqlCommand("bvSaveGeographicalData_sp", SqlConn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.Add("@p_table_source", SqlDbType.Int).Value = objParams.table_source; objCommand.Parameters.Add("@p_table_id", SqlDbType.Int).Value = objParams.table_id; objCommand.Parameters.Add("@p_latitude", SqlDbType.Decimal).Value = objParams.latitude; objCommand.Parameters.Add("@p_longitude", SqlDbType.Decimal).Value = objParams.longitude; objCommand.Parameters.Add("@p_user_id", SqlDbType.Int).Value = UserSession.CurrentUser.UserId; objCommand.ExecuteNonQuery(); }
/// <summary> /// Save geographical data /// </summary> public static void SaveGeoData(GeoDataInstance objParams, SqlConnection SqlConn) { ExecuteSaveProcedure(objParams, SqlConn); }