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