protected void GVLibrary_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("AddToFavorite"))
{
LinkButton lnkBtnFavorite = (LinkButton)e.CommandSource;
Entity.UserInfo oUserInfo = new Entity.UserInfo();
oUserInfo.IntFavoriteTypeId = 0;
oUserInfo.IntFavoriteId = 0;
if (lnkBtnFavorite.Text == "Remove from Favorite")
oUserInfo.IntFavoriteId = Convert.ToInt32(e.CommandArgument);
oUserInfo.StrUserId = AppLib.GetLoggedInUserName();
oUserInfo.StrTitle = "";
oUserInfo.StrFavoriteType = "Library";
oUserInfo.DtCreatedOn = DateTime.Now;
oUserInfo.IntFavoriteTypeId = Convert.ToInt32(e.CommandArgument);
BLL.UserLib oUserLib = new BLL.UserLib();
oUserLib.LibraryAddToFavorite(oUserInfo);
oUserInfo = null;
oUserLib = null;
BindLibrary();
}
else if (e.CommandName.Equals("PathViewlabrariesFile"))
{
Entity.LibraryInfo oLibraryInfo = new Entity.LibraryInfo();
BLL.LibraryLib oLibraryLib = new BLL.LibraryLib();
oLibraryInfo = oLibraryLib.GetLibraryByLibraryId(Convert.ToInt32(e.CommandArgument));
if (oLibraryInfo.StrLocationType.ToLower().Equals("pdf") || oLibraryInfo.StrLocationType.ToLower().Equals("video"))
{
GridViewRow row = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
LinkButton lnkNewslettes = (LinkButton)row.FindControl("lnkViewLabraries");
string path = AppConfig.GetBaseSiteUrl() + AppConfig.GetLibrariesFilePath() + oLibraryInfo.StrLocation;
Response.Write("<script type='text/javascript'>detailedresults=window.open('" + path + "', 'popUpWindow', 'height=700,width=900,resizable=yes,scrollbars=yes,toolbar=yes,menubar=no,location=no,directories=no, status=yes');</script>");
}
else
{
}
}
}
private void AddUpdateLibraryDetails()
{
BLL.LibraryLib oLibraryLib = new BLL.LibraryLib();
Entity.LibraryInfo oLibraryInfo = new Entity.LibraryInfo();
oLibraryInfo.IntLibraryId = 0;
oLibraryInfo.ChrIsDeleted = 'N';
oLibraryInfo.DtDeletedDate = DateTime.Now;
oLibraryInfo.DtCreatedDate = DateTime.Now;
oLibraryInfo.DtModifiedDate = oLibraryInfo.DtCreatedDate;
oLibraryInfo.StrTitle = txttitle.Text.Trim();
oLibraryInfo.StrDescription = txtDescription.Text.Trim();
if (oLibraryInfo.StrDescription.Length > 500)
oLibraryInfo.StrDescription = oLibraryInfo.StrDescription.Substring(0, 499);
if (!txtDate.Text.Equals(string.Empty))
oLibraryInfo.DtLibraryDate = Convert.ToDateTime(txtDate.Text);
else
oLibraryInfo.DtLibraryDate = Convert.ToDateTime("01/01/1999");
oLibraryInfo.ChrIsActive = chkIsActive.Checked ? 'Y' : 'N';
oLibraryInfo.StrLocationType = ddlCategoryType.SelectedItem.Text;
oLibraryInfo.StrCategory = ddlCategory.SelectedItem.Text;
oLibraryInfo.StrLocation = string.Empty;
if (ViewState["strOldFileName"] != null)
oLibraryInfo.StrLocation = ViewState["strOldFileName"].ToString();
if (oLibraryInfo.StrLocationType.ToString().ToLower().Equals("pdf") || oLibraryInfo.StrLocationType.ToString().ToLower().Equals("video"))
{
string strpath = string.Empty;
try
{
if (fupPDF.HasFile)
{
strpath = Request.PhysicalApplicationPath + AppConfig.GetLibrariesFilePath();
if (ViewState["strOldFileName"] != null)
{
if (System.IO.File.Exists(strpath + ViewState["strOldFileName"]))
System.IO.File.Delete(strpath + ViewState["strOldFileName"]);
}
string strFileName = DateTime.Now.ToString("MMddyyyyHHmmss");
strFileName = AppLib.UploadCompanyExcelForUserRegRequest(ref fupPDF, strFileName, strpath);
oLibraryInfo.StrLocation = strFileName;
}
}
catch
{
}
}
else
oLibraryInfo.StrLocation = txtLink.Text.Trim();
bool blnIsSuccessfullOperation = false;
if (ViewState["intLibraryId"] != null)
{
oLibraryInfo.IntLibraryId = Convert.ToInt32(ViewState["intLibraryId"]);
if (oLibraryLib.UpdateLibraryDetails(oLibraryInfo) > 0)
{
lblMsg.Text = "Library has been updated successfully.";
ViewState["intLibraryId"] = null;
ViewState["strOldFileName"] = null;
blnIsSuccessfullOperation = true;
}
else
lblMsg.Text = "Library already exists.";
}
else
{
if (oLibraryLib.SaveLibraryDetails(oLibraryInfo) > 0)
{
lblMsg.Text = "Library has been added successfully.";
blnIsSuccessfullOperation = true;
}
else
lblMsg.Text = "Library already exists.";
}
oLibraryInfo = null;
oLibraryLib = null;
if (blnIsSuccessfullOperation)
{
ClearControls();
BindLibrary();
}
}
private void BindDetails()
{
if (Request.QueryString["type"] != null && Request.QueryString["id"] != null && Request.QueryString["fid"] != null)
{
BLL.NewsLib oNewsLib = new BLL.NewsLib();
Entity.NewsInfo oNewsInfo = new Entity.NewsInfo();
if (Request.QueryString["type"].ToString().ToLower().Equals("newsletter"))
{
trNewsletter.Visible = true;
oNewsInfo = new Entity.NewsInfo();
oNewsLib = new BLL.NewsLib();
oNewsInfo = oNewsLib.GetNewsLettersById(Convert.ToInt32(Request.QueryString["id"]));
if (oNewsInfo != null)
{
lblNewsletterDescription.Text = oNewsInfo.StrDescription;
if (!oNewsInfo.StrNewsletterDate.ToString().Equals("1/1/1999 12:00:00 AM"))
lblNewsletterDate.Text = oNewsInfo.StrNewsletterDate.ToShortDateString();
if (!oNewsInfo.StrPDFFilename.Equals("na.pdf"))
{
ancPrevious.Visible = true;
ancPrevious.HRef = AppConfig.GetBaseSiteUrl() + AppConfig.GetNewsLettersPDFPath() + oNewsInfo.StrPDFFilename;
}
else
{
trNewsletterPDF.Visible = false;
}
}
}
else if (Request.QueryString["type"].ToString().ToLower().Equals("event"))
{
trEvent.Visible = true;
if (Request.QueryString["id"] != null)
{
int _intEventId = 0;
_intEventId = Convert.ToInt32(Request.QueryString["id"]);
Entity.EventInfo oEventInfo = new Entity.EventInfo();
BLL.EventsLib oEventsLib = new BLL.EventsLib();
oEventInfo = oEventsLib.GetEventByEventId(_intEventId);
if (oEventInfo != null)
{
lblEventActivity.Text = oEventInfo.StrActivity;
lblEventComments.Text = oEventInfo.StrComments;
lblEventDate.Text = oEventInfo.DtEventDate.ToShortDateString();
lblEventLocation.Text = oEventInfo.StrLocation;
}
oEventsLib = null;
oEventInfo = null;
}
}
else if (Request.QueryString["type"].ToString().ToLower().Equals("newsannouncements"))
{
trNewsAnnouncement.Visible = true;
oNewsInfo = new Entity.NewsInfo();
oNewsLib = new BLL.NewsLib();
oNewsInfo = oNewsLib.GetNewsAnnouncementsById(Convert.ToInt32(Request.QueryString["id"]));
if (oNewsInfo != null)
{
lblNewsAnnouncementDescription.Text = oNewsInfo.StrDescription;
lblNewsAnnouncementDirectLink.Text = oNewsInfo.StrDirectLink;
if (lblNewsAnnouncementDirectLink.Text.Trim().Equals(string.Empty))
{
trNewsAnnouncementDirectLink.Visible = false;
trNewsAnnouncementPDF.Visible = true;
ancPreviousNewsAnnoucment.HRef = AppConfig.GetBaseSiteUrl() + AppConfig.GetNewsAnnouncementsPDFPath() + oNewsInfo.StrPDFFilename;
}
else
{
trNewsAnnouncementDirectLink.Visible = true;
trNewsAnnouncementPDF.Visible = false;
}
oNewsInfo = null;
oNewsLib = null;
}
}
else if (Request.QueryString["type"].ToString().ToLower().Equals("library"))
{
trLibrary.Visible = true;
Entity.LibraryInfo oLibraryInfo = new Entity.LibraryInfo();
BLL.LibraryLib oLibraryLib = new BLL.LibraryLib();
oLibraryInfo = oLibraryLib.GetLibraryByLibraryId(Convert.ToInt32(Request.QueryString["id"]));
if (oLibraryInfo != null)
{
lblLibraryDescription.Text = oLibraryInfo.StrDescription;
if (!oLibraryInfo.DtLibraryDate.ToString().Equals("1/1/1999 12:00:00 AM"))
lblLibraryDate.Text = oLibraryInfo.DtLibraryDate.ToShortDateString();
if (oLibraryInfo.StrLocationType.ToLower().Equals("pdf") || oLibraryInfo.StrLocationType.ToLower().Equals("video"))
{
trLibraryLink.Visible = false;
ancLibraryPDF.Visible = true;
ancLibraryPDF.HRef = AppConfig.GetBaseSiteUrl() + AppConfig.GetLibrariesFilePath() + oLibraryInfo.StrLocation;
}
else
{
trLibraryPDF.Visible = false;
lblLibraryWebsiteLink.Text = oLibraryInfo.StrLocation;
}
lblLibraryCategoryType.Text = oLibraryInfo.StrLocationType;
lblLibraryCategory.Text = oLibraryInfo.StrCategory;
oLibraryInfo = null;
oLibraryLib = null;
}
}
}
}
protected void GVNews_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("EditNews"))
{
Entity.LibraryInfo oLibraryInfo = new Entity.LibraryInfo();
BLL.LibraryLib oLibraryLib = new BLL.LibraryLib();
oLibraryInfo = oLibraryLib.GetLibraryByLibraryId(Convert.ToInt32(e.CommandArgument));
if (oLibraryInfo != null)
{
// if (!odataReader.DtCancelOn.ToString().Equals("1/1/1999 12:00:00 AM"))
txttitle.Text = oLibraryInfo.StrTitle;
txtDescription.Text = oLibraryInfo.StrDescription;
if (!oLibraryInfo.DtLibraryDate.ToString().Equals("1/1/1999 12:00:00 AM"))
txtDate.Text = oLibraryInfo.DtLibraryDate.ToShortDateString();
chkIsActive.Checked = oLibraryInfo.ChrIsActive.Equals('Y') ? true : false;
ViewState["strOldFileName"] = oLibraryInfo.StrLocation;
if (oLibraryInfo.StrLocationType.ToLower().Equals("pdf") || oLibraryInfo.StrLocationType.ToLower().Equals("video"))
{
trLink.Style.Add("display", "none");
trFileUpload.Style.Add("display", "''");
ancPrevious.Visible = true;
ancPrevious.HRef = AppConfig.GetBaseSiteUrl() + AppConfig.GetLibrariesFilePath() + oLibraryInfo.StrLocation;
}
else
{
txtLink.Text = oLibraryInfo.StrLocation;
trLink.Style.Add("display", "''");
trFileUpload.Style.Add("display", "none");
}
ddlCategoryType.SelectedIndex = ddlCategoryType.Items.IndexOf(ddlCategoryType.Items.FindByValue(oLibraryInfo.StrLocationType));
ddlCategory.SelectedIndex = ddlCategory.Items.IndexOf(ddlCategory.Items.FindByValue(oLibraryInfo.StrCategory));
lnkBtnSearch.Text = "Update";
ViewState["intLibraryId"] = e.CommandArgument.ToString();
oLibraryInfo = null;
oLibraryLib = null;
}
}
else if (e.CommandName.Equals("DeleteNews"))
{
BLL.LibraryLib oLibraryLib = new BLL.LibraryLib();
oLibraryLib.DeleteLibraryDetails(Convert.ToInt32(e.CommandArgument));
lblMsg.Text = "Library has been deleted successfully.";
oLibraryLib = null;
ClearControls();
BindLibrary();
}
else if (e.CommandName.Equals("StatusChanged"))
{
BLL.LibraryLib oLibraryLib = new BLL.LibraryLib();
oLibraryLib.ActivateDeactivateLibrary(Convert.ToInt32(e.CommandArgument));
lblMsg.Text = "Library status has been changed successfully.";
oLibraryLib = null;
ClearControls();
BindLibrary();
}
}