private SmartCollection<PriorityRestriction> GetCatalogItemPriorityRestrictions(ref MsSqlPersistence dbConnection, ref SqlCommand dbCommand, int catalogid, Identification identification) { try { SmartCollection<PriorityRestriction> result = new SmartCollection<PriorityRestriction>(); if (dbConnection.IsConnected()) { dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.CommandText = "uspGetPriorityRestrictions"; dbCommand.Parameters.Clear(); dbCommand.Parameters.Add("@CatalogId", System.Data.SqlDbType.Int).Value = catalogid; DataTable returnDT = dbConnection.ExecuteQuery(dbCommand); foreach (DataRow row in returnDT.Rows) { PriorityRestriction catalogItemPriority = new PriorityRestriction(); catalogItemPriority.PriorityRestrictionId = (int)row["PriorityRestrictionID"]; catalogItemPriority.CatalogId = row["CatalogID"] != DBNull.Value ? (int)row["CatalogID"] : 0; catalogItemPriority.PriorityId = row["PriorityID"] != DBNull.Value ? (int)row["PriorityID"] : 0; catalogItemPriority.CreatedBy = row["CreatedBy"] != DBNull.Value ? Convert.ToInt32(row["CreatedBy"]) : 0; catalogItemPriority.CreatedUser = row["CreatedUser"].ToString(); catalogItemPriority.CreatedDate = row["CreatedDate"] != DBNull.Value ? (DateTime)row["CreatedDate"] : (DateTime)SqlDateTime.Null; catalogItemPriority.ModifiedBy = row["ModifiedBy"] != DBNull.Value ? Convert.ToInt32(row["ModifiedBy"]) : 0; catalogItemPriority.ModifiedUser = row["ModifiedUser"].ToString(); catalogItemPriority.ModifiedDate = row["ModifiedDate"] != DBNull.Value ? (DateTime)row["ModifiedDate"] : (DateTime)SqlDateTime.Null; using (SystemDAO systemDao = new SystemDAO()) { catalogItemPriority.Priority = systemDao.GetPriority(catalogItemPriority.PriorityId); } result.Add(catalogItemPriority); } returnDT = null; }else { throw new Exception("Unable to Connect"); } return result; }catch { throw; } }
public PriorityRestriction CreateCatalogItemPriority() { PriorityRestriction newItem = new PriorityRestriction(); newItem.PriorityRestrictionId = addingCatalogItemPriorityId--; newItem.CatalogId = CatalogItem.CatalogId; this.selectedCatalogItemPriority = newItem.Clone(); return newItem; }
private PriorityRestriction GetCatalogItemPriority(ref MsSqlPersistence dbConnection, ref SqlCommand dbCommand, int? priorityId) { try { PriorityRestriction catalogItemPriority = new PriorityRestriction(); if (dbConnection.IsConnected()) { dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.CommandText = "uspGetPriorityRestriction"; dbCommand.Parameters.Clear(); dbCommand.Parameters.Add("@PriorityRestrictionId", System.Data.SqlDbType.Int).Value = priorityId; DataTable returnDT = dbConnection.ExecuteQuery(dbCommand); if (returnDT.Rows.Count == 1) { DataRow row = returnDT.Rows[0]; catalogItemPriority.PriorityRestrictionId = (int)row["PriorityRestrictionID"]; catalogItemPriority.CatalogId = row["CatalogID"] != DBNull.Value ? (int)row["CatalogID"] : 0; catalogItemPriority.PriorityId = row["PriorityID"] != DBNull.Value ? (int)row["PriorityID"] : 0; catalogItemPriority.CreatedBy = row["CreatedBy"] != DBNull.Value ? Convert.ToInt32(row["CreatedBy"]) : 0; catalogItemPriority.CreatedUser = row["CreatedUser"].ToString(); catalogItemPriority.CreatedDate = row["CreatedDate"] != DBNull.Value ? (DateTime)row["CreatedDate"] : (DateTime)SqlDateTime.Null; catalogItemPriority.ModifiedBy = row["ModifiedBy"] != DBNull.Value ? Convert.ToInt32(row["ModifiedBy"]) : 0; catalogItemPriority.ModifiedUser = row["ModifiedUser"].ToString(); catalogItemPriority.ModifiedDate = row["ModifiedDate"] != DBNull.Value ? (DateTime)row["ModifiedDate"] : (DateTime)SqlDateTime.Null; using (SystemDAO systemDao = new SystemDAO()) { catalogItemPriority.Priority = systemDao.GetPriority(catalogItemPriority.PriorityId); } returnDT = null; } else { returnDT = null; return null; } } else { throw new Exception("Unable to Connect"); } return catalogItemPriority; } catch { throw; } }