public static Designer Load(Guid id) { DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString, "dbo.ctx_GET_DESIGNER"); cmd.AddInputParam("pUserID", System.Data.DbType.Guid, id); DataTable dt = cmd.ExecuteSelectTable(); Designer d = new Designer(); if (dt != null) { if (dt.Rows.Count > 0) { d = dt.Rows[0].ToDesigner(); } } return d; }
public static Designer ToDesigner(this DataRow dr) { Designer Designer = new Designer { ID = dr.GetGuid("UserID"), PayRate=dr.GetDouble("PayRate"), FirstName = dr.GetString("FirstName"), LastName = dr.GetString("LastName"), CreationDate = dr.GetDate("CreationDate"), LastEditDate = dr.GetDate("LastEditDate") }; return Designer; }