public int Add(DashboardRoleType DashboardRoleT)
{
int returnID = -1;
DbCommand commandWrapper = GetDbCommand("spr_AddDashboardRoleType");
try
{
SqlParameter returnParam = new SqlParameter("@DashboardRoleTypeID", SqlDbType.Int);
returnParam.Direction = ParameterDirection.Output;
commandWrapper.Parameters.Add(returnParam);
if (string.IsNullOrWhiteSpace(DashboardRoleT.DashboardRoleType1))
{
commandWrapper.Parameters.Add(new SqlParameter("@DashboardRoleType", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@DashboardRoleType", DashboardRoleT.DashboardRoleType1.Trim()));
}
ExecuteNonQuery(commandWrapper);
DashboardRoleT.DashboardRoleTypeID = (int)returnParam.Value;
}
catch (Exception ex)
{
HandleException(ex);
}
return(returnID);
}
public List <DashboardRoleType> GetAllDashboardRoleType()
{
List <DashboardRoleType> listCollection = new List <DashboardRoleType>();
DataTable dataItems = ExecuteDataTable("spr_GetAllDashboardRoleType");
if (dataItems != null)
{
for (int i = 0; i < dataItems.Rows.Count; i++)
{
DashboardRoleType item = new DashboardRoleType();
item.DashboardRoleTypeID = dataItems.Rows[i].Field <int>("DashboardRoleTypeID");
item.DashboardRoleType1 = dataItems.Rows[i].Field <string>("DashboardRoleType");
item.DashboardRoleTypeAcronym = dataItems.Rows[i].Field <string>("DashboardRoleTypeAcronym");
listCollection.Add(item);
}
}
else
{
throw new Exception("You cannot create a DashboardRoleType collection from a null data table.");
}
return(listCollection);
}
public void Delete(DashboardRoleType DashboardRoleT)
{
if (base.ValidateKeyField(DashboardRoleT.DashboardRoleTypeID))
{
try
{
ExecuteNonQuery("spr_DeleteDashboardRoleType", DashboardRoleT.DashboardRoleTypeID);
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
public void Update(DashboardRoleType DashboardRoleT)
{
if (base.ValidateKeyField(DashboardRoleT.DashboardRoleTypeID))
{
DbCommand commandWrapper = GetDbCommand("spr_UpdateDashboardRoleType");
try
{
if (DashboardRoleT.DashboardRoleTypeID == -1)
{
commandWrapper.Parameters.Add(new SqlParameter("@DashboardRoleTypeID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@DashboardRoleTypeID", DashboardRoleT.DashboardRoleTypeID));
}
if (string.IsNullOrWhiteSpace(DashboardRoleT.DashboardRoleType1))
{
commandWrapper.Parameters.Add(new SqlParameter("@DashboardRoleType", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@DashboardRoleType", DashboardRoleT.DashboardRoleType1.Trim()));
}
if (string.IsNullOrWhiteSpace(DashboardRoleT.DashboardRoleTypeAcronym))
{
commandWrapper.Parameters.Add(new SqlParameter("@DashboardRoleTypeAcronym", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@DashboardRoleTypeAcronym", DashboardRoleT.DashboardRoleTypeAcronym.Trim()));
}
ExecuteNonQuery(commandWrapper);
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
protected virtual DashboardRoleType FillObjectFromRowData(DataRow returnRow)
{
DashboardRoleType DashboardRoleT = new DashboardRoleType();
if (returnRow["DashboardRoleTypeID"] != DBNull.Value)
{
DashboardRoleT.DashboardRoleTypeID = (int)returnRow["DashboardRoleTypeID"];
}
if (returnRow["DashboardRoleType"] != DBNull.Value)
{
DashboardRoleT.DashboardRoleType1 = returnRow["DashboardRoleType"].ToString();
}
if (returnRow["DashboardRoleTypeAcronym"] != DBNull.Value)
{
DashboardRoleT.DashboardRoleTypeAcronym = returnRow["DashboardRoleTypeAcronym"].ToString();
}
return(DashboardRoleT);
}
