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); }