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