protected void btnSubmit_Click(object sender, EventArgs e) { lblStUserNm.Text = ""; lblStsEmail.Text = ""; if (CheckValid()) { gtsvn.Users users = new gtsvn.Users { UserNm = txtUserName.Text, Pwd = txtPassword.Text, FullNm = txtFullNm.Text, Address1 = txtAddress.Text, Email = txtEmail.Text, IsActived = false, LastUpdt = DateTime.Now }; data.Users.InsertOnSubmit(users); try { //submit changes to get new identity userid data.SubmitChanges(); //insert into role int newuserid = (int)users.UserID; for (int i = 0; i <= lbRole.Items.Count - 1; i++) { if (lbRole.Items[i].Selected) { //insert into UserRole table gtsvn.UserRole userrole = new gtsvn.UserRole { UserID = newuserid, RoleID = Int32.Parse(lbRole.Items[i].Value), IsActived = true }; data.UserRole.InsertOnSubmit(userrole); } } data.SubmitChanges(); lblStatus.Text = "Thêm thành công user <b>" + txtUserName.Text + "</b>"; SetGridMain(); //reset input field txtUserName.Text = ""; txtFullNm.Text = ""; txtAddress.Text = ""; txtEmail.Text = ""; lbRole.SelectedIndex = -1; } catch (Exception ex) { lblStatus.Text = ex.ToString(); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (txtId.Text != "") { var result = (from t in data.Users where (int)t.UserID == Int32.Parse(txtId.Text) select t).First(); result.Pwd = txtPassword.Text == "" ? result.Pwd : txtPassword.Text; result.FullNm = txtFullNm.Text; result.Address1 = txtAddress.Text; result.IsActived = ckActived.Checked; try { data.SubmitChanges(); if (txtId.Text != "1") { //delete old role var result1 = from t in data.UserRole where t.UserID == Int32.Parse(txtId.Text) select t; foreach (var res in result1) { data.UserRole.DeleteOnSubmit(res); } data.SubmitChanges(); //insert new role for (int i = 0; i <= lbRole.Items.Count - 1; i++) { if (lbRole.Items[i].Selected) { //insert into UserRole table gtsvn.UserRole userrole = new gtsvn.UserRole { UserID = Int32.Parse(txtId.Text), RoleID = Int32.Parse(lbRole.Items[i].Value), IsActived = true }; data.UserRole.InsertOnSubmit(userrole); } } data.SubmitChanges(); } lblStatus.Text = "Thay đổi thông tin người dùng <b>" + txtUserName.Text + "</b> thành công"; } catch (Exception ex) { lblStatus.Text = "Có lỗi xảy ra. Chi tiết lỗi: " + ex.ToString(); } } }