public BEDocumentCategories SelectAllInactive()
{
BEDocumentCategories ds = new BEDocumentCategories();
DADocumentCategories da = new DADocumentCategories();
da.SelectAllInactive(ds.tbl_DocumentCategories);
return ds;
}
protected void BindDocumentCategoriesList()
{
BPDocumentCategories bpcat = new BPDocumentCategories();
DSDocumentCategories = bpcat.SelectAll();
//DSDocumentCategories.tbl_DocumentCategories.DefaultView.Sort = "DocumentCategoryOrder";
DSDocumentCategories.tbl_DocumentCategories.DefaultView.Sort = "DocumentCategoryName";
dgDocumentCategories.DataBind();
}
public BEDocumentCategories UpdateByDocumentCategoryID(int DocumentCatgeoryID)
{
BEDocumentCategories ds = new BEDocumentCategories();
DADocumentCategories da = new DADocumentCategories();
da.UpdateByDocumentCategoryID(DocumentCatgeoryID, ds.tbl_DocumentCategories);
return ds;
}
public BEDocumentCategories SelectDocumentCategoryByID(int DocumentCatgeoryID)
{
BEDocumentCategories ds = new BEDocumentCategories();
DADocumentCategories da = new DADocumentCategories();
da.SelectByID(DocumentCatgeoryID.ToString(), ds.tbl_DocumentCategories);
return ds;
}
private void btnDelete_Click(object sender, EventArgs e)
{
BPDocumentCategories bp = new BPDocumentCategories();
BEDocumentCategories.tbl_DocumentCategoriesRow DocumentCategory;
DSDocumentCategories = bp.SelectDocumentCategoryByID(DocumentCategoryID);
DocumentCategory = DSDocumentCategories.tbl_DocumentCategories.FindByDocumentCategoryID(DocumentCategoryID);
DocumentCategory.Delete();
bp.Update(DSDocumentCategories);
bp.UpdateByDocumentCategoryID(DocumentCategoryID);
Response.Redirect("BrowseDocumentCategories.aspx");
}
private void btnSubmit_ServerClick(object sender, EventArgs e)
{
BPDocumentCategories bp = new BPDocumentCategories();
BEDocumentCategories.tbl_DocumentCategoriesRow category;
DSDocumentCategories = new BEDocumentCategories();
//if they are making this category inactive make all items below this category unassigned and inactive
if (DocumentCategoryID > 0)
{
bool wasActive = GetDocumentCategoryActiveStatus(DocumentCategoryID);
if ((wasActive) && (! chkDocumentCategoryActive.Checked))
{
bp.UpdateByDocumentCategoryID(DocumentCategoryID);
}
}
if (DocumentCategoryID == 0)
{
// Add a Document Category
category = DSDocumentCategories.tbl_DocumentCategories.Newtbl_DocumentCategoriesRow();
}
else
{
// Edit a Document Category
DSDocumentCategories = bp.SelectDocumentCategoryByID(DocumentCategoryID);
category = DSDocumentCategories.tbl_DocumentCategories.FindByDocumentCategoryID(DocumentCategoryID);
}
//all content to be updated/inserted between here
category.DocumentCategoryName = txtDocumentCategoryName.Text;
category.DocumentCategoryDescription = txtDocumentCategoryDescription.Text;
category.DocumentCategoryActive = chkDocumentCategoryActive.Checked;
category.DateModified = DateTime.Now;
category.ModifiedByAdminID = Convert.ToInt32(OryxUser.OryxIdentity.MemberID);
//all content to be updated/inserted between here
if (DocumentCategoryID == 0)
{
//Add new Document Category
category.DocumentCategoryOrder = bp.GetDocumentCategoryMaxOrder();
category.DateCreated = DateTime.Now;
DSDocumentCategories.tbl_DocumentCategories.Addtbl_DocumentCategoriesRow(category);
}
bp.Update(DSDocumentCategories);
Response.Redirect("BrowseDocumentCategories.aspx");
}
protected bool GetDocumentCategoryActiveStatus(int DocumentCategoryID)
{
BPDocumentCategories bp = new BPDocumentCategories();
DSDocumentCategories = bp.SelectDocumentCategoryByID(DocumentCategoryID);
BEDocumentCategories.tbl_DocumentCategoriesRow category = DSDocumentCategories.tbl_DocumentCategories[0];
category = DSDocumentCategories.tbl_DocumentCategories[0];
return category.DocumentCategoryActive;
}
public void Update(BEDocumentCategories ds)
{
DADocumentCategories da = new DADocumentCategories();
da.Update(ds.tbl_DocumentCategories);
}
