public BEArchive SelectAllInactive()
{
BEArchive ds = new BEArchive();
DAArchive da = new DAArchive();
da.SelectAllInactive(ds.tbl_Archive);
return ds;
}
public BEArchive SelectActiveByArchiveTypeID(int ArchiveTypeID)
{
BEArchive ds = new BEArchive();
DAArchive da = new DAArchive();
da.SelectActiveByArchiveTypeID(ArchiveTypeID, ds.tbl_Archive);
return ds;
}
public BEArchive SelectActiveByIDWithROColumns(int archiveID)
{
BEArchive ds = new BEArchive();
DAArchive da = new DAArchive();
da.SelectActiveByIDWithROColumns(archiveID, ds.tbl_Archive);
return ds;
}
public BEArchive SelectByID(int archiveID)
{
BEArchive ds = new BEArchive();
DAArchive da = new DAArchive();
da.SelectByID(archiveID.ToString(), ds.tbl_Archive);
return ds;
}
private DataView GetData()
{
BPArchive bp = new BPArchive();
DSArchive = bp.SelectByArchiveTypeID(ArchiveTypeID);
DSArchive.tbl_Archive.DefaultView.Sort = DSArchive.tbl_Archive.ArchiveDateColumn.ColumnName + " desc";
DSArchive.tbl_Archive.DefaultView.RowFilter = RowFilter("ArchiveTitle", ((LinkButton)rptLetters.Items[0].FindControl("lnkLetter")).CommandName, "ArchiveActive", lstActive.SelectedValue);
return DSArchive.tbl_Archive.DefaultView;
}
private void BindTitle()
{
BPArchiveTypes bp = new BPArchiveTypes();
DSArchive = bp.SelectArchiveTypeByID(ArchiveTypeID);
if (DSArchive.tbl_ArchiveTypes.Count > 0)
{
BEArchive.tbl_ArchiveTypesRow typeRow = DSArchive.tbl_ArchiveTypes[0];
lblTitle.Text = "Browse " + typeRow.ArchiveTypeName + "s";
btnAdd.Text = "Add New";
}
}
public BEArchive SelectActiveFRByArchiveTypeIDWithROColumns(int ArchiveTypeID)
{
BEArchive ds = new BEArchive();
DAArchive da = new DAArchive();
da.SelectActiveFRByArchiveTypeIDWithROColumns(ArchiveTypeID, ds.tbl_Archive);
return ds;
}
public void Update(BEArchive ds)
{
DAArchive da = new DAArchive();
da.Update(ds.tbl_Archive);
}
public BEArchive SelectRecentArchiveItemsWithROColumns()
{
BEArchive ds = new BEArchive();
DAArchive da = new DAArchive();
da.SelectRecentArchiveItemsWithROColumns(ds.tbl_Archive);
return ds;
}
private void SaveArchiveInfo()
{
bool isNew = false;
BPArchive bp = new BPArchive();
BEArchive dsArchive = new BEArchive();
BEArchive.tbl_ArchiveRow Archive = null;
if (ArchiveID > 0)
{
dsArchive = bp.SelectByID(ArchiveID);
Archive = dsArchive.tbl_Archive.FindByArchiveID(ArchiveID);
}
if (Archive == null)
{
Archive = dsArchive.tbl_Archive.Newtbl_ArchiveRow();
isNew = true;
}
Archive.ArchiveTitle = txtArchiveTitle.Text.Trim();
if (txtArchiveTitleFR.Text.Trim() != "")
Archive.ArchiveTitleFR = txtArchiveTitleFR.Text.Trim();
else
Archive.SetArchiveTitleFRNull();
if (dtArchiveDate.Date != dtArchiveDate.MinDate)
Archive.ArchiveDate = dtArchiveDate.Date;
else
Archive.SetArchiveDateNull();
if (txtArchiveDescription.Text.Trim() != "")
Archive.ArchiveDescription = txtArchiveDescription.Text.Trim();
else
Archive.SetArchiveDescriptionNull();
if (txtArchiveDescriptionFR.Text.Trim() != "")
Archive.ArchiveDescriptionFR = txtArchiveDescriptionFR.Text.Trim();
else
Archive.SetArchiveDescriptionFRNull();
if (docArchiveDocument.SelectedDocument > 0)
Archive.ArchiveDocumentID = docArchiveDocument.SelectedDocument;
else
Archive.SetArchiveDocumentIDNull();
if (docArchiveDocumentFR.SelectedDocument > 0)
Archive.ArchiveDocumentIDFR = docArchiveDocumentFR.SelectedDocument;
else
Archive.SetArchiveDocumentIDFRNull();
if (chkArchiveActive.Checked)
{
Archive.ArchiveActive = true;
}
else
{
Archive.ArchiveActive = false;
}
Archive.ArchiveActiveFR = chkArchiveActiveFR.Checked;
Archive.DateModified = DateTime.Now;
Archive.ModifiedByAdminID = Convert.ToInt32(PageUserID);
if (isNew)
{
Archive.ArchiveTypeID = ArchiveTypeID;
Archive.DateCreated = DateTime.Now;
dsArchive.tbl_Archive.Addtbl_ArchiveRow(Archive);
}
bp.Update(dsArchive);
//ArchiveID = Archive.ArchiveID;
//SaveLinkInfo(isNew);
}
