private void TreeChildChange(int SubjectID) { try { //DataTable dt = BINROTA.BUS.Pages.GetPageForExistanceControl(SessRoot.UserID, SubjectID, (int)Enumerations.PageType.TravelPage); DataTable dt = BINROTA.BUS.Pages.GetPageForExistanceControl(SubjectID);//SubjectID aslýnda PageID if (dt.Rows.Count > 0) { DataTable dtCategories = new DataTable(); int PageID = int.Parse(dt.Rows[0]["PageID"].ToString()); ((DropDownList)UctrlPageContent1.FindControl("drpPageCategory")).SelectedValue = dt.Rows[0]["PageCategoryID"].ToString(); ((TextBox)UctrlPageContent1.FindControl("txtTitle")).Text = dt.Rows[0]["Title"].ToString(); UctrlPageContent1.ContentText = dt.Rows[0]["PageContent"].ToString(); DateTime TravelDate = DateTime.Parse(dt.Rows[0]["ModifyDate"].ToString()); UctrlPageContent1.ContentYear = TravelDate.Year; UctrlPageContent1.ContentMonth = TravelDate.Month; UctrlPageContent1.ContentDay = TravelDate.Day; dtCategories = BINROTA.BUS.Categories.GetCategories(); if (dtCategories.Rows.Count > 0) { for (int i = 0; i < dtCategories.Rows.Count; i++) { int CategoryID = int.Parse(dtCategories.Rows[i]["CategoryID"].ToString()); UctrlPageCategories1.SetCategoryContent(CategoryID, (BINROTA.BUS.Pages.GetPageForExistanceControl(PageID, CategoryID).Rows[0]["PageContent"]).ToString()); } } } } catch (Exception) { } }
protected void rptPages_ItemCommand(object source, RepeaterCommandEventArgs e) { if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem)) { int PageID = int.Parse(e.CommandArgument.ToString()); //SetComments(PageID); DataTable dt = BINROTA.BUS.Pages.GetPageForExistanceControl(PageID); if (dt.Rows.Count > 0) { UctrlPageContent1.ContentText = dt.Rows[0]["PageContent"].ToString(); UctrlPageContent1.Title = dt.Rows[0]["Title"].ToString(); DateTime TravelDate = DateTime.Parse(dt.Rows[0]["TravelDate"].ToString()); UctrlPageContent1.ContentDay = int.Parse(TravelDate.Day.ToString()); UctrlPageContent1.ContentMonth = int.Parse(TravelDate.Month.ToString()); UctrlPageContent1.ContentYear = int.Parse(TravelDate.Year.ToString()); UctrlPageContent1.ContentCategory = int.Parse(dt.Rows[0]["PageCategoryID"].ToString()); } DataTable dtCategories = BINROTA.BUS.Categories.GetCategories(); UctrlPageCategories1.BindCategories(); foreach (DataRow dr in dtCategories.Rows) { dt = BINROTA.BUS.Pages.GetPageForExistanceControl(PageID, int.Parse(dr["CategoryID"].ToString())); foreach (DataRow dr1 in dt.Rows) { UctrlPageCategories1.SetCategoryContent(int.Parse(dr1["CategoryID"].ToString()), dr1["PageContent"].ToString()); } } } }
private void FillForm() { DDLHelper.BindDDL(ref drpPageCategory, BINROTA.BUS.PageCategories.GetPageCategoriesAll(), "PageCategoryName", "PageCategoryID", ""); DDLHelper.BindDDL(ref drpContinent, BINROTA.BUS.Subjects.GetSubjectByParentSubjectID(0), "Name", "SubjectID", ""); DataTable dt = BINROTA.BUS.Pages.GetPageForExistanceControl(PageID); if (dt.Rows.Count > 0) { if (SessRoot.UserID == Convert.ToInt32(dt.Rows[0]["MemberID"])) { ftbPageContent.Text = dt.Rows[0]["PageContent"].ToString(); txtTitle.Text = dt.Rows[0]["Title"].ToString(); DateTime travelDate = Convert.ToDateTime(dt.Rows[0]["TravelDate"]); drpDay.SelectedValue = travelDate.Day.ToString(); drpMonth.SelectedValue = travelDate.Month.ToString(); drpYear.SelectedValue = travelDate.Year.ToString(); drpPageCategory.SelectedValue = dt.Rows[0]["PageCategoryID"].ToString(); BindDLLBySubjectID(int.Parse(dt.Rows[0]["SubjectID"].ToString())); } else { Response.Write("<script language='javascript'> { window.close();}</script>"); Response.End(); } } else { Response.Write("<script language='javascript'> { window.close();}</script>"); Response.End(); } DataTable dtCategories = BINROTA.BUS.Categories.GetCategories(); foreach (DataRow dr in dtCategories.Rows) { dt = BINROTA.BUS.Pages.GetPageForExistanceControl(PageID, int.Parse(dr["CategoryID"].ToString())); foreach (DataRow dr1 in dt.Rows) { UctrlPageCategories1.SetCategoryContent(int.Parse(dr1["CategoryID"].ToString()), dr1["PageContent"].ToString()); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (SessRoot != null) { DDLHelper.LoadNumberDDL(ref drpDay, 31); DDLHelper.LoadNumberDDL(ref drpMonth, 12); DDLHelper.LoadNumberDDL(ref drpYear, DateTime.Today.Year, 1, 1920); UctrlPageCategories1.BindCategories(); if (Request.QueryString["PageID"] == "0" || Request.QueryString["PageID"] == null) { if (Request.QueryString["SubjectID"] != null) { if (Util.IsNumeric(Request.QueryString["SubjectID"])) { this.SubjectID = int.Parse(Request.QueryString["SubjectID"].ToString()); } } this.SaveMode = Enumerations.SaveMode.Insert; BindDDL(); } else { if (Util.IsNumeric(Request.QueryString["PageID"])) { this.PageID = int.Parse(Request.QueryString["PageID"]); this.SaveMode = Enumerations.SaveMode.Update; FillForm(); } else { Response.Write("<script language='javascript'> { window.close();}</script>"); } } } else { BINROTA.COM.Common.GotoDefaultPage(this.Response); } } }
protected void btnUpdate_Click(object sender, EventArgs e) { DataTable dt = BINROTA.BUS.Pages.GetPageForExistanceControl(UctrlPageTree1.SelectedSubjectID); if (dt.Rows.Count > 0) { DateTime TravelDate = new DateTime(UctrlPageContent1.ContentYear, UctrlPageContent1.ContentMonth, UctrlPageContent1.ContentDay); BINROTA.BUS.Pages.PagesUpdate(int.Parse(dt.Rows[0]["PageID"].ToString()), int.Parse(dt.Rows[0]["SubjectID"].ToString()), int.Parse(((DropDownList)UctrlPageContent1.FindControl("drpPageCategory")).SelectedValue), ((TextBox)(UctrlPageContent1.FindControl("txtTitle"))).Text, UctrlPageContent1.ContentText, TravelDate, "PhotoPathKonulacak", "PhotoCaptionKonulacak", DateTime.Now, SessRoot.UserID, UctrlPageCategories1.GetCategoryContentsHT()); PopulateRepeater(); } }
private void ClearForm() { txtTitle.Text = ""; ftbPageContent.Text = ""; UctrlPageCategories1.ClearForm(); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (isDateValid(drpDay.SelectedValue + "." + drpMonth.SelectedValue + "." + drpYear.SelectedValue)) { DateTime TravelDate = new DateTime(int.Parse(drpYear.SelectedValue), int.Parse(drpMonth.SelectedValue), int.Parse(drpDay.SelectedValue)); if (txtTitle.Text != "" && ftbPageContent.Text != "") { try { if (this.SaveMode == Enumerations.SaveMode.Insert) { if (drpCity.SelectedValue == "0") { BINROTA.BUS.Pages.PagesInsert( SessRoot.UserID, int.Parse(drpCountry.SelectedValue), (int)Enumerations.PageType.TravelPage, int.Parse(drpPageCategory.SelectedValue), txtTitle.Text, ftbPageContent.Text, TravelDate, "PhotoPathKonulacak", "PhotoCaptionKonulacak", 0, DateTime.Now, SessRoot.UserID, UctrlPageCategories1.GetCategoryContents()); } else { BINROTA.BUS.Pages.PagesInsert( SessRoot.UserID, int.Parse(drpCity.SelectedValue), (int)Enumerations.PageType.TravelPage, int.Parse(drpPageCategory.SelectedValue), txtTitle.Text, ftbPageContent.Text, TravelDate, "PhotoPathKonulacak", "PhotoCaptionKonulacak", 0, DateTime.Now, SessRoot.UserID, UctrlPageCategories1.GetCategoryContents()); } ftbPageContent.Text = ""; txtTitle.Text = ""; //UctrlPageCategories1.ClearTextBoxes(); //lbMessage.Text = "Gezi yazýsý baþarýyla eklenmiþtir"; } else if (this.SaveMode == Enumerations.SaveMode.Update) { if (drpCity.SelectedValue == "0") { BINROTA.BUS.Pages.PagesUpdate(this.PageID, int.Parse(drpCountry.SelectedValue), int.Parse(drpPageCategory.SelectedValue), txtTitle.Text, ftbPageContent.Text, TravelDate, "PhotoPathKonulacak", "PhotoCaptionKonulacak", DateTime.Now, SessRoot.UserID, UctrlPageCategories1.GetCategoryContentsHT()); } else { BINROTA.BUS.Pages.PagesUpdate(this.PageID, int.Parse(drpCity.SelectedValue), int.Parse(drpPageCategory.SelectedValue), txtTitle.Text, ftbPageContent.Text, TravelDate, "PhotoPathKonulacak", "PhotoCaptionKonulacak", DateTime.Now, SessRoot.UserID, UctrlPageCategories1.GetCategoryContentsHT()); } } //lbMessage.Text = "Yazýnýz baþarýyla kaydedilmiþtir. Teþekkür ederiz"; UctrlPageCategories1.ClearForm(); } catch (Exception) { Response.Redirect("Result.aspx?Message=Yazý girilirken bir hata oluþtu. Lütfen tekrar deneyin"); throw; } Response.Write("<script>window.opener.location.reload()</script>"); Response.Redirect("Result.aspx?Message=Yazýnýz baþarýyla kaydedilmiþtir. Teþekkür ederiz"); //pnlMessage.Visible = true; //pnlPageContent.Visible = false; //pnlButtons.Visible = false; } } else { Response.Redirect("Result.aspx?Message=Girmiþ olduðunuz tarih geçerli bir tarih deðildir. Lütfen doðru bir tarih giriniz."); } }