Exemplo n.º 1
0
    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");
        }
    }
Exemplo n.º 2
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());
    }
Exemplo n.º 3
0
    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";
        }
    }
Exemplo n.º 4
0
    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");
        }
    }
Exemplo n.º 5
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;
        }
        }
    }
Exemplo n.º 6
0
    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();
        }
    }
Exemplo n.º 7
0
    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();
        }
    }
Exemplo n.º 8
0
    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");
    }
Exemplo n.º 9
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");
        }

        //insert log
        if (!IsPostBack)
        {
            AdminLogInsert ali = new AdminLogInsert();
            ali.insertAdminLog(Convert.ToInt32(Session["UserId"]), 2300, 0, "0");
        }
    }
Exemplo n.º 10
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);
    }
Exemplo n.º 11
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");
        }
    }
Exemplo n.º 12
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);
    }
Exemplo n.º 13
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 + " درخواست پاسخ داده نشده)";
        }
    }
Exemplo n.º 14
0
    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 + " نظر پاسخ داده نشده)";
        }
    }
Exemplo n.º 15
0
    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");
    }
Exemplo n.º 16
0
    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");
        }
    }
Exemplo n.º 17
0
    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");
        }
    }
Exemplo n.º 18
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("&amp;quot;", "'");
        sbDescriptions.Replace("&amp;lt;", "<");
        sbDescriptions.Replace("&amp;gt;", ">");
        string descriptions = sbDescriptions.ToString();
        //Highlights
        StringBuilder sbHighlights = new StringBuilder(HttpUtility.HtmlEncode(TextBoxHighlights.Text));

        sbHighlights.Replace("&amp;quot;", "'");
        sbHighlights.Replace("&amp;lt;", "<");
        sbHighlights.Replace("&amp;gt;", ">");
        string highlights = sbHighlights.ToString();
        //Details
        StringBuilder sbDetails = new StringBuilder(HttpUtility.HtmlEncode(TextBoxDetails.Text));

        sbDetails.Replace("&amp;quot;", "'");
        sbDetails.Replace("&amp;lt;", "<");
        sbDetails.Replace("&amp;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");
    }
Exemplo n.º 19
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");
        }
    }
Exemplo n.º 20
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();
            }
        }
    }
Exemplo n.º 21
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();
            }
        }
    }
Exemplo n.º 22
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;
                }
        }
    }
Exemplo n.º 23
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());
    }
Exemplo n.º 24
0
    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";
        }
    }
Exemplo n.º 25
0
    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");
    }
Exemplo n.º 26
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("&amp;quot;", "'");
        sbDescriptions.Replace("&amp;lt;", "<");
        sbDescriptions.Replace("&amp;gt;", ">");
        string descriptions = sbDescriptions.ToString();
        //Highlights
        StringBuilder sbHighlights = new StringBuilder(HttpUtility.HtmlEncode(TextBoxHighlights.Text));
        sbHighlights.Replace("&amp;quot;", "'");
        sbHighlights.Replace("&amp;lt;", "<");
        sbHighlights.Replace("&amp;gt;", ">");
        string highlights = sbHighlights.ToString();
        //Details
        StringBuilder sbDetails = new StringBuilder(HttpUtility.HtmlEncode(TextBoxDetails.Text));
        sbDetails.Replace("&amp;quot;", "'");
        sbDetails.Replace("&amp;lt;", "<");
        sbDetails.Replace("&amp;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");
    }
Exemplo n.º 27
0
    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");
    }
Exemplo n.º 28
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;
        }
        }
    }
Exemplo n.º 29
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");
        }
    }
Exemplo n.º 30
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;
                }
        }
    }