protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Settings"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } switch (Request.QueryString["Mode"]) { case "Styles": { PanelStyles.Visible = true; Page.Title = "Salestan : تغییر فایل استایل"; string inputString; using (StreamReader streamReader = File.OpenText(Server.MapPath("~") + @"\Styles\Styles.css")) { inputString = streamReader.ReadLine(); while (inputString != null) { TextBoxStyles.Text += inputString; inputString = streamReader.ReadLine(); } } break; } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Admins"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } //Page Title string[] siteInformation = new string[] { }; SiteInformation si = new SiteInformation(); siteInformation = si.getInformation(); Page.Title = siteInformation[0] + " : مدیریت ادمین ها"; //insert log if (!IsPostBack) { AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1100, 0, "0"); } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Credit"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } switch (Request.QueryString["Mode"]) { case "Log": { PanelLog.Visible = true; Page.Title = "Salestan : تغییر اختیارات ادمین"; break; } case "UserLog": { PanelUserLog.Visible = true; Page.Title = "Salestan : فایل لاگ ادمین"; break; } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Credit"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } switch (Request.QueryString["Mode"]) { case "Log": { PanelLog.Visible = true; Page.Title = "Salestan : تغییر اختیارات ادمین"; break; } case "UserLog": { PanelUserLog.Visible = true; Page.Title = "Salestan : فایل لاگ ادمین"; break; } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Settings"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } switch (Request.QueryString["Mode"]) { case "Styles": { PanelStyles.Visible = true; Page.Title = "Salestan : تغییر فایل استایل"; string inputString; using (StreamReader streamReader = File.OpenText(Server.MapPath("~") + @"\Styles\Styles.css")) { inputString = streamReader.ReadLine(); while (inputString != null) { TextBoxStyles.Text += inputString; inputString = streamReader.ReadLine(); } } break; } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Ads"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } //insert log if (!IsPostBack) { AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1200, 0, "0"); } if (!IsPostBack) { DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_ads", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.Fill(ds); dt = ds.Tables[0]; //Top CheckBoxTop.Checked = Convert.ToBoolean(dt.Rows[0]["Active"].ToString()); TextBoxTopLink.Text = dt.Rows[0]["Link"].ToString(); TextBoxTopImage.Text = dt.Rows[0]["Image"].ToString(); //Bottom CheckBoxBottom.Checked = Convert.ToBoolean(dt.Rows[1]["Active"].ToString()); TextBoxBottomLink.Text = dt.Rows[1]["Link"].ToString(); TextBoxBottomImage.Text = dt.Rows[1]["Image"].ToString(); //Fold CheckBoxFold.Checked = Convert.ToBoolean(dt.Rows[2]["Active"].ToString()); TextBoxFoldLink.Text = dt.Rows[2]["Link"].ToString(); TextBoxFoldImage.Text = dt.Rows[2]["Image"].ToString(); //Offers CheckBoxOffers.Checked = Convert.ToBoolean(dt.Rows[3]["Active"].ToString()); TextBoxOffersLink.Text = dt.Rows[3]["Link"].ToString(); TextBoxOffersImage.Text = dt.Rows[3]["Image"].ToString(); //Coupons CheckBoxCoupons.Checked = Convert.ToBoolean(dt.Rows[4]["Active"].ToString()); TextBoxCouponsLink.Text = dt.Rows[4]["Link"].ToString(); TextBoxCouponsImage.Text = dt.Rows[4]["Image"].ToString(); //Login CheckBoxLogin.Checked = Convert.ToBoolean(dt.Rows[5]["Active"].ToString()); TextBoxLoginLink.Text = dt.Rows[5]["Link"].ToString(); TextBoxLoginImage.Text = dt.Rows[5]["Image"].ToString(); sda.Dispose(); sqlConn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Ads"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } //insert log if (!IsPostBack) { AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1200, 0, "0"); } if (!IsPostBack) { DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_ads", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.Fill(ds); dt = ds.Tables[0]; //Top CheckBoxTop.Checked = Convert.ToBoolean(dt.Rows[0]["Active"].ToString()); TextBoxTopLink.Text = dt.Rows[0]["Link"].ToString(); TextBoxTopImage.Text = dt.Rows[0]["Image"].ToString(); //Bottom CheckBoxBottom.Checked = Convert.ToBoolean(dt.Rows[1]["Active"].ToString()); TextBoxBottomLink.Text = dt.Rows[1]["Link"].ToString(); TextBoxBottomImage.Text = dt.Rows[1]["Image"].ToString(); //Fold CheckBoxFold.Checked = Convert.ToBoolean(dt.Rows[2]["Active"].ToString()); TextBoxFoldLink.Text = dt.Rows[2]["Link"].ToString(); TextBoxFoldImage.Text = dt.Rows[2]["Image"].ToString(); //Offers CheckBoxOffers.Checked = Convert.ToBoolean(dt.Rows[3]["Active"].ToString()); TextBoxOffersLink.Text = dt.Rows[3]["Link"].ToString(); TextBoxOffersImage.Text = dt.Rows[3]["Image"].ToString(); //Coupons CheckBoxCoupons.Checked = Convert.ToBoolean(dt.Rows[4]["Active"].ToString()); TextBoxCouponsLink.Text = dt.Rows[4]["Link"].ToString(); TextBoxCouponsImage.Text = dt.Rows[4]["Image"].ToString(); //Login CheckBoxLogin.Checked = Convert.ToBoolean(dt.Rows[5]["Active"].ToString()); TextBoxLoginLink.Text = dt.Rows[5]["Link"].ToString(); TextBoxLoginImage.Text = dt.Rows[5]["Image"].ToString(); sda.Dispose(); sqlConn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Stats"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Blog"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } if (!IsPostBack) { switch (Request.QueryString["Mode"]) { case "Edit": { PanelEdit.Visible = true; Page.Title = "Salestan : بلاگ"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_blogInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@BlogId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["BlogId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //news doesn't exist { //LabelName.Text = "خبری با این شناسه موجود نمی باشد!"; } else //news exists { TimeClass tc = new TimeClass(); LabelDate.Text = tc.ConvertToIranTimeString(Convert.ToDateTime(dt.Rows[0]["SubmitDate"].ToString())); TextBoxTitle.Text = dt.Rows[0]["Title"].ToString(); TextBoxBrief.Text = dt.Rows[0]["Brief"].ToString(); TextBoxBody.Text = dt.Rows[0]["Body"].ToString(); TextBoxPhotoLink.Text = dt.Rows[0]["PhotoLink"].ToString(); //Location DropDownListLanguage.SelectedValue = dt.Rows[0]["Language"].ToString(); } sda.Dispose(); sqlConn.Close(); break; } } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Blog"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } if (!IsPostBack) { switch (Request.QueryString["Mode"]) { case "Edit": { PanelEdit.Visible = true; Page.Title = "Salestan : بلاگ"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_blogInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@BlogId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["BlogId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //news doesn't exist { //LabelName.Text = "خبری با این شناسه موجود نمی باشد!"; } else //news exists { TimeClass tc = new TimeClass(); LabelDate.Text = tc.ConvertToIranTimeString(Convert.ToDateTime(dt.Rows[0]["SubmitDate"].ToString())); TextBoxTitle.Text = dt.Rows[0]["Title"].ToString(); TextBoxBrief.Text = dt.Rows[0]["Brief"].ToString(); TextBoxBody.Text = dt.Rows[0]["Body"].ToString(); TextBoxPhotoLink.Text = dt.Rows[0]["PhotoLink"].ToString(); //Location DropDownListLanguage.SelectedValue = dt.Rows[0]["Language"].ToString(); } sda.Dispose(); sqlConn.Close(); break; } } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Support"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Newsletter"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } //insert log if (!IsPostBack) { AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 2300, 0, "0"); } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Users"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } //insert log if (!IsPostBack) { AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 2000, 0, "0"); } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Credit"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } //insert log if (!IsPostBack) { AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1600, 0, "0"); } DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd = new SqlCommand("sp_creditRequestsPendingCount", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlConn.Open(); int RequestsUnreadCount = (int)sqlCmd.ExecuteScalar(); sqlCmd.Dispose(); sqlConn.Dispose(); if (RequestsUnreadCount == 0) { LabelRequestsNewCount.Visible = false; } else { LabelRequestsNewCount.Visible = true; LabelRequestsNewCount.Text = "(" + RequestsUnreadCount + " درخواست پاسخ داده نشده)"; } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Offers"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } //insert log if (!IsPostBack) { AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1800, 0, "0"); } DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd = new SqlCommand("sp_commentsOffersPendingCount", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlConn.Open(); int CommentsUnreadCount = (int)sqlCmd.ExecuteScalar(); sqlCmd.Dispose(); sqlConn.Dispose(); if (CommentsUnreadCount == 0) { LabelCommentNewCount.Visible = false; } else { LabelCommentNewCount.Visible = true; LabelCommentNewCount.Text = "(" + CommentsUnreadCount + " نظر پاسخ داده نشده)"; } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Newsletter"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_newsletterInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@NewsletterId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["NewsletterId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //admin doesn't exist { //LabelName.Text = "کاربری با این شناسه موجود نمی باشد!"; } else //user exists { LabelNewsletterId.Text = Request.QueryString["NewsletterId"].ToString(); ImageFormat.ImageUrl = "~/images/TypesImages/NewsletterFormat" + dt.Rows[0]["Format"].ToString() + ".png"; LabelReceiversCount.Text = dt.Rows[0]["ReceiversCount"].ToString(); ImageReceiversType.ImageUrl = "~/images/TypesImages/NewsletterReceivers" + dt.Rows[0]["ReceiversType"].ToString() + ".png"; LabelTitle.Text = dt.Rows[0]["Title"].ToString(); LiteralBody.Text = dt.Rows[0]["Body"].ToString(); } sda.Dispose(); sqlConn.Close(); }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Admins"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } //Page Title string[] siteInformation = new string[] { }; SiteInformation si = new SiteInformation(); siteInformation = si.getInformation(); Page.Title = siteInformation[0] + " : مدیریت ادمین ها"; //insert log if (!IsPostBack) { AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1100, 0, "0"); } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Newsletter"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_newsletterInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@NewsletterId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["NewsletterId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //admin doesn't exist { //LabelName.Text = "کاربری با این شناسه موجود نمی باشد!"; } else //user exists { LabelNewsletterId.Text = Request.QueryString["NewsletterId"].ToString(); ImageFormat.ImageUrl = "~/images/TypesImages/NewsletterFormat" + dt.Rows[0]["Format"].ToString() + ".png"; LabelReceiversCount.Text = dt.Rows[0]["ReceiversCount"].ToString(); ImageReceiversType.ImageUrl = "~/images/TypesImages/NewsletterReceivers" + dt.Rows[0]["ReceiversType"].ToString() + ".png"; LabelTitle.Text = dt.Rows[0]["Title"].ToString(); LiteralBody.Text = dt.Rows[0]["Body"].ToString(); } sda.Dispose(); sqlConn.Close(); }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Admins"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } if (!IsPostBack) { switch (Request.QueryString["Mode"]) { case "Edit": { DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_adminInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["UserId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //admin doesn't exist { LabelName.Text = "کاربری با این شناسه موجود نمی باشد!"; } else //user exists { LabelUserId.Text = Request.QueryString["UserId"].ToString(); LabelName.Text = dt.Rows[0]["FullName"].ToString(); DropDownListStatus.SelectedValue = dt.Rows[0]["Status"].ToString(); CheckBoxListPremissions.Items[0].Selected = Convert.ToBoolean(dt.Rows[0]["PremAdmins"].ToString()); CheckBoxListPremissions.Items[1].Selected = Convert.ToBoolean(dt.Rows[0]["PremAds"].ToString()); CheckBoxListPremissions.Items[2].Selected = Convert.ToBoolean(dt.Rows[0]["PremAgencies"].ToString()); CheckBoxListPremissions.Items[3].Selected = Convert.ToBoolean(dt.Rows[0]["PremBlog"].ToString()); CheckBoxListPremissions.Items[4].Selected = Convert.ToBoolean(dt.Rows[0]["PremCharity"].ToString()); CheckBoxListPremissions.Items[5].Selected = Convert.ToBoolean(dt.Rows[0]["PremCompanies"].ToString()); CheckBoxListPremissions.Items[6].Selected = Convert.ToBoolean(dt.Rows[0]["PremContent"].ToString()); CheckBoxListPremissions.Items[7].Selected = Convert.ToBoolean(dt.Rows[0]["PremCoupons"].ToString()); CheckBoxListPremissions.Items[8].Selected = Convert.ToBoolean(dt.Rows[0]["PremCredit"].ToString()); CheckBoxListPremissions.Items[9].Selected = Convert.ToBoolean(dt.Rows[0]["PremCurrencies"].ToString()); CheckBoxListPremissions.Items[10].Selected = Convert.ToBoolean(dt.Rows[0]["PremLocations"].ToString()); CheckBoxListPremissions.Items[11].Selected = Convert.ToBoolean(dt.Rows[0]["PremNewsletter"].ToString()); CheckBoxListPremissions.Items[12].Selected = Convert.ToBoolean(dt.Rows[0]["PremOffers"].ToString()); CheckBoxListPremissions.Items[13].Selected = Convert.ToBoolean(dt.Rows[0]["PremSettings"].ToString()); CheckBoxListPremissions.Items[14].Selected = Convert.ToBoolean(dt.Rows[0]["PremStats"].ToString()); CheckBoxListPremissions.Items[15].Selected = Convert.ToBoolean(dt.Rows[0]["PremSupport"].ToString()); CheckBoxListPremissions.Items[16].Selected = Convert.ToBoolean(dt.Rows[0]["PremUsers"].ToString()); HyperLinkEditLog.NavigateUrl = "~/AdminPages/Admins.aspx?Mode=Log&UserId=" + Request.QueryString["UserId"].ToString(); } sda.Dispose(); sqlConn.Close(); PanelEdit.Visible = true; Page.Title = "Salestan : تغییر اختیارات ادمین"; break; } case "Log": { PanelLog.Visible = true; Page.Title = "Salestan : فایل لاگ ادمین"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_adminInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["UserId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //admin doesn't exist { LabelLogName.Text = "کاربری با این شناسه موجود نمی باشد!"; } else //user exists { LabelLogUserId.Text = Request.QueryString["UserId"].ToString(); LabelLogName.Text = dt.Rows[0]["FullName"].ToString(); HyperLinkLogEdit.NavigateUrl = "~/AdminPages/Admins.aspx?Mode=Edit&UserId=" + Request.QueryString["UserId"].ToString(); } sda.Dispose(); sqlConn.Close(); break; } } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Charity"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } if (!IsPostBack) { switch (Request.QueryString["Mode"]) { case "NewsAdd": { PanelNews.Visible = true; Page.Title = "Salestan : اخبار خیریه"; ImageButtonNewsSubmit.ImageUrl = "~/images/Buttons/add-off.png"; LabelDate.Text = DateTime.Now.ToShortDateString(); break; } case "OrganizationsAdd": { PanelOrganizations.Visible = true; Page.Title = "Salestan : موسسات خیریه"; ImageButtonOrganizations.ImageUrl = "~/images/Buttons/add-off.png"; break; } case "NewsEdit": { PanelNews.Visible = true; Page.Title = "Salestan : اخبار خیریه"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_charityNewsInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@NewsId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["NewsId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //news doesn't exist { //LabelName.Text = "خبری با این شناسه موجود نمی باشد!"; } else //news exists { TimeClass tc = new TimeClass(); LabelDate.Text = tc.ConvertToIranTimeString(Convert.ToDateTime(dt.Rows[0]["SubmitDate"].ToString())); TextBoxNewsSubject.Text = dt.Rows[0]["Subject"].ToString(); TextBoxNewsBrief.Text = dt.Rows[0]["Brief"].ToString(); TextBoxNewsBody.Text = dt.Rows[0]["Body"].ToString(); //Location DropDownListLanguage.SelectedValue = dt.Rows[0]["Language"].ToString(); ImageButtonNewsSubmit.ImageUrl = "~/images/Buttons/edit-off.png"; } sda.Dispose(); sqlConn.Close(); break; } case "OrganizationsEdit": { PanelOrganizations.Visible = true; Page.Title = "Salestan : موسسات خیریه"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_charityOrganizationsInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@OrganizationId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["OrganizationId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //news doesn't exist { //LabelName.Text = "موسسه ای با این شناسه موجود نمی باشد!"; } else //news exists { TextBoxName.Text = dt.Rows[0]["Name"].ToString(); TextBoxAbout.Text = dt.Rows[0]["About"].ToString(); TextBoxEmail.Text = dt.Rows[0]["Email"].ToString(); TextBoxWebsite.Text = dt.Rows[0]["Website"].ToString(); TextBoxPhone.Text = dt.Rows[0]["Phone"].ToString(); TextBoxFax.Text = dt.Rows[0]["Fax"].ToString(); TextBoxAddress.Text = dt.Rows[0]["Address"].ToString(); ImageButtonOrganizations.ImageUrl = "~/images/Buttons/edit-off.png"; //Location } sda.Dispose(); sqlConn.Close(); break; } } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Companies"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } if (!IsPostBack) { switch (Request.QueryString["Mode"]) { case "Edit": { PanelEdit.Visible = true; Page.Title = "Salestan : تغییر مشخصات مشاغل"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_companyInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["CompanyId"]); sda.Fill(ds); dt = ds.Tables[0]; TextBoxOwnerId.Text = dt.Rows[0]["OwnerId"].ToString(); TextBoxName.Text = dt.Rows[0]["Name"].ToString(); TextBoxAbout.Text = dt.Rows[0]["About"].ToString(); DropDownListType.SelectedValue = dt.Rows[0]["TypeId"].ToString(); DropDownListField.SelectedValue = dt.Rows[0]["FieldId"].ToString(); TextBoxPhone.Text = dt.Rows[0]["Tel"].ToString(); TextBoxFax.Text = dt.Rows[0]["Fax"].ToString(); TextBoxMobile.Text = dt.Rows[0]["Mobile"].ToString(); TextBoxEmail.Text = dt.Rows[0]["Email"].ToString(); TextBoxWebsite.Text = dt.Rows[0]["Website"].ToString(); TextBoxAddress.Text = dt.Rows[0]["Address"].ToString(); TextBoxGoogleMap.Text = dt.Rows[0]["GoogleMap"].ToString(); break; } case "Info": { PanelInfo.Visible = true; Page.Title = "Salestan : مشخصات مشاغل"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_companyInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["CompanyId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //admin doesn't exist { LabelMessage.Text = "شغلی با این شناسه موجود نمی باشد!"; LabelMessage.CssClass = "ErrorMessage"; LabelMessage.Visible = true; PanelInfo.Visible = false; } else //user exists { LabelMessage.Visible = false; PanelInfo.Visible = true; LabelInfoOwner.Text = dt.Rows[0]["OwnerName"].ToString(); LabelInfoName.Text = dt.Rows[0]["Name"].ToString(); LabelInfoType.Text = dt.Rows[0]["TypeName"].ToString(); LabelInfoField.Text = dt.Rows[0]["FieldName"].ToString(); LabelInfoAbout.Text = dt.Rows[0]["About"].ToString(); LabelInfoPhone.Text = dt.Rows[0]["Tel"].ToString(); LabelInfoFax.Text = dt.Rows[0]["Fax"].ToString(); LabelInfoMobile.Text = dt.Rows[0]["Mobile"].ToString(); LabelInfoEmail.Text = dt.Rows[0]["Email"].ToString(); HyperLinkInfoWebsite.Text = dt.Rows[0]["Website"].ToString(); HyperLinkInfoWebsite.NavigateUrl = dt.Rows[0]["Website"].ToString(); LabelInfoAddress.Text = dt.Rows[0]["Address"].ToString(); LabelInfoGoogleMap.Text = dt.Rows[0]["GoogleMap"].ToString(); if (Convert.ToBoolean(dt.Rows[0]["Photo"].ToString())) { ImageInfoLogo.ImageUrl = "~/Files/companies/" + Request.QueryString["CompanyId"].ToString() + ".png"; ImageInfoLogo.Visible = true; } } sda.Dispose(); sqlConn.Close(); HyperLinkInfoChange.NavigateUrl = "~/AdminPages/Companies.aspx?Mode=Edit&CompanyId=" + Request.QueryString["CompanyId"]; break; } } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Offers"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } if (!IsPostBack) { switch (Request.QueryString["Mode"]) { case "Edit": { PanelEdit.Visible = true; Page.Title = "Salestan : تغییر مشخصات پیشنهاد"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_offerInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@OfferId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["OfferId"]); sda.Fill(ds); dt = ds.Tables[0]; //Descriptions StringBuilder sbDescriptions = new StringBuilder(HttpUtility.HtmlEncode(dt.Rows[0]["Descriptions"].ToString())); sbDescriptions.Replace("<", "<"); sbDescriptions.Replace(">", ">"); string descriptions = sbDescriptions.ToString(); //Highlights StringBuilder sbHighlights = new StringBuilder(HttpUtility.HtmlEncode(dt.Rows[0]["Highlights"].ToString())); sbHighlights.Replace("<", "<"); sbHighlights.Replace(">", ">"); string highlights = sbHighlights.ToString(); //Details StringBuilder sbDetails = new StringBuilder(HttpUtility.HtmlEncode(dt.Rows[0]["Details"].ToString())); sbDetails.Replace("<", "<"); sbDetails.Replace(">", ">"); string details = sbDetails.ToString(); DropDownListCompany.SelectedValue = dt.Rows[0]["CompanyId"].ToString(); TextBoxTitle.Text = dt.Rows[0]["Title"].ToString(); TextBoxBrowserTitle.Text = dt.Rows[0]["BrowserTitle"].ToString(); DropDownListCategory.SelectedValue = dt.Rows[0]["CategoryId"].ToString(); TextBoxHighlights.Text = highlights; TextBoxDetails.Text = details; TextBoxDescriptions.Text = descriptions; TextBoxPriceOffer.Text = dt.Rows[0]["PriceOffer"].ToString(); TextBoxPriceNormal.Text = dt.Rows[0]["PriceNormal"].ToString(); TextBoxPriceGift.Text = dt.Rows[0]["PriceGift"].ToString(); TextBoxPriceOurs.Text = dt.Rows[0]["PriceOurs"].ToString(); TextBoxPricePercent.Text = dt.Rows[0]["PriceDiscountPercent"].ToString(); TextBoxMinBuy.Text = dt.Rows[0]["MinBuy"].ToString(); TextBoxMaxBuy.Text = dt.Rows[0]["MaxBuy"].ToString(); TextBoxMinUser.Text = dt.Rows[0]["MinUser"].ToString(); TextBoxMaxUser.Text = dt.Rows[0]["MaxUser"].ToString(); LabelShowDateValue.Text = dt.Rows[0]["ShowDate"].ToString(); LabelEndDateValue.Text = dt.Rows[0]["EndDate"].ToString(); DropDownListLanguage.SelectedValue = dt.Rows[0]["Language"].ToString(); TextBoxLink1Name.Text = dt.Rows[0]["Link1Name"].ToString(); TextBoxLink1Url.Text = dt.Rows[0]["Link1Url"].ToString(); TextBoxLink2Name.Text = dt.Rows[0]["Link2Name"].ToString(); TextBoxLink2Url.Text = dt.Rows[0]["Link2Url"].ToString(); //locations for (int i = 0; i < CheckBoxListLocations.Items.Count; i++) { if (dt.Rows[0]["Locations"].ToString().Contains(CheckBoxListLocations.Items[i].Value + ",")) { CheckBoxListLocations.Items[i].Selected = true; } } sda.Dispose(); sqlConn.Dispose(); break; } case "Buyers": { PanelBuyers.Visible = true; Page.Title = "Salestan : فهرست خریداران پیشنهاد"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_offerBuyers", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@OfferId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["OfferId"]); sda.Fill(ds); dt = ds.Tables[0]; LabelBuyersCompanyName.Text = dt.Rows[0]["Name"].ToString(); LabelBuyersCompanyId.Text = dt.Rows[0]["CompanyId"].ToString(); LabelBuyersOfferId.Text = Request.QueryString["OfferId"]; LabelBuyersTitle.Text = dt.Rows[0]["Title"].ToString(); LabelBuyersSold.Text = dt.Rows[0]["PurchasedCount"].ToString(); TimeClass tc = new TimeClass(); LabelBuyersDate.Text = tc.ConvertToIranTimeString(Convert.ToDateTime(dt.Rows[0]["ShowDate"].ToString())); sda.Dispose(); sqlConn.Dispose(); break; } case "Photos": { PanelPhotos.Visible = true; Page.Title = "Salestan : تصاویر پیشنهاد"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_offersPhotos", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@OfferId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["OfferId"]); sda.Fill(ds); dt = ds.Tables[0]; LabelPhotosCompanyName.Text = dt.Rows[0]["Name"].ToString(); LabelPhotosCompanyId.Text = dt.Rows[0]["CompanyId"].ToString(); LabelPhotosOfferId.Text = Request.QueryString["OfferId"]; LabelPhotosOfferTitle.Text = dt.Rows[0]["Title"].ToString(); if (dt.Rows[0]["MainPhoto"].ToString() == "0") { ImageMainPhoto.ImageUrl = "NoPhoto.jpg"; } else { ImageMainPhoto.ImageUrl = "~/Files/Photos/" + dt.Rows[0]["MainPhoto"].ToString() + ".jpg"; } sda.Dispose(); sqlConn.Dispose(); break; } } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Companies"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } if (!IsPostBack) { switch (Request.QueryString["Mode"]) { case "Edit": { PanelEdit.Visible = true; Page.Title = "Salestan : تغییر مشخصات مشاغل"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_companyInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["CompanyId"]); sda.Fill(ds); dt = ds.Tables[0]; TextBoxOwnerId.Text = dt.Rows[0]["OwnerId"].ToString(); TextBoxName.Text = dt.Rows[0]["Name"].ToString(); TextBoxAbout.Text = dt.Rows[0]["About"].ToString(); DropDownListType.SelectedValue = dt.Rows[0]["TypeId"].ToString(); DropDownListField.SelectedValue = dt.Rows[0]["FieldId"].ToString(); TextBoxPhone.Text = dt.Rows[0]["Tel"].ToString(); TextBoxFax.Text = dt.Rows[0]["Fax"].ToString(); TextBoxMobile.Text = dt.Rows[0]["Mobile"].ToString(); TextBoxEmail.Text = dt.Rows[0]["Email"].ToString(); TextBoxWebsite.Text = dt.Rows[0]["Website"].ToString(); TextBoxAddress.Text = dt.Rows[0]["Address"].ToString(); TextBoxGoogleMap.Text = dt.Rows[0]["GoogleMap"].ToString(); break; } case "Info": { PanelInfo.Visible = true; Page.Title = "Salestan : مشخصات مشاغل"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_companyInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["CompanyId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //admin doesn't exist { LabelMessage.Text = "شغلی با این شناسه موجود نمی باشد!"; LabelMessage.CssClass = "ErrorMessage"; LabelMessage.Visible = true; PanelInfo.Visible = false; } else //user exists { LabelMessage.Visible = false; PanelInfo.Visible = true; LabelInfoOwner.Text = dt.Rows[0]["OwnerName"].ToString(); LabelInfoName.Text = dt.Rows[0]["Name"].ToString(); LabelInfoType.Text = dt.Rows[0]["TypeName"].ToString(); LabelInfoField.Text = dt.Rows[0]["FieldName"].ToString(); LabelInfoAbout.Text = dt.Rows[0]["About"].ToString(); LabelInfoPhone.Text = dt.Rows[0]["Tel"].ToString(); LabelInfoFax.Text = dt.Rows[0]["Fax"].ToString(); LabelInfoMobile.Text = dt.Rows[0]["Mobile"].ToString(); LabelInfoEmail.Text = dt.Rows[0]["Email"].ToString(); HyperLinkInfoWebsite.Text = dt.Rows[0]["Website"].ToString(); HyperLinkInfoWebsite.NavigateUrl = dt.Rows[0]["Website"].ToString(); LabelInfoAddress.Text = dt.Rows[0]["Address"].ToString(); LabelInfoGoogleMap.Text = dt.Rows[0]["GoogleMap"].ToString(); if (Convert.ToBoolean(dt.Rows[0]["Photo"].ToString())) { ImageInfoLogo.ImageUrl = "~/Files/companies/" + Request.QueryString["CompanyId"].ToString() + ".png"; ImageInfoLogo.Visible = true; } } sda.Dispose(); sqlConn.Close(); HyperLinkInfoChange.NavigateUrl = "~/AdminPages/Companies.aspx?Mode=Edit&CompanyId=" + Request.QueryString["CompanyId"]; break; } } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Users"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } if (!IsPostBack) { switch (Request.QueryString["Mode"]) { case "Info": { PanelInfo.Visible = true; Page.Title = "Salestan : مشخصات کاربر"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_userInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["UserId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //admin doesn't exist { LabelMessage.Text = "کاربری با این شناسه موجود نمی باشد!"; LabelMessage.CssClass = "ErrorMessage"; LabelMessage.Visible = true; PanelUserInfo.Visible = false; } else //user exists { LabelMessage.Visible = false; PanelUserInfo.Visible = true; LabelUserIdValue.Text = Request.QueryString["UserId"].ToString(); LabelEmailValue.Text = dt.Rows[0]["Email"].ToString(); LabelFirstNameValue.Text = dt.Rows[0]["FirstName"].ToString(); LabelLastNameValue.Text = dt.Rows[0]["LastName"].ToString(); LabelBirthValue.Text = dt.Rows[0]["BirthDate"].ToString(); ImageGender.ImageUrl = "~/images/icons/gender24" + dt.Rows[0]["Gender"].ToString() + ".png"; LabelJobValue.Text = dt.Rows[0]["Job"].ToString(); LabelEducationValue.Text = dt.Rows[0]["Education"].ToString(); LabelHomePhoneValue.Text = dt.Rows[0]["HomeTel"].ToString(); LabelWorkPhoneValue.Text = dt.Rows[0]["WorkTel"].ToString(); LabelMobileValue.Text = dt.Rows[0]["Mobile"].ToString(); LabelAddressValue.Text = dt.Rows[0]["Address"].ToString(); LabelCredit.Text = dt.Rows[0]["Credit"].ToString(); LabelGiftCredit.Text = dt.Rows[0]["GiftCredit"].ToString(); LabelSpentCredit.Text = dt.Rows[0]["SpentCredit"].ToString(); LabelSpendGift.Text = dt.Rows[0]["SpentGift"].ToString(); LabelStatsOffersPurchased.Text = dt.Rows[0]["PurchasedOffersCount"].ToString(); LabelStatsUsersInvite.Text = dt.Rows[0]["InvitedUsersCount"].ToString(); DropDownListStatus.SelectedValue = dt.Rows[0]["Status"].ToString(); TimeClass tc = new TimeClass(); LabelMemberSinceValue.Text = tc.ConvertToIranTimeString(Convert.ToDateTime(dt.Rows[0]["MemberSince"].ToString())); LabelLastLoginValue.Text = tc.ConvertToIranTimeString(Convert.ToDateTime(dt.Rows[0]["LastLogin"].ToString())); } sda.Dispose(); sqlConn.Close(); break; } } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Users"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } if (!IsPostBack) { switch (Request.QueryString["Mode"]) { case "Info": { PanelInfo.Visible = true; Page.Title = "Salestan : مشخصات کاربر"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_userInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["UserId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //admin doesn't exist { LabelMessage.Text = "کاربری با این شناسه موجود نمی باشد!"; LabelMessage.CssClass = "ErrorMessage"; LabelMessage.Visible = true; PanelUserInfo.Visible = false; } else //user exists { LabelMessage.Visible = false; PanelUserInfo.Visible = true; LabelUserIdValue.Text = Request.QueryString["UserId"].ToString(); LabelEmailValue.Text = dt.Rows[0]["Email"].ToString(); LabelFirstNameValue.Text = dt.Rows[0]["FirstName"].ToString(); LabelLastNameValue.Text = dt.Rows[0]["LastName"].ToString(); LabelBirthValue.Text = dt.Rows[0]["BirthDate"].ToString(); ImageGender.ImageUrl = "~/images/icons/gender24" + dt.Rows[0]["Gender"].ToString() + ".png"; LabelJobValue.Text = dt.Rows[0]["Job"].ToString(); LabelEducationValue.Text = dt.Rows[0]["Education"].ToString(); LabelHomePhoneValue.Text = dt.Rows[0]["HomeTel"].ToString(); LabelWorkPhoneValue.Text = dt.Rows[0]["WorkTel"].ToString(); LabelMobileValue.Text = dt.Rows[0]["Mobile"].ToString(); LabelAddressValue.Text = dt.Rows[0]["Address"].ToString(); LabelCredit.Text = dt.Rows[0]["Credit"].ToString(); LabelGiftCredit.Text = dt.Rows[0]["GiftCredit"].ToString(); LabelSpentCredit.Text = dt.Rows[0]["SpentCredit"].ToString(); LabelSpendGift.Text = dt.Rows[0]["SpentGift"].ToString(); LabelStatsOffersPurchased.Text = dt.Rows[0]["PurchasedOffersCount"].ToString(); LabelStatsUsersInvite.Text = dt.Rows[0]["InvitedUsersCount"].ToString(); DropDownListStatus.SelectedValue = dt.Rows[0]["Status"].ToString(); TimeClass tc = new TimeClass(); LabelMemberSinceValue.Text = tc.ConvertToIranTimeString(Convert.ToDateTime(dt.Rows[0]["MemberSince"].ToString())); LabelLastLoginValue.Text = tc.ConvertToIranTimeString(Convert.ToDateTime(dt.Rows[0]["LastLogin"].ToString())); } sda.Dispose(); sqlConn.Close(); break; } } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Coupons"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } if (!IsPostBack) { switch (Request.QueryString["Mode"]) { case "Edit": { PanelEdit.Visible = true; Page.Title = "Salestan : تغییر مشخصات کوپن"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_couponInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@CouponId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["CouponId"]); sda.Fill(ds); dt = ds.Tables[0]; //Descriptions StringBuilder sbDescriptions = new StringBuilder(HttpUtility.HtmlEncode(dt.Rows[0]["Descriptions"].ToString())); sbDescriptions.Replace("<", "<"); sbDescriptions.Replace(">", ">"); string descriptions = sbDescriptions.ToString(); //Highlights StringBuilder sbHighlights = new StringBuilder(HttpUtility.HtmlEncode(dt.Rows[0]["Highlights"].ToString())); sbHighlights.Replace("<", "<"); sbHighlights.Replace(">", ">"); string highlights = sbHighlights.ToString(); //Details StringBuilder sbDetails = new StringBuilder(HttpUtility.HtmlEncode(dt.Rows[0]["Details"].ToString())); sbDetails.Replace("<", "<"); sbDetails.Replace(">", ">"); string details = sbDetails.ToString(); DropDownListCompany.SelectedValue = dt.Rows[0]["CompanyId"].ToString(); TextBoxTitle.Text = dt.Rows[0]["Title"].ToString(); DropDownListCategory.SelectedValue = dt.Rows[0]["CategoryId"].ToString(); TextBoxHighlights.Text = highlights; TextBoxDetails.Text = details; TextBoxDescriptions.Text = descriptions; LabelShowDateValue.Text = dt.Rows[0]["ShowDate"].ToString(); LabelEndDateValue.Text = dt.Rows[0]["EndDate"].ToString(); DropDownListLanguage.SelectedValue = dt.Rows[0]["Language"].ToString(); DropDownListLink1.SelectedValue = dt.Rows[0]["Link1Type"].ToString(); TextBoxLink1.Text = dt.Rows[0]["Link1Url"].ToString(); DropDownListLink2.SelectedValue = dt.Rows[0]["Link2Type"].ToString(); TextBoxLink2.Text = dt.Rows[0]["Link2Url"].ToString(); TextBoxLink3.Text = dt.Rows[0]["Link3Url"].ToString(); TextBoxLink3Image.Text = dt.Rows[0]["Link3Image"].ToString(); //locations for (int i = 0; i < CheckBoxListLocations.Items.Count; i++) { if (dt.Rows[0]["Locations"].ToString().Contains(CheckBoxListLocations.Items[i].Value + ",")) { CheckBoxListLocations.Items[i].Selected = true; } } sda.Dispose(); sqlConn.Dispose(); break; } case "Photos": { PanelPhotos.Visible = true; Page.Title = "Salestan : تصاویر کوپن"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_couponsPhotos", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@CouponId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["CouponId"]); sda.Fill(ds); dt = ds.Tables[0]; LabelPhotosCompanyName.Text = dt.Rows[0]["Name"].ToString(); LabelPhotosCompanyId.Text = dt.Rows[0]["CompanyId"].ToString(); LabelPhotosCouponId.Text = Request.QueryString["CouponId"]; LabelPhotosCouponTitle.Text = dt.Rows[0]["Title"].ToString(); if (dt.Rows[0]["MainPhoto"].ToString() == "0") { ImageMainPhoto.ImageUrl = "NoPhoto.jpg"; } else { ImageMainPhoto.ImageUrl = "~/Files/Photos/" + dt.Rows[0]["MainPhoto"].ToString() + ".jpg"; } sda.Dispose(); sqlConn.Dispose(); break; } } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Admins"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } if (!IsPostBack) { switch (Request.QueryString["Mode"]) { case "Edit": { DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_adminInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["UserId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //admin doesn't exist { LabelName.Text = "کاربری با این شناسه موجود نمی باشد!"; } else //user exists { LabelUserId.Text = Request.QueryString["UserId"].ToString(); LabelName.Text = dt.Rows[0]["FullName"].ToString(); DropDownListStatus.SelectedValue = dt.Rows[0]["Status"].ToString(); CheckBoxListPremissions.Items[0].Selected = Convert.ToBoolean(dt.Rows[0]["PremAdmins"].ToString()); CheckBoxListPremissions.Items[1].Selected = Convert.ToBoolean(dt.Rows[0]["PremAds"].ToString()); CheckBoxListPremissions.Items[2].Selected = Convert.ToBoolean(dt.Rows[0]["PremAgencies"].ToString()); CheckBoxListPremissions.Items[3].Selected = Convert.ToBoolean(dt.Rows[0]["PremBlog"].ToString()); CheckBoxListPremissions.Items[4].Selected = Convert.ToBoolean(dt.Rows[0]["PremCharity"].ToString()); CheckBoxListPremissions.Items[5].Selected = Convert.ToBoolean(dt.Rows[0]["PremCompanies"].ToString()); CheckBoxListPremissions.Items[6].Selected = Convert.ToBoolean(dt.Rows[0]["PremContent"].ToString()); CheckBoxListPremissions.Items[7].Selected = Convert.ToBoolean(dt.Rows[0]["PremCoupons"].ToString()); CheckBoxListPremissions.Items[8].Selected = Convert.ToBoolean(dt.Rows[0]["PremCredit"].ToString()); CheckBoxListPremissions.Items[9].Selected = Convert.ToBoolean(dt.Rows[0]["PremCurrencies"].ToString()); CheckBoxListPremissions.Items[10].Selected = Convert.ToBoolean(dt.Rows[0]["PremLocations"].ToString()); CheckBoxListPremissions.Items[11].Selected = Convert.ToBoolean(dt.Rows[0]["PremNewsletter"].ToString()); CheckBoxListPremissions.Items[12].Selected = Convert.ToBoolean(dt.Rows[0]["PremOffers"].ToString()); CheckBoxListPremissions.Items[13].Selected = Convert.ToBoolean(dt.Rows[0]["PremSettings"].ToString()); CheckBoxListPremissions.Items[14].Selected = Convert.ToBoolean(dt.Rows[0]["PremStats"].ToString()); CheckBoxListPremissions.Items[15].Selected = Convert.ToBoolean(dt.Rows[0]["PremSupport"].ToString()); CheckBoxListPremissions.Items[16].Selected = Convert.ToBoolean(dt.Rows[0]["PremUsers"].ToString()); HyperLinkEditLog.NavigateUrl = "~/AdminPages/Admins.aspx?Mode=Log&UserId=" + Request.QueryString["UserId"].ToString(); } sda.Dispose(); sqlConn.Close(); PanelEdit.Visible = true; Page.Title = "Salestan : تغییر اختیارات ادمین"; break; } case "Log": { PanelLog.Visible = true; Page.Title = "Salestan : فایل لاگ ادمین"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_adminInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["UserId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //admin doesn't exist { LabelLogName.Text = "کاربری با این شناسه موجود نمی باشد!"; } else //user exists { LabelLogUserId.Text = Request.QueryString["UserId"].ToString(); LabelLogName.Text = dt.Rows[0]["FullName"].ToString(); HyperLinkLogEdit.NavigateUrl = "~/AdminPages/Admins.aspx?Mode=Edit&UserId=" + Request.QueryString["UserId"].ToString(); } sda.Dispose(); sqlConn.Close(); break; } } } }
protected void Page_Load(object sender, EventArgs e) { //check premissions AdminPremissions ap = new AdminPremissions(); bool AdminPremission = ap.getAdminPremissions(Convert.ToInt32(Session["UserId"]), "Charity"); if (!AdminPremission) { Response.Redirect("~/Error.aspx?Code=404"); } if (!IsPostBack) { switch (Request.QueryString["Mode"]) { case "NewsAdd": { PanelNews.Visible = true; Page.Title = "Salestan : اخبار خیریه"; ImageButtonNewsSubmit.ImageUrl = "~/images/Buttons/add-off.png"; LabelDate.Text = DateTime.Now.ToShortDateString(); break; } case "OrganizationsAdd": { PanelOrganizations.Visible = true; Page.Title = "Salestan : موسسات خیریه"; ImageButtonOrganizations.ImageUrl = "~/images/Buttons/add-off.png"; break; } case "NewsEdit": { PanelNews.Visible = true; Page.Title = "Salestan : اخبار خیریه"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_charityNewsInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@NewsId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["NewsId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //news doesn't exist { //LabelName.Text = "خبری با این شناسه موجود نمی باشد!"; } else //news exists { TimeClass tc = new TimeClass(); LabelDate.Text = tc.ConvertToIranTimeString(Convert.ToDateTime(dt.Rows[0]["SubmitDate"].ToString())); TextBoxNewsSubject.Text = dt.Rows[0]["Subject"].ToString(); TextBoxNewsBrief.Text = dt.Rows[0]["Brief"].ToString(); TextBoxNewsBody.Text = dt.Rows[0]["Body"].ToString(); //Location DropDownListLanguage.SelectedValue = dt.Rows[0]["Language"].ToString(); ImageButtonNewsSubmit.ImageUrl = "~/images/Buttons/edit-off.png"; } sda.Dispose(); sqlConn.Close(); break; } case "OrganizationsEdit": { PanelOrganizations.Visible = true; Page.Title = "Salestan : موسسات خیریه"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_charityOrganizationsInfo", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@OrganizationId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["OrganizationId"]); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //news doesn't exist { //LabelName.Text = "موسسه ای با این شناسه موجود نمی باشد!"; } else //news exists { TextBoxName.Text = dt.Rows[0]["Name"].ToString(); TextBoxAbout.Text = dt.Rows[0]["About"].ToString(); TextBoxEmail.Text = dt.Rows[0]["Email"].ToString(); TextBoxWebsite.Text = dt.Rows[0]["Website"].ToString(); TextBoxPhone.Text = dt.Rows[0]["Phone"].ToString(); TextBoxFax.Text = dt.Rows[0]["Fax"].ToString(); TextBoxAddress.Text = dt.Rows[0]["Address"].ToString(); ImageButtonOrganizations.ImageUrl = "~/images/Buttons/edit-off.png"; //Location } sda.Dispose(); sqlConn.Close(); break; } } } }