public static void FillObject(Business.DataObjectLocation item, SqlDataReader sqlReader) { if (sqlReader["Website"] != DBNull.Value) { item.Website = new Uri(sqlReader["Website"].ToString()); } }
private static void SetParameters(Business.DataObjectLocation item, SqlParameterCollection parameters) { if (item.Website != null) { parameters.AddWithValue("@Website", item.Website.ToString()); } else { parameters.AddWithValue("@Website", DBNull.Value); } }
public static string GetUpdateSQL(Business.DataObjectLocation item, SqlParameterCollection parameters) { SetParameters(item, parameters); return("UPDATE hiobj_Location SET [Website] = @Website"); }
public static string GetInsertSQL(Business.DataObjectLocation item, SqlParameterCollection parameters) { SetParameters(item, parameters); return(@"INSERT INTO hiobj_Location (OBJ_ID,Website) VALUES (@OBJ_ID,@Website)"); }