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);
