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