public Category CreateCategory(Category category) { try { if (category != null) { category.DateCreated = DateTime.Now; category.DateModified = DateTime.Now; category.IsApproved = false; category.ApprovedByUser = null; catalogDAO.CreateCategory(category); } } catch (Exception) { throw new Exceptions.UserException("Catalog category creation failed."); } return category; }
public Category CreateCategory(Category category) { try { Category c = GetAllCategories().Where(x => x.Name.ToLower() == category.Name.ToLower()).FirstOrDefault<Category>(); using (TransactionScope ts = new TransactionScope()) { context.AddToCategories(category); context.SaveChanges(); ts.Complete(); return category; } } catch (Exception) { throw new CatalogException("Error Occured when creating category"); } }
protected void SubmitButton_Click(object sender, EventArgs e) { Category category = new Category(); category.Name = NameTextBox.Text; category.CreatedBy = Utilities.Membership.GetCurrentLoggedInUser().UserID; category.ModifiedBy = Utilities.Membership.GetCurrentLoggedInUser().UserID; CatalogManager categoryManager = new CatalogManager(); try { categoryManager.CreateCategory(category); CategoryGridView.DataBind(); } catch (Exception) { ErrorLabel.Text = "Category Creation Failed"; } }
public Category UpdateCategory(Category category) { try { Category tempCategory = (from s in context.Categories where s.CategoryID == category.CategoryID select s).First<Category>(); tempCategory.Name = category.Name; tempCategory.DateModified = DateTime.Now; tempCategory.ModifiedByUser = category.ModifiedByUser; using (TransactionScope ts = new TransactionScope()) { context.SaveChanges(); ts.Complete(); return tempCategory; } } catch (Exception) { throw; } }
public void DeleteCategory(Category category) { try { Category persistedCategory = (from c in context.Categories where c.CategoryID == category.CategoryID select c).FirstOrDefault<Category>(); using (TransactionScope ts = new TransactionScope()) { context.Categories.DeleteObject(persistedCategory); context.SaveChanges(); ts.Complete(); } } catch (Exception) { throw; } }
/// <summary> /// Get Requistions by category filter /// </summary> /// <param name="category">category object</param> /// <param name="requisitionSearchDTO">requisitionSearchDTO object</param> /// <returns>List of Requisitions by category</returns> public List<VW_RequisitionsByCategory> GetRequisitionByCategoryID(Category category, RequisitionSearchDTO requisitionSearchDTO) { try { return GetAllRequisitionByCategory() .Where(ri => ri.CategoryID == (category.CategoryID == 0 ? ri.CategoryID : category.CategoryID)) .ToList<VW_RequisitionsByCategory>(); } catch (Exception) { throw; } }
/// <summary> /// Get requisition List by category /// </summary> /// <param name="category">category object</param> /// <param name="requisitionSearchDTO">RequisitionSearchDTO object</param> /// <returns>List of VW_RequisitionsByCategory</returns> public List<VW_RequisitionsByCategory> GetRequisitionByCategory(Category category, RequisitionSearchDTO requisitionSearchDTO) { List<VW_RequisitionsByCategory> temp = requisitionDAO.GetRequisitionByCategoryID(category, requisitionSearchDTO); if (temp != null) { return temp; } else { ErrorMessage("Result Not Found"); return null; } }
/// <summary> /// Deprecated Method for adding a new object to the Categories EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToCategories(Category category) { base.AddObject("Categories", category); }
/// <summary> /// Create a new Category object. /// </summary> /// <param name="categoryID">Initial value of the CategoryID property.</param> /// <param name="name">Initial value of the Name property.</param> /// <param name="isApproved">Initial value of the IsApproved property.</param> /// <param name="dateCreated">Initial value of the DateCreated property.</param> /// <param name="dateModified">Initial value of the DateModified property.</param> /// <param name="createdBy">Initial value of the CreatedBy property.</param> /// <param name="modifiedBy">Initial value of the ModifiedBy property.</param> public static Category CreateCategory(global::System.Int32 categoryID, global::System.String name, global::System.Boolean isApproved, global::System.DateTime dateCreated, global::System.DateTime dateModified, global::System.Int32 createdBy, global::System.Int32 modifiedBy) { Category category = new Category(); category.CategoryID = categoryID; category.Name = name; category.IsApproved = isApproved; category.DateCreated = dateCreated; category.DateModified = dateModified; category.CreatedBy = createdBy; category.ModifiedBy = modifiedBy; return category; }
public Category UpdateCategory(Category category) { try { if (category != null) { category.DateModified = DateTime.Now; catalogDAO.UpdateCategory(category); } } catch (Exception) { throw new Exceptions.UserException("Catalog updating failed."); } return category; }
public void DeleteCategory(Category category) { try { if (category != null) { catalogDAO.DeleteCategory(category); } } catch (Exception) { //throw new Exceptions.UserException("Catalog deletion failed."); } }