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 ImageButtonStatus_Click(object sender, ImageClickEventArgs e) { DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd = new SqlCommand("sp_userStatusChange", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["UserId"].ToString()); sqlCmd.Parameters.Add("@Status", SqlDbType.TinyInt).Value = Convert.ToInt32(DropDownListStatus.SelectedValue); sqlConn.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); sqlConn.Dispose(); LabelStatusMessage.Visible = true; LabelStatusMessage.Text = "وضعیت کاربر تغییر یافت."; LabelStatusMessage.CssClass = "SuccessMessage"; //insert log AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 2001, Convert.ToInt32(Request.QueryString["UserId"].ToString()), Convert.ToInt32(DropDownListStatus.SelectedValue).ToString()); }
protected void ImageButtonBottom_Click(object sender, ImageClickEventArgs e) { if (FileUploadBottom.HasFile) { if (System.IO.Path.GetExtension(FileUploadBottom.FileName) == ".png") { try { FileUploadBottom.SaveAs(Server.MapPath("~/images/bottom.png")); } catch (Exception ex) { } ImageBottom.ImageUrl = "~/images/bottom.png"; LabelMessageBottom.Text = "فایل تصویر پایین تغییر یافت."; LabelMessageBottom.CssClass = "SuccessMessage"; //insert log AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1904, 0, "0"); } else { LabelMessageBottom.Text = "لطفاً فایلی با فرمت PNG انتخاب نمایید."; LabelMessageBottom.CssClass = "ErrorMessage"; } } else { LabelMessageBottom.Text = "لطفاً فایل مورد نظر را انتخاب کنید."; LabelMessageBottom.CssClass = "ErrorMessage"; } }
protected void ImageButtonEdit_Click(object sender, ImageClickEventArgs e) { if (!captcha.Decide()) { captcha.message = "پاسخ اشتباه است!"; } else { SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd = new SqlCommand("sp_blogEdit", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@BlogId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["BlogId"]); sqlCmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = TextBoxTitle.Text; sqlCmd.Parameters.Add("@Brief", SqlDbType.NVarChar).Value = TextBoxBrief.Text; sqlCmd.Parameters.Add("@Body", SqlDbType.NVarChar).Value = TextBoxBody.Text; sqlCmd.Parameters.Add("@Locations", SqlDbType.VarChar).Value = "0,"; sqlCmd.Parameters.Add("@Language", SqlDbType.VarChar).Value = DropDownListLanguage.SelectedValue; sqlCmd.Parameters.Add("@CategoryId", SqlDbType.VarChar).Value = DropDownListCategory.SelectedValue; sqlCmd.Parameters.Add("@PhotoLink", SqlDbType.VarChar).Value = TextBoxPhotoLink.Text; sqlConn.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); sqlConn.Dispose(); LabelEditMessage.Visible = true; LabelEditMessage.Text = "مشخصات مطلب تغییر یافت."; LabelEditMessage.CssClass = "SuccessMessage"; //insert log AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 2202, Convert.ToInt32(Request.QueryString["BlogId"]), "0"); } }
protected void ImageButtonNewsSubmit_Click(object sender, ImageClickEventArgs e) { switch (Request.QueryString["Mode"]) { case "NewsAdd": { SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd = new SqlCommand("sp_charityNewsAdd", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@Subject", SqlDbType.NVarChar).Value = TextBoxNewsSubject.Text; sqlCmd.Parameters.Add("@Brief", SqlDbType.NVarChar).Value = TextBoxNewsBrief.Text; sqlCmd.Parameters.Add("@Body", SqlDbType.NVarChar).Value = TextBoxNewsBody.Text; sqlCmd.Parameters.Add("@Locations", SqlDbType.VarChar).Value = "0,"; sqlCmd.Parameters.Add("@Language", SqlDbType.VarChar).Value = DropDownListLanguage.SelectedValue; sqlConn.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); sqlConn.Dispose(); LabelNewsMessage.Visible = true; LabelNewsMessage.Text = "خبر اضافه گردید."; LabelNewsMessage.CssClass = "SuccessMessage"; break; } case "NewsEdit": { SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd = new SqlCommand("sp_charityNewsEdit", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@NewsId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["NewsId"]); sqlCmd.Parameters.Add("@Subject", SqlDbType.NVarChar).Value = TextBoxNewsSubject.Text; sqlCmd.Parameters.Add("@Brief", SqlDbType.NVarChar).Value = TextBoxNewsBrief.Text; sqlCmd.Parameters.Add("@Body", SqlDbType.NVarChar).Value = TextBoxNewsBody.Text; sqlCmd.Parameters.Add("@Locations", SqlDbType.VarChar).Value = "0,"; sqlCmd.Parameters.Add("@Language", SqlDbType.VarChar).Value = DropDownListLanguage.SelectedValue; sqlCmd.Parameters.Add("@Status", SqlDbType.Int).Value = 1; sqlConn.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); sqlConn.Dispose(); LabelNewsMessage.Visible = true; LabelNewsMessage.Text = "مشخصات خبر تغییر یافت."; LabelNewsMessage.CssClass = "SuccessMessage"; //insert log AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1302, Convert.ToInt32(Request.QueryString["NewsId"]), "0"); 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 LinkButtonDefault_Click(object sender, EventArgs e) { File.Copy(Request.PhysicalApplicationPath + "images\\default\\background.png", @Request.PhysicalApplicationPath + "images\\background\\background.png", true); File.Copy(Request.PhysicalApplicationPath + "images\\default\\bottom.png", @Request.PhysicalApplicationPath + "images\\bottom.png", true); File.Copy(Request.PhysicalApplicationPath + "images\\default\\top.png", @Request.PhysicalApplicationPath + "images\\top.png", true); File.Copy(Request.PhysicalApplicationPath + "images\\default\\logomain.png", @Request.PhysicalApplicationPath + "images\\logomain.png", true); File.Copy(Request.PhysicalApplicationPath + "images\\default\\Styles.css", @Request.PhysicalApplicationPath + "Styles\\Styles.css", true); //insert log AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1906, 0, "0"); Response.Redirect("~/AdminSettings.aspx"); }
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 ImageButtonKeywrods_Click(object sender, ImageClickEventArgs e) { SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd = new SqlCommand("sp_contentSeoKeywordsEdit", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@Keywords", SqlDbType.NVarChar).Value = Convert.ToInt32(TextBoxKeywords.Text); sqlConn.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); sqlConn.Dispose(); //insert log AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1502, 0, TextBoxKeywords.Text); }
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 ImageButtonDescriptions_Click(object sender, ImageClickEventArgs e) { SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd = new SqlCommand("sp_contentSeoDescriptionsEdit", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@Descriptions", SqlDbType.NVarChar).Value = Convert.ToInt32(TextBoxDescriptions.Text); sqlConn.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); sqlConn.Dispose(); //insert log AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1503, 0, TextBoxDescriptions.Text); }
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 ImageButtonEdit_Click(object sender, ImageClickEventArgs e) { DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd = new SqlCommand("sp_companyEdit", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["CompanyId"]); sqlCmd.Parameters.Add("@OwnerId", SqlDbType.Int).Value = TextBoxOwnerId.Text; sqlCmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = TextBoxName.Text; sqlCmd.Parameters.Add("@About", SqlDbType.NVarChar).Value = TextBoxAbout.Text; sqlCmd.Parameters.Add("@TypeId", SqlDbType.VarChar).Value = DropDownListType.SelectedValue; sqlCmd.Parameters.Add("@FieldId", SqlDbType.VarChar).Value = DropDownListField.SelectedValue; sqlCmd.Parameters.Add("@Tel", SqlDbType.VarChar).Value = TextBoxPhone.Text; sqlCmd.Parameters.Add("@Fax", SqlDbType.VarChar).Value = TextBoxFax.Text; sqlCmd.Parameters.Add("@Mobile", SqlDbType.VarChar).Value = TextBoxMobile.Text; sqlCmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = TextBoxEmail.Text; sqlCmd.Parameters.Add("@Website", SqlDbType.NVarChar).Value = TextBoxWebsite.Text; sqlCmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = TextBoxAddress.Text; sqlCmd.Parameters.Add("@GoogleMap", SqlDbType.VarChar).Value = TextBoxGoogleMap.Text; sqlConn.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); sqlConn.Dispose(); LabelEditMessage.Visible = true; LabelEditMessage.Text = "مشخصات شغل مورد نظر تغییر یافت."; LabelEditMessage.CssClass = "SuccessMessage"; //insert log AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1402, Convert.ToInt32(Request.QueryString["CompanyId"]), "0"); }
protected void ImageButtonEdit_Click(object sender, ImageClickEventArgs e) { // Get Values from CheckBoxList String Locations = ""; for (int i = 0; i < CheckBoxListLocations.Items.Count; i++) { if (CheckBoxListLocations.Items[i].Selected) { Locations += CheckBoxListLocations.Items[i].Value + ","; } } //Descriptions StringBuilder sbDescriptions = new StringBuilder(HttpUtility.HtmlEncode(TextBoxDescriptions.Text)); sbDescriptions.Replace("&quot;", "'"); sbDescriptions.Replace("&lt;", "<"); sbDescriptions.Replace("&gt;", ">"); string descriptions = sbDescriptions.ToString(); //Highlights StringBuilder sbHighlights = new StringBuilder(HttpUtility.HtmlEncode(TextBoxHighlights.Text)); sbHighlights.Replace("&quot;", "'"); sbHighlights.Replace("&lt;", "<"); sbHighlights.Replace("&gt;", ">"); string highlights = sbHighlights.ToString(); //Details StringBuilder sbDetails = new StringBuilder(HttpUtility.HtmlEncode(TextBoxDetails.Text)); sbDetails.Replace("&quot;", "'"); sbDetails.Replace("&lt;", "<"); sbDetails.Replace("&gt;", ">"); string details = sbDetails.ToString(); //BrowserTitle string browserTitle = TextBoxTitle.Text; browserTitle.Replace(" ", "-"); DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd = new SqlCommand("sp_couponEdit", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@CouponId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["CouponId"]); sqlCmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = DropDownListCompany.SelectedValue; sqlCmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = TextBoxTitle.Text; sqlCmd.Parameters.Add("@BrowserTitle", SqlDbType.NVarChar).Value = browserTitle; sqlCmd.Parameters.Add("@StartCoupon", SqlDbType.NVarChar).Value = TextBoxStartCoupon.Text; sqlCmd.Parameters.Add("@EndCoupon", SqlDbType.NVarChar).Value = TextBoxEndCoupon.Text; sqlCmd.Parameters.Add("@EndDate", SqlDbType.SmallDateTime).Value = Convert.ToDateTime(LabelEndDateValue.Text).AddHours(Convert.ToDouble(TextBoxDuration.Text)); sqlCmd.Parameters.Add("@Highlights", SqlDbType.NVarChar).Value = highlights; sqlCmd.Parameters.Add("@Details", SqlDbType.NVarChar).Value = details; sqlCmd.Parameters.Add("@Descriptions", SqlDbType.NVarChar).Value = descriptions; sqlCmd.Parameters.Add("@Code", SqlDbType.NVarChar).Value = TextBoxCode.Text; sqlCmd.Parameters.Add("@Locations", SqlDbType.VarChar).Value = Locations; sqlCmd.Parameters.Add("@Language", SqlDbType.VarChar).Value = DropDownListLanguage.SelectedValue; sqlCmd.Parameters.Add("@CategoryId", SqlDbType.VarChar).Value = DropDownListCategory.SelectedValue; sqlCmd.Parameters.Add("@Link1Type", SqlDbType.Int).Value = DropDownListLink1.SelectedValue; sqlCmd.Parameters.Add("@Link1Url", SqlDbType.NVarChar).Value = TextBoxLink1.Text; sqlCmd.Parameters.Add("@Link2Type", SqlDbType.Int).Value = DropDownListLink2.SelectedValue; sqlCmd.Parameters.Add("@Link2Url", SqlDbType.NVarChar).Value = TextBoxLink2.Text; sqlCmd.Parameters.Add("@Link3Url", SqlDbType.NVarChar).Value = TextBoxLink3.Text; sqlCmd.Parameters.Add("@Link3Image", SqlDbType.NVarChar).Value = TextBoxLink3Image.Text; sqlConn.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); sqlConn.Dispose(); LabelEditMessage.Visible = true; LabelEditMessage.Text = "مشخصات کوپن مورد نظر تغییر یافت."; LabelEditMessage.CssClass = "SuccessMessage"; //insert log AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1802, Convert.ToInt32(Request.QueryString["CouponId"]), "0"); }
protected void ImageButtonSubmit_Click(object sender, ImageClickEventArgs e) { DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_adminAddCheckExists", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(LabelUserId.Text); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //user doesn't exist { LabelEditMessage.Visible = true; LabelEditMessage.Text = "ادمین با شناسه وارد شده وجود ندارد!"; LabelEditMessage.CssClass = "ErrorMessage"; sda.Dispose(); sqlConn.Close(); } else //user exists as an admin { SqlCommand sqlCmd = new SqlCommand("sp_adminEdit", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@PremAdmins", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[0].Selected; sqlCmd.Parameters.Add("@PremAds", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[1].Selected; sqlCmd.Parameters.Add("@PremAgencies", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[2].Selected; sqlCmd.Parameters.Add("@PremBlog", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[3].Selected; sqlCmd.Parameters.Add("@PremCharity", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[4].Selected; sqlCmd.Parameters.Add("@PremCompanies", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[5].Selected; sqlCmd.Parameters.Add("@PremContent", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[6].Selected; sqlCmd.Parameters.Add("@PremCoupons", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[7].Selected; sqlCmd.Parameters.Add("@PremCredit", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[8].Selected; sqlCmd.Parameters.Add("@PremCurrencies", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[9].Selected; sqlCmd.Parameters.Add("@PremLocations", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[10].Selected; sqlCmd.Parameters.Add("@PremNewsletter", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[11].Selected; sqlCmd.Parameters.Add("@PremOffers", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[12].Selected; sqlCmd.Parameters.Add("@PremSettings", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[13].Selected; sqlCmd.Parameters.Add("@PremStats", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[14].Selected; sqlCmd.Parameters.Add("@PremSupport", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[15].Selected; sqlCmd.Parameters.Add("@PremUsers", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[16].Selected; sqlCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(LabelUserId.Text); sqlCmd.Parameters.Add("@Status", SqlDbType.TinyInt).Value = DropDownListStatus.SelectedValue; sqlConn.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); sqlConn.Dispose(); sda.Dispose(); LabelEditMessage.Visible = true; LabelEditMessage.Text = "تنظیمات ادمین مورد نظر تغییر یافت."; LabelEditMessage.CssClass = "SuccessMessage"; //insert log AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1102, Convert.ToInt32(LabelUserId.Text), "0"); } }
protected void ImageButtonAdd_Click(object sender, ImageClickEventArgs e) { DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_userFullNameByUserId", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(TextBoxUserId.Text); sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //user doesn't exist { LabelAddMessage.Visible = true; LabelAddMessage.Text = "کاربری با این شناسه موجود نمی باشد!"; LabelAddMessage.CssClass = "ErrorMessage"; } else //user exists { DataTable dt2 = new DataTable(); DataSet ds2 = new DataSet(); sda = new SqlDataAdapter("sp_adminAddCheckExists", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(TextBoxUserId.Text); sda.Fill(ds2); dt2 = ds2.Tables[0]; if (dt2.Rows.Count == 0) //user doesn't exist as an admin { SqlCommand sqlCmd = new SqlCommand("sp_adminAdd", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@PremAdmins", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[0].Selected; sqlCmd.Parameters.Add("@PremAds", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[1].Selected; sqlCmd.Parameters.Add("@PremAgencies", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[2].Selected; sqlCmd.Parameters.Add("@PremBlog", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[3].Selected; sqlCmd.Parameters.Add("@PremCharity", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[4].Selected; sqlCmd.Parameters.Add("@PremCompanies", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[5].Selected; sqlCmd.Parameters.Add("@PremContent", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[6].Selected; sqlCmd.Parameters.Add("@PremCoupons", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[7].Selected; sqlCmd.Parameters.Add("@PremCredit", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[8].Selected; sqlCmd.Parameters.Add("@PremCurrencies", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[9].Selected; sqlCmd.Parameters.Add("@PremLocations", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[10].Selected; sqlCmd.Parameters.Add("@PremNewsletter", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[11].Selected; sqlCmd.Parameters.Add("@PremOffers", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[12].Selected; sqlCmd.Parameters.Add("@PremSettings", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[13].Selected; sqlCmd.Parameters.Add("@PremStats", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[14].Selected; sqlCmd.Parameters.Add("@PremSupport", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[15].Selected; sqlCmd.Parameters.Add("@PremUsers", SqlDbType.Bit).Value = CheckBoxListPremissions.Items[16].Selected; sqlCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(TextBoxUserId.Text); sqlCmd.Parameters.Add("@Status", SqlDbType.TinyInt).Value = 1; sqlConn.Open(); sqlCmd.ExecuteNonQuery(); GridViewAdmins.DataBind(); sqlCmd.Dispose(); sqlConn.Dispose(); sda.Dispose(); LabelAddMessage.Visible = true; LabelAddMessage.Text = "کاربر با تنظیمات وارد شده به عنوان ادمین اضافه گردید."; LabelAddMessage.CssClass = "SuccessMessage"; //insert log AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1101, Convert.ToInt32(TextBoxUserId.Text), "0"); } else //user exists as an admin { LabelAddMessage.Visible = true; LabelAddMessage.Text = "کاربر با شناسه وارد شده قبلاً به عنوان ادمین اضافه شده است!"; LabelAddMessage.CssClass = "ErrorMessage"; sda.Dispose(); sqlConn.Close(); } } }
protected void ImageButtonEdit_Click(object sender, ImageClickEventArgs e) { // Get Values from CheckBoxList String Locations = ""; for (int i = 0; i < CheckBoxListLocations.Items.Count; i++) { if (CheckBoxListLocations.Items[i].Selected) { Locations += CheckBoxListLocations.Items[i].Value + ","; } } //Descriptions StringBuilder sbDescriptions = new StringBuilder(HttpUtility.HtmlEncode(TextBoxDescriptions.Text)); sbDescriptions.Replace("&quot;", "'"); sbDescriptions.Replace("&lt;", "<"); sbDescriptions.Replace("&gt;", ">"); string descriptions = sbDescriptions.ToString(); //Highlights StringBuilder sbHighlights = new StringBuilder(HttpUtility.HtmlEncode(TextBoxHighlights.Text)); sbHighlights.Replace("&quot;", "'"); sbHighlights.Replace("&lt;", "<"); sbHighlights.Replace("&gt;", ">"); string highlights = sbHighlights.ToString(); //Details StringBuilder sbDetails = new StringBuilder(HttpUtility.HtmlEncode(TextBoxDetails.Text)); sbDetails.Replace("&quot;", "'"); sbDetails.Replace("&lt;", "<"); sbDetails.Replace("&gt;", ">"); string details = sbDetails.ToString(); DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd = new SqlCommand("sp_offerEdit", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@OfferId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["OfferId"]); sqlCmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = DropDownListCompany.SelectedValue; sqlCmd.Parameters.Add("@BrowserTitle", SqlDbType.NVarChar).Value = TextBoxBrowserTitle.Text; sqlCmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = TextBoxTitle.Text; sqlCmd.Parameters.Add("@PriceDiscountPercent", SqlDbType.Int).Value = TextBoxPricePercent.Text; sqlCmd.Parameters.Add("@PriceNormal", SqlDbType.Int).Value = TextBoxPriceNormal.Text; sqlCmd.Parameters.Add("@PriceOffer", SqlDbType.Int).Value = TextBoxPriceOffer.Text; sqlCmd.Parameters.Add("@PriceGift", SqlDbType.Int).Value = TextBoxPriceGift.Text; sqlCmd.Parameters.Add("@PriceOurs", SqlDbType.Int).Value = TextBoxPriceOurs.Text; sqlCmd.Parameters.Add("@PostPrice", SqlDbType.Int).Value = TextBoxPostPrice.Text; sqlCmd.Parameters.Add("@MinBuy", SqlDbType.Int).Value = TextBoxMinBuy.Text; sqlCmd.Parameters.Add("@MaxBuy", SqlDbType.Int).Value = TextBoxMaxBuy.Text; sqlCmd.Parameters.Add("@EndDate", SqlDbType.SmallDateTime).Value = Convert.ToDateTime(LabelEndDateValue.Text).AddHours(Convert.ToDouble(TextBoxDuration.Text)); sqlCmd.Parameters.Add("@MinUser", SqlDbType.Int).Value = TextBoxMinUser.Text; sqlCmd.Parameters.Add("@MaxUser", SqlDbType.Int).Value = TextBoxMaxUser.Text; sqlCmd.Parameters.Add("@Highlights", SqlDbType.NVarChar).Value = highlights; sqlCmd.Parameters.Add("@Details", SqlDbType.NVarChar).Value = details; sqlCmd.Parameters.Add("@Descriptions", SqlDbType.NVarChar).Value = descriptions; sqlCmd.Parameters.Add("@Locations", SqlDbType.VarChar).Value = Locations; sqlCmd.Parameters.Add("@Language", SqlDbType.VarChar).Value = DropDownListLanguage.SelectedValue; sqlCmd.Parameters.Add("@CategoryId", SqlDbType.VarChar).Value = DropDownListCategory.SelectedValue; sqlCmd.Parameters.Add("@Link1Name", SqlDbType.Int).Value = TextBoxLink1Name.Text; sqlCmd.Parameters.Add("@Link1Url", SqlDbType.NVarChar).Value = TextBoxLink1Url.Text; sqlCmd.Parameters.Add("@Link2Name", SqlDbType.Int).Value = TextBoxLink2Name.Text; sqlCmd.Parameters.Add("@Link2Url", SqlDbType.NVarChar).Value = TextBoxLink2Url.Text; sqlConn.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); sqlConn.Dispose(); LabelEditMessage.Visible = true; LabelEditMessage.Text = "مشخصات پیشنهاد مورد نظر تغییر یافت."; LabelEditMessage.CssClass = "SuccessMessage"; //insert log AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1802, Convert.ToInt32(Request.QueryString["OfferId"]), "0"); }
protected void ImageButtonOrganizations_Click(object sender, ImageClickEventArgs e) { switch (Request.QueryString["Mode"]) { case "OrganizationsAdd": { SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd = new SqlCommand("sp_charityOrganizationsAdd", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = TextBoxName.Text; sqlCmd.Parameters.Add("@About", SqlDbType.NVarChar).Value = TextBoxAbout.Text; sqlCmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = TextBoxEmail.Text; sqlCmd.Parameters.Add("@Website", SqlDbType.NVarChar).Value = TextBoxWebsite.Text; sqlCmd.Parameters.Add("@Phone", SqlDbType.VarChar).Value = TextBoxPhone.Text; sqlCmd.Parameters.Add("@Fax", SqlDbType.VarChar).Value = TextBoxFax.Text; sqlCmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = TextBoxAddress.Text; sqlCmd.Parameters.Add("@Locations", SqlDbType.VarChar).Value = "0,"; sqlConn.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); sqlConn.Dispose(); LabelOrganizationsMessage.Visible = true; LabelOrganizationsMessage.Text = "موسسه اضافه گردید."; LabelOrganizationsMessage.CssClass = "SuccessMessage"; break; } case "OrganizationsEdit": { SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd = new SqlCommand("sp_charityOrganizationsEdit", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@OrganizationId", SqlDbType.Int).Value = Convert.ToInt32(Request.QueryString["OrganizationId"]); sqlCmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = TextBoxName.Text; sqlCmd.Parameters.Add("@About", SqlDbType.NVarChar).Value = TextBoxAbout.Text; sqlCmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = TextBoxEmail.Text; sqlCmd.Parameters.Add("@Website", SqlDbType.NVarChar).Value = TextBoxWebsite.Text; sqlCmd.Parameters.Add("@Phone", SqlDbType.VarChar).Value = TextBoxPhone.Text; sqlCmd.Parameters.Add("@Fax", SqlDbType.VarChar).Value = TextBoxFax.Text; sqlCmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = TextBoxAddress.Text; sqlCmd.Parameters.Add("@Locations", SqlDbType.VarChar).Value = "0,"; sqlConn.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Dispose(); sqlConn.Dispose(); LabelOrganizationsMessage.Visible = true; LabelOrganizationsMessage.Text = "مشخصات موسسه تغییر یافت."; LabelOrganizationsMessage.CssClass = "SuccessMessage"; //insert log AdminLogInsert ali = new AdminLogInsert(); ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 1305, Convert.ToInt32(Request.QueryString["OrganizationId"]), "0"); break; } } }