Пример #1
0
        protected void ButtonCancel3_Click(object sender, EventArgs e)
        {
            GridView1.SelectRow(-1);
            Panel2.Visible = false;

            GridView1.Enabled = true;
        }
Пример #2
0
        protected void ButtonNo_Click(object sender, EventArgs e)
        {
            // Запрет в кружок


            SqlDataSource1.UpdateCommand = @"UPDATE    UsersKruzhki SET " +
                                           " Статус = 'отклонено' " +
                                           "   WHERE ((KruzhId LIKE  '" + GridView1.SelectedDataKey[1] + "') AND (UserId LIKE  '" + GridView1.SelectedDataKey[0] + "'))";
            GridView1.SelectRow(-1);

            SqlConnection connection = new SqlConnection(SqlDataSource1.ConnectionString);

            connection.Open();

            SqlDataSource1.Update();

            connection.Close();


            GridView1.SelectRow(-1);

            Panel1.Visible    = false;
            GridView1.Enabled = true;


            //Обновление списка

            //Показывать обработанные заявки
            if (CheckBox1.Checked)
            {
                SqlDataSource1.SelectCommand = "  SELECT UsersKruzhki.UserId, UsersKruzhki.KruzhId, aspnet_Users.UserName, " +
                                               " Users.Фамилия, Users.Имя, UsersKruzhki.Статус, UsersKruzhki.ДатаПодачи " +
                                               "    FROM Kruzhki INNER JOIN UsersKruzhki ON Kruzhki.KruzhId = UsersKruzhki.KruzhId " +
                                               " INNER JOIN Users ON UsersKruzhki.UserId = Users.UserId " +
                                               " INNER JOIN aspnet_Users ON Users.UserId = aspnet_Users.UserId " +
                                               " WHERE     ((UsersKruzhki.KruzhId LIKE '" + DropDownList1.SelectedValue + "') " +
                                               "  AND (Kruzhki.ДатаОкончания > '" + DateTime.Now + "')  )";
            }
            else
            {
                SqlDataSource1.SelectCommand = "  SELECT UsersKruzhki.UserId, UsersKruzhki.KruzhId, aspnet_Users.UserName, " +
                                               " Users.Фамилия, Users.Имя, UsersKruzhki.Статус, UsersKruzhki.ДатаПодачи " +
                                               "    FROM Kruzhki INNER JOIN UsersKruzhki ON Kruzhki.KruzhId = UsersKruzhki.KruzhId " +
                                               " INNER JOIN Users ON UsersKruzhki.UserId = Users.UserId " +
                                               " INNER JOIN aspnet_Users ON Users.UserId = aspnet_Users.UserId " +
                                               " WHERE     ((UsersKruzhki.KruzhId LIKE '" + DropDownList1.SelectedValue + "') " +
                                               "  AND (Kruzhki.ДатаОкончания > '" + DateTime.Now + "')" +
                                               " AND (UsersKruzhki.Статус='рассмотрение') )";
            }
            DataSourceSelectArguments argument = new DataSourceSelectArguments();

            connection.Open();

            SqlDataSource1.Select(argument);

            connection.Close();

            GridView1.Visible = true;
            GridView1.DataBind();
        }
Пример #3
0
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            //обновление Кружка

            GridView1.SelectRow(e.RowIndex);

            TextBox Описание = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox4");
            TextBox Начало   = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox5");
            TextBox Конец    = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox6");

            try
            {
                SqlDataSource1.UpdateCommand = @"UPDATE    Kruzhki SET " +
                                               " Описание = '" + Описание.Text +
                                               "' , ДатаНачала = '" + Convert.ToDateTime(Начало.Text) +
                                               "' , ДатаОкончания = '" + Convert.ToDateTime(Конец.Text) +

                                               "'   WHERE (KruzhId LIKE  '" + GridView1.SelectedValue + "')";
                GridView1.SelectRow(-1);
            }
            catch
            {
                e.Cancel = true;
            }
        }
Пример #4
0
        protected void ButtonОк1_Click(object sender, EventArgs e)
        {
            //Удаляем каталлог Кружка и находящиеся в нем файлы


            string saveDir  = @"uploads\Задания\";
            string saveDir2 = @"uploads\Работы\";
            string saveDir3 = @"uploads\Теория\";

            string appPath = Request.PhysicalApplicationPath;

            Label Кружок     = (Label)GridView1.SelectedRow.FindControl("Label4");
            Label Дисциплина = (Label)GridView1.SelectedRow.FindControl("Label2");

            try
            {
                Directory.Delete(appPath + saveDir + Дисциплина.Text + @"\" + Кружок.Text + @"\", true);
                Directory.Delete(appPath + saveDir2 + Дисциплина.Text + @"\" + Кружок.Text + @"\", true);
                Directory.Delete(appPath + saveDir3 + Дисциплина.Text + @"\" + Кружок.Text + @"\", true);
            }
            catch {
                // каталоги не найдены
            }

            SqlDataSource1.DeleteCommand = @"DELETE FROM Kruzhki WHERE (KruzhId LIKE  '" + GridView1.SelectedValue + "')";

            SqlDataSource1.Delete();

            GridView1.SelectRow(-1);

            Panel1.Visible    = false;
            GridView1.Enabled = true;
        }
        protected void editBox_OK_Click(object sender, EventArgs e)
        {
            //Удаляем каталлог и находящиеся в нем файлы

            string saveDir  = @"uploads\Теория\";
            string saveDir2 = @"uploads\Работы\";
            string saveDir3 = @"uploads\Задания\";

            string appPath = Request.PhysicalApplicationPath;

            Label Subject = (Label)GridView1.SelectedRow.FindControl("lblTile");

            try
            {
                Directory.Delete(appPath + saveDir + Subject.Text + @"\", true);
                Directory.Delete(appPath + saveDir2 + Subject.Text + @"\", true);
                Directory.Delete(appPath + saveDir3 + Subject.Text + @"\", true);
            }
            catch
            {
                // Каталог не найден
            }


            SqlDataSource1.DeleteCommand = @"DELETE FROM Subjects WHERE (SubjectId LIKE  '" + GridView1.SelectedValue + "')";

            SqlDataSource1.Delete();

            GridView1.SelectRow(-1);



            Panel1.Visible    = false;
            GridView1.Enabled = true;
        }
Пример #6
0
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            GridView1.Rows[e.RowIndex].Cells[0].Visible = true;
            GridView1.SelectRow(e.RowIndex);
            string idd = GridView1.SelectedDataKey[0].ToString();

            Literal1.Text = ":" + idd;


            SqlConnection sqlConnection = new SqlConnection();

            sqlConnection.ConnectionString = ConfigurationManager.ConnectionStrings["CrisTimeConnection"].ConnectionString;
            SqlCommand sqlCommand = new SqlCommand();

            sqlCommand.Connection  = sqlConnection;
            sqlCommand.CommandText = " delete from [SARBATORI] where id=" + idd.Trim();
            sqlCommand.Connection.Open();
            try
            {
                sqlCommand.ExecuteNonQuery();
                this.Literal1.Text = "<strong>Sarbatoare legala stearsa cu success </strong>";
                GridView1.DataBind();
            }
            catch (SqlException ex)
            {
                this.Literal1.Text = this.Literal1.Text + "<br>/" + ex.Message + "<br /> <strong>Eroare le stergere </strong>";
            }
            sqlCommand.Connection.Close();
            e.Cancel = true;
        }
        protected void editBox_Cancel_Click(object sender, EventArgs e)
        {
            Panel1.Visible = false;

            GridView1.SelectRow(-1);
            GridView1.Enabled = true;
        }
        protected void DetailsView1_ItemUpdated(object sender, DetailsViewUpdatedEventArgs e)
        {
            //Bind the data changes to the GridView to render immediately
            GridView1.DataBind();

            //close the DetailView by recalibrating GridView selected row to -1 (non-row)
            GridView1.SelectRow(-1);
        }
Пример #9
0
        protected void GridView_Prod_RadioSelect(object sender, EventArgs e)
        {
            RadioButton linkb = (RadioButton)sender;
            GridViewRow row   = (GridViewRow)linkb.NamingContainer;

            if (row != null && row.RowIndex != -1)
            {
                GridView1.SelectRow(row.RowIndex);
            }
        }
Пример #10
0
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            // Удаление Теста

            Panel1.Visible = true;

            GridView1.SelectRow(e.RowIndex);
            GridView1.Enabled = false;

            SqlDataSource1.DeleteCommand = @"DELETE FROM TestSeries WHERE (Номер =  '')";
        }
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            // Удаление пользователя

            Panel1.Visible = true;

            GridView1.SelectRow(e.RowIndex);
            GridView1.Enabled = false;

            SqlDataSource1.DeleteCommand = @"DELETE FROM Users WHERE (Фамилия =  ' ')";
        }
Пример #12
0
 protected void gridViewRowCommand(object sender, GridViewCommandEventArgs e)
 {
     if (e.CommandName == "ShowDetailsView")
     {
         GridView1.SelectRow(Convert.ToInt32(e.CommandArgument));
         GridViewRow gvr  = GridView1.SelectedRow;
         string      text = gvr.Cells[0].Text;
         Console.WriteLine("There is a method" + gvr.Cells[0].Text);
         Response.Redirect("RecipeDetails.aspx?RecipeId=" + gvr.Cells[0].Text);
     }
     Console.WriteLine("There is a method");
 }
Пример #13
0
        protected void GridView1_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
        {
            // Удаление файла

            Panel1.Visible = true;


            GridView1.SelectRow(e.RowIndex);
            GridView1.Enabled = false;

            SqlDataSource1.DeleteCommand = @"DELETE FROM TeorFiles WHERE (НазваниеФайла =  ' ')";
        }
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            // Удаление дисциплины

            Panel1.Visible = true;


            GridView1.SelectRow(e.RowIndex);
            GridView1.Enabled = false;

            SqlDataSource1.DeleteCommand = @"DELETE FROM Subjects WHERE (Название =  ' ')";
        }
Пример #15
0
        protected void ButtonОк1_Click(object sender, EventArgs e)
        {
            //Удаляем Тест

            SqlDataSource1.DeleteCommand = @"DELETE FROM TestSeries WHERE (TestSeriesId LIKE  '" + GridView1.SelectedValue + "')";

            SqlDataSource1.Delete();

            GridView1.SelectRow(-1);

            Panel1.Visible    = false;
            GridView1.Enabled = true;
        }
Пример #16
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Email_ID"] == null)
        {
            Response.Redirect("Home.aspx");
        }
        lblCurrentUser.Text = Session["Email_ID"].ToString();
        lblLoginTime.Text   = DateTime.Now.ToString();


        GridView1.Visible = true;
        GridView1.SelectRow(-1);
        GridView1.DataSourceID = "SqlDataSource1";
    }
Пример #17
0
        protected void ButtonОк1_Click(object sender, EventArgs e)
        {
            // Удаление файла, записи в БД и физически

            //Находим физический путь файла

            string appPath = Request.PhysicalApplicationPath;

            SqlConnection connection = new SqlConnection(SqlDataSource1.ConnectionString);

            SqlCommand getFile = new SqlCommand(
                "SELECT Путь FROM TeorFiles " +
                "WHERE (TeorFileId LIKE  '" + GridView1.SelectedValue + "');", connection);

            connection.Open();

            SqlDataReader reader = getFile.ExecuteReader();

            try
            {
                reader.Read();
                File.Delete(appPath + reader[0].ToString());
            }
            catch
            {
            }
            finally
            {
                reader.Close();
                connection.Close();
            }



            // Удаление записи из БД
            SqlDataSource1.DeleteCommand = @"DELETE FROM TeorFiles WHERE (TeorFileId LIKE  '" + GridView1.SelectedValue + "')";

            SqlDataSource1.Delete();



            GridView1.SelectRow(-1);

            Panel1.Visible    = false;
            GridView1.Enabled = true;
        }
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            //обновление дисциплины

            GridView1.SelectRow(e.RowIndex);

            TextBox Descr = (TextBox)GridView1.Rows[e.RowIndex].FindControl("Descript");
            TextBox Poscr = (TextBox)GridView1.Rows[e.RowIndex].FindControl("Poscript");


            SqlDataSource1.UpdateCommand = @"UPDATE    Subjects SET " +
                                           " Описание = '" + Descr.Text +
                                           "' , Примечание = '" + Poscr.Text +
                                           "'   WHERE (SubjectId LIKE  '" + GridView1.SelectedValue + "')";

            GridView1.SelectRow(-1);
        }
Пример #19
0
        protected void LinkButton_Show_Spec_Command(object sender, CommandEventArgs e)
        {
            LinkButton  linkb = (LinkButton)sender;
            GridViewRow row   = (GridViewRow)linkb.NamingContainer;

            if (row != null && row.RowIndex != -1 && row.RowIndex != GridView1.SelectedIndex)
            {
                GridView1.SelectRow(row.RowIndex);
            }

            ((RadioButton)GridView1.SelectedRow.Cells[0].FindControl("prod_radio")).Checked = true;

            String forwardString = "Popups/Product/AllProd_Specification.aspx";

            forwardString += "?prodCatId=" + ((Label)GridView1.SelectedRow.Cells[0].FindControl("Label_Hidden")).Text;
            ScriptManager.RegisterStartupScript(this, typeof(string), "DispSpecProd",
                                                "window.open('" + forwardString + "',null,'resizeable=yes,scrollbars=yes,addressbar=no,toolbar=yes,width=700,height=600,left=100,right=500,scrollbars=1');", true);
        }
Пример #20
0
        protected void LinkButton_Defect_Command(object sender, CommandEventArgs e)
        {
            LinkButton  linkb = (LinkButton)sender;
            GridViewRow row   = (GridViewRow)linkb.NamingContainer;

            if (row != null && row.RowIndex != -1 && row.RowIndex != GridView1.SelectedIndex)
            {
                GridView1.SelectRow(row.RowIndex);
            }

            ((RadioButton)GridView1.SelectedRow.Cells[0].FindControl("contact_radio")).Checked = true;

            String forwardString = "/Pages/Popups/Contacts/AllDefectsWithContact.aspx";

            forwardString += "?contactId=" + ((Label)GridView1.SelectedRow.Cells[0].FindControl("Label_Hidden")).Text;

            ScriptManager.RegisterStartupScript(this, typeof(string), "DispContactDefects", "window.open('" + forwardString + "',null,'resizeable=yes,scrollbars=yes,addressbar=no,toolbar=yes,width=1000,Height=700');", true);
        }
Пример #21
0
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            //Обновление теста

            GridView1.SelectRow(e.RowIndex);



            TextBox Descr = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2");


            SqlDataSource1.UpdateCommand = @"UPDATE   TestSeries SET " +
                                           " Описание = '" + Descr.Text +
                                           "', Дата = '" + DateTime.Now +
                                           "'   WHERE (TestSeriesId LIKE  '" + GridView1.SelectedValue + "')";

            GridView1.SelectRow(-1);
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            Calendar1.SelectedDate = date_select1;
            Calendar2.SelectedDate = date_select2;

            try
            {
                colorDef = GridView1.BackColor;

                if (Session["UserCellStats"] != null)
                {
                    DropDownList1.SelectedIndex = (int)Session["UserCellStats"];
                }
                if (Session["StartDateCellStats"] != null)
                {
                    Calendar1.SelectedDate = (DateTime)Session["StartDateCellStats"];
                }
                if (Session["EndDateCellStats"] != null)
                {
                    Calendar2.SelectedDate = (DateTime)Session["EndDateCellStats"];
                }
                if (Session["Grid1DataCellStats"] != null)
                {
                    List <cellDisp1> grid1_data = (List <cellDisp1>)Session["Grid1DataCellStats"];
                    GridView1.DataSource = grid1_data;
                    GridView1.DataBind();
                    GridView1.Visible = true;
                }

                if (Session["Grid1SelectedRowCellStats"] != null)
                {
                    int grid1row = (int)Session["Grid1SelectedRowCellStats"];
                    GridView1.SelectedIndex         = grid1row;
                    GridView1.SelectedRow.BackColor = System.Drawing.Color.Yellow;
                    GridView1.SelectRow(grid1row);
                }
            }
            catch (Exception ex)
            {
                TextBoxC1.Text = "Error in restoring sesson data.\n";
            }

            clear_session();
        }
Пример #23
0
        protected void LinkButton_Location_Command(object sender, CommandEventArgs e)
        {
            LinkButton  linkb = (LinkButton)sender;
            GridViewRow row   = (GridViewRow)linkb.NamingContainer;

            if (row != null && row.RowIndex != -1 && row.RowIndex != GridView1.SelectedIndex)
            {
                GridView1.SelectRow(row.RowIndex);
            }

            ((RadioButton)GridView1.SelectedRow.Cells[0].FindControl("contact_radio")).Checked = true;

            String forwardString = "Popups/Contacts/AllContacts_Location.aspx";
            String fromSite      = ((Label)GridView1.SelectedRow.Cells[0].FindControl("Label_From_Site")).Text;

            forwardString += "?fromSite=" + fromSite;
            ScriptManager.RegisterStartupScript(this, typeof(string), "DispLocationContacts",
                                                "window.open('" + forwardString + "',null,'status=1,width=600,height=400,left=500,right=500');", true);
        }
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            // определение команды обновления оценки работы
            GridView1.SelectRow(e.RowIndex);
            Panel2.Visible    = false;
            GridView1.Enabled = true;

            DropDownList статус      = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("DropDownListS");
            TextBox      баллы       = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBoxB");
            TextBox      комментарий = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBoxK");


            //

            SqlDataSource2.UpdateCommand = @"UPDATE Works SET  " +
                                           "  Статус = '" + статус.Text + "', " +
                                           "  Баллы  = '" + баллы.Text + "', " +
                                           "  Комментарий  =  '" + комментарий.Text + "'  " +
                                           "   WHERE  (WorkId LIKE  '" + GridView1.SelectedValue + "')";
        }
Пример #25
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         FillDepartments();
         FillGenders();
         GetDataFromDatabase();
         ViewState["Action"] = "Insert";
         ViewState["Id"]     = null;
         if (Request.QueryString["FirstName"] != null)
         {
             Label1.Text = Request.QueryString["FirstName"] + " " + Request.QueryString["LastName"];
         }
         GridView1.SelectRow(0);
         for (int i = 1; i <= GridView1.Rows.Count; i++)
         {
             GridView1.SelectedRow.Cells[0].Text = i.ToString();
             GridView1.SelectRow(i);
         }
     }
 }
 protected void VenDetail_ItemDeleted(object sender, DetailsViewDeletedEventArgs e)
 {
     GridView1.DataBind();
     GridView1.SelectRow(-1);
     venueOutput.Visible = false;
 }
 protected void GridView1_Load(object sender, EventArgs e)
 {
     GridView1.SelectRow(1);
 }
Пример #28
0
 protected void DetailsView1_ItemInserted1(object sender, DetailsViewInsertedEventArgs e)
 {
     GridView1.DataBind();
     GridView1.SelectRow(-1);
 }
Пример #29
0
 protected void DetailsView2_ItemDeleted(object sender, DetailsViewDeletedEventArgs e)
 {
     GridView1.DataBind();
     GridView1.SelectRow(-1);
 }
Пример #30
0
 protected void FirstTaskButton_Click(object sender, EventArgs e)
 {
     GridView1.SelectedIndex = -1;
     GridView1.SelectRow(-1);
     DetailsView1.ChangeMode(DetailsViewMode.Insert);
 }