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