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