public BEDocuments SelectByDocumentID(int DocumentID)
{
BEDocuments ds = new BEDocuments();
DADocumentInventoryItems da = new DADocumentInventoryItems();
da.SelectByDocumentID(DocumentID, ds.tbl_DocumentInventoryItems);
return ds;
}
public BEDocuments SelectAllInactive()
{
BEDocuments ds = new BEDocuments();
DADocumentInventoryItems da = new DADocumentInventoryItems();
da.SelectAllInactive(ds.tbl_DocumentInventoryItems);
return ds;
}
public BEDocuments SelectAllWithROColumns()
{
BEDocuments ds = new BEDocuments();
DADocuments da = new DADocuments();
da.SelectAllWithReadOnlyColumns(ds.tbl_Documents);
return ds;
}
public BEDocuments SelectByCompanyIDAndDocumentID(int CompanyID, int DocumentID)
{
BEDocuments ds = new BEDocuments();
DADocumentInventoryItems da = new DADocumentInventoryItems();
da.SelectByCompanyIDAndDocumentID(CompanyID, DocumentID, ds.tbl_DocumentInventoryItems);
return ds;
}
public BEDocuments SelectAllInactive()
{
DADocuments da = new DADocuments();
BEDocuments ds = new BEDocuments();
da.SelectAllInactive(ds.tbl_Documents);
return ds;
}
public BEDocuments SelectAllInactive()
{
BEDocuments ds = new BEDocuments();
DADocumentCategories da = new DADocumentCategories();
da.SelectAllInactive(ds.tbl_DocumentCategories);
return ds;
}
private BEDocuments SelectShippingDocumentsByProductIDorWorkshopIDorNonSalesInventoryIDorWorkshopSuppliesID(int ProductID, int WorkshopID, int NonSalesInventoryID, int WorkshopSuppliesID)
{
BEDocuments ds = new BEDocuments();
DADocuments da = new DADocuments();
da.SelectIncludedByProductIDorWorkshopIDorNonSalesInventoryIDorWorkshopSuppliesID(ProductID, WorkshopID, NonSalesInventoryID, WorkshopSuppliesID, ds.tbl_Documents);
return ds;
}
public BEDocuments SelectDocumentInventoryItemByID(int DocumentInventoryItemID)
{
BEDocuments ds = new BEDocuments();
DADocumentInventoryItems da = new DADocumentInventoryItems();
da.SelectByID(DocumentInventoryItemID.ToString(), ds.tbl_DocumentInventoryItems);
return ds;
}
public BEDocuments SelectByID(int Documentid)
{
DADocuments daD = new DADocuments();
BEDocuments ds = new BEDocuments();
daD.SelectByID(Documentid.ToString(), ds.tbl_Documents);
return ds;
}
public BEDocuments SelectShippingDocumentsByWorkshopInstanceID(int WorkshopInstanceID)
{
BEDocuments ds = new BEDocuments();
DADocuments da = new DADocuments();
da.SelectShippingDocumentsByWorkshopInstanceID(WorkshopInstanceID, ds.tbl_Documents);
return ds;
}
public BEDocuments SelectShippingDocumentsByOrderID(int OrderID)
{
BEDocuments ds = new BEDocuments();
DADocuments da = new DADocuments();
da.SelectShippingDocumentsByOrderID(OrderID, ds.tbl_Documents);
return ds;
}
public BEDocuments SelectByID(int DocumentCatgeoryID)
{
BEDocuments ds = new BEDocuments();
DADocumentCategories da = new DADocumentCategories();
da.SelectByID(DocumentCatgeoryID.ToString(), ds.tbl_DocumentCategories);
return ds;
}
public BEDocuments SelectActiveByDocumentCategoryID(int DocumentCategoryID)
{
DADocuments da = new DADocuments();
BEDocuments ds = new BEDocuments();
da.SelectActiveByDocumentCategoryID(DocumentCategoryID, ds.tbl_Documents);
return ds;
}
public BEDocuments SelectActiveWithDocumentCategories()
{
DADocuments da = new DADocuments();
BEDocuments ds = new BEDocuments();
da.SelectActiveWithDocumentCategories(ds.tbl_Documents);
return ds;
}
protected DataView GetData()
{
BPDocumentCategories bp = new BPDocumentCategories();
DSDocuments = bp.SelectAll();
DSDocuments.tbl_DocumentCategories.DefaultView.RowFilter = RowFilter("DocumentCategoryName", ((LinkButton)rptLetters.Items[0].FindControl("lnkLetter")).CommandName, "DocumentCategoryActive", lstActive.SelectedValue);
DSDocuments.tbl_DocumentCategories.DefaultView.Sort = DSDocuments.tbl_DocumentCategories.DocumentCategoryNameColumn.ColumnName;
return DSDocuments.tbl_DocumentCategories.DefaultView;
}
protected DataView GetData()
{
BPDocuments bp = new BPDocuments();
if (ddlDocumentCategories.SelectedValue == "-1")
DSDocuments = bp.SelectWithDocumentCategories();
else
DSDocuments = bp.SelectByDocumentCategoryID(Convert.ToInt32(ddlDocumentCategories.SelectedValue));
DSDocuments.tbl_Documents.DefaultView.RowFilter = RowFilter("DocumentAlias", ((LinkButton)rptLetters.Items[0].FindControl("lnkLetter")).CommandName, "DocumentActive", lstActive.SelectedValue);
return DSDocuments.tbl_Documents.DefaultView;
}
protected void BindDocuments()
{
BPDocuments bpu = new BPDocuments();
DSDocuments = new BEDocuments();
if (ddlDocumentCategories.SelectedValue != "-1")
{
DSDocuments.Merge(bpu.SelectAllByDocumentCategoryID(Convert.ToInt32(ddlDocumentCategories.SelectedValue)));
}
else
{
DSDocuments.Merge(bpu.SelectAllWithDocumentCategories());
}
int DocumentCategoryID = -1;
Boolean blnNew = true;
ddlDocuments.Items.Clear();
ddlDocuments.Items.Add(new ListItem("No Document", "0"));
foreach(DataRow dr in DSDocuments.tbl_Documents.Rows)
{
if ((int) dr["DocumentCategoryID"] != DocumentCategoryID)
{
DocumentCategoryID = (int) dr["DocumentCategoryID"];
blnNew = true;
}
if (blnNew)
{
ddlDocuments.Items.Add(new ListItem("-- " + dr["DocumentCategoryName"] + " --", ""));
blnNew = false;
}
ddlDocuments.Items.Add(new ListItem(HttpUtility.HtmlDecode(" ") + dr["DocumentAlias"].ToString(), dr["DocumentID"].ToString()));
}
if (SelectedDocument != 0)
{
ddlDocuments.SelectedValue = SelectedDocument.ToString();
}
}
protected void BindAvailableDocuments()
{
BPDocuments bpu = new BPDocuments();
DSDocuments = new BEDocuments();
if (FilterID != -1)
{
DSDocuments.Merge(bpu.SelectAllByDocumentCategoryID(FilterID));
}
else
{
DSDocuments.Merge(bpu.SelectAllWithDocumentCategories());
}
int DocumentCategoryID = -1;
Boolean blnNew = true;
StringBuilder returnDocuments = new StringBuilder(10000);
returnDocuments.Append("none,No Document|");
foreach(DataRow dr in DSDocuments.tbl_Documents.Rows)
{
if ((int) dr["DocumentCategoryID"] != DocumentCategoryID)
{
DocumentCategoryID = (int) dr["DocumentCategoryID"];
blnNew = true;
}
if (blnNew)
{
returnDocuments.Append(",-- " + dr["DocumentCategoryName"] + " --|");
blnNew = false;
}
returnDocuments.Append(dr["DocumentID"].ToString() + "," + HttpUtility.HtmlDecode(" ") + dr["DocumentAlias"].ToString() + "|");
}
lblScript.Text = "<script Language=\"Javascript\">window.parent.handleResponse('" + returnDocuments + "', 'Document')</script>";
}
public BEDocuments SelectActiveAttachmentsByCompanyIDAndInventoryID(int CompanyID, int InventoryID)
{
DADocuments da = new DADocuments();
BEDocuments ds = new BEDocuments();
da.SelectActiveAttachmentsByCompanyIDAndInventoryID(CompanyID, InventoryID, ds.tbl_Documents);
return ds;
}
public void Update(BEDocuments ds)
{
DADocuments da = new DADocuments();
da.Update(ds.tbl_Documents);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.DSDocuments = new BEDocuments();
this.DSDocuments.BeginInit();
this.btnDocument.Click += new EventHandler(this.btnDocument_Click);
this.ddlDocumentCategories.SelectedIndexChanged += new EventHandler(this.ddlDocumentCategories_SelectedIndexChanged);
this.dgDocs.ItemCommand += new DataGridCommandEventHandler(this.dgDocs_ItemCommand);
//this.dgDocs.ItemDataBound += new DataGridItemEventHandler(dgDocs_ItemDataBound);
//
// DSDocuments
//
this.DSDocuments.DataSetName = "DSDocuments";
this.DSDocuments.Locale = new CultureInfo("en-US");
this.Load += new EventHandler(this.Page_Load);
this.DSDocuments.EndInit();
}
protected string GetDocumentName(object strDocumentID)
{
if (!Convert.IsDBNull(strDocumentID))
{
BEDocuments DSDocuments = new BEDocuments();
int documentID = Convert.ToInt32(strDocumentID);
BPDocuments bp = new BPDocuments();
DSDocuments = bp.SelectAll();
string DocumentName = DSDocuments.tbl_Documents.FindByDocumentID(documentID).DocumentName;
return "Uploads/" + DocumentName;
}
else
{
return "";
}
}
private void BindDSDocuments()
{
BPDocuments bp = new BPDocuments();
if (ddlDocumentCategories.SelectedValue == "-1")
{
DSDocuments = bp.SelectAllWithDocumentCategories();
}
else
{
DSDocuments = bp.SelectAllByDocumentCategoryID(Convert.ToInt32(ddlDocumentCategories.SelectedValue));
}
DSDocuments.tbl_Documents.DefaultView.Sort = "DocumentAlias";
DSDocuments.tbl_Documents.DefaultView.RowFilter = RowFilter("DocumentAlias", "DocumentActive");
letters_Bind();
dgDocs.DataBind();
SetPagerButtons();
if (DSDocuments.tbl_Documents.DefaultView.Count == 0)
{
lblError.Visible = true;
lblError.Text = "0 Records found.";
}
else
{
lblError.Visible = false;
lblError.Text = "";
}
}
protected void BindDocumentCategories()
{
ddlDocumentCategories.Attributes.Add("onchange", "callToServer(this.form.name, this.name, 'Document', '" + ddlDocuments.ClientID + "', 'DocumentLoader.aspx');");
//ddlDocumentCategories.Attributes.Add("onchange", "alert('hello');");
BPDocumentCategories bp = new BPDocumentCategories();
DSDocumentCategories = bp.SelectAllActive();
DSDocumentCategories.tbl_DocumentCategories.DefaultView.Sort = "DocumentCategoryName";
ddlDocumentCategories.DataSource = DSDocumentCategories.tbl_DocumentCategories.DefaultView;
ddlDocumentCategories.DataValueField = DSDocumentCategories.tbl_DocumentCategories.DocumentCategoryIDColumn.ColumnName;
ddlDocumentCategories.DataTextField = DSDocumentCategories.tbl_DocumentCategories.DocumentCategoryNameColumn.ColumnName;
ddlDocumentCategories.DataBind();
ddlDocumentCategories.Items.Insert(0, new ListItem("(All Document Categories)", "-1"));
}
private bool SaveDocumentInfo()
{
bool isNew = false;
bool updateExisting = false;
string strFileName = null;
BPDocuments bp = new BPDocuments();
BEDocuments ds = new BEDocuments();
if (DocumentID > 0)
{
if (inpUpload.PostedFile.FileName == "")
updateExisting = true;
}
else
isNew = true;
if (!updateExisting)
strFileName = UploadFunctions.UploadFile(inpUpload.PostedFile, Server.MapPath(ConfigurationManager.AppSettings["UploadsPath"]), UploadTypes.Document);
if (strFileName != null || updateExisting)
{
BEDocuments.tbl_DocumentsRow doc;
if (isNew)
doc = ds.tbl_Documents.Newtbl_DocumentsRow();
else
{
ds = bp.SelectByID(DocumentID);
doc = ds.tbl_Documents.FindByDocumentID(DocumentID);
}
doc.DocumentCategoryID = Convert.ToInt32(ddlDocumentCategories.SelectedValue);
if (!updateExisting)
doc.DocumentName = strFileName;
doc.DocumentAlias = txtDocumentAlias.Text;
if (txtDocumentDescription.Text.Trim() != "")
doc.DocumentDescription = txtDocumentDescription.Text;
else
doc.SetDocumentDescriptionNull();
string path = ConfigurationManager.AppSettings["UploadsPath"];
if (File.Exists(Server.MapPath(path + doc.DocumentName)))
{
FileInfo file = new FileInfo(Server.MapPath(path + doc.DocumentName));
doc.DocumentSize = file.Length;
}
else
doc.DocumentSize = 0;
doc.DocumentActive = chkDocumentActive.Checked;
doc.DateModified = DateTime.Now;
doc.ModifiedByAdminID = PageUserID;
if (isNew)
{
doc.DateCreated = DateTime.Now;
ds.tbl_Documents.Addtbl_DocumentsRow(doc);
}
bp.Update(ds);
return true;
}
else
return false;
}
public void Update(BEDocuments ds)
{
DADocumentInventoryItems da = new DADocumentInventoryItems();
da.Update(ds.tbl_DocumentInventoryItems);
}