protected void Button1_Click(object sender, EventArgs e) { Label6.Text = ""; //for msg employeesDataContextDataContext db = new employeesDataContextDataContext(); var get_name = (from a in db.activities where a.name_of_act == (TextBox1.Text.Trim()) select a.name_of_act).FirstOrDefault(); //get the needed log from db //login if (get_name == null) { if (TextBox1.Text == "") { Label6.Text = "Заполните все поля!"; Label6.CssClass = "msg msg-error"; } else { //create activities NewAct = new activities(); NewAct.name_of_act = TextBox1.Text.Trim(); //Insert new record in tblmembers db.activities.InsertOnSubmit(NewAct); //Update table db.SubmitChanges(); BindGridView(); Label6.Text = "Запись успешно добавлена!"; Label6.CssClass = "msg msg-success"; } } else { Label6.Text = "Данный вид деятельности уже зарегистрирован в системе!"; Label6.CssClass = "msg msg-error"; } TextBox1.Text = ""; }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { Label6.Text = ""; int CurrentRowIndex = Convert.ToInt32(e.RowIndex); GridViewRow gvRow = GridView1.Rows[CurrentRowIndex]; employeesDataContextDataContext db = new employeesDataContextDataContext(); string nameOfAct = ((gvRow.Cells[0].Controls[0] as TextBox).Text).Trim(); string getId = ((gvRow.Cells[1].Controls[0] as TextBox).Text).Trim(); int id = Convert.ToInt32(getId); activities UpdateAct = (from a in db.activities where a.Id_activity == id select a).FirstOrDefault(); UpdateAct.name_of_act = nameOfAct; db.SubmitChanges(); Label6.Text = "Данные успешно обновлены!"; Label6.CssClass = "msg msg-success"; }
partial void Deleteactivities(activities instance);
partial void Updateactivities(activities instance);
partial void Insertactivities(activities instance);