private void btnNext_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("ต้องการเพิ่มสิทธิ์!", "เพิ่ม", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
foreach (GridViewRowInfo rd in radGridView1.Rows)
{
if (rd.IsSelected)
{
tb_UserPermission pm = new tb_UserPermission();
pm.LayoutName = rd.Cells["dgvLayout"].Value.ToString();
pm.ScreenName = rd.Cells["dgvTextNode"].Value.ToString();
pm.UserID = cboUserSelect1.Text.Trim();
db.tb_UserPermissions.InsertOnSubmit(pm);
db.SubmitChanges();
}
}
dbClss.AddHistory(this.Name, "เพิ่มสิทธ์", "ทำการเพิ่มสิทธ์ [" + cboUserSelect1.Text + "] เข้าระบบ", "จากเครื่อง " + System.Environment.MachineName);
DataLoad2(cboUserSelect1.Text);
DataLoad(cboUserSelect1.Text);
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}
private void btnBack_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("ต้องการ ลบ สิทธิ์!", "ลบ", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
//string TextName = "";
//string Layout = "";
foreach (GridViewRowInfo rd in radGridView2.Rows)
{
if (rd.IsSelected)
{
tb_UserPermission pm = db.tb_UserPermissions.Where(p => p.UserID == cboUserSelect1.Text &&
p.ScreenName == rd.Cells["dgvTextNode"].Value.ToString() &&
p.LayoutName == rd.Cells["dgvLayout"].Value.ToString()).FirstOrDefault();
if (pm != null)
{
db.tb_UserPermissions.DeleteOnSubmit(pm);
db.SubmitChanges();
}
}
}
dbClss.AddHistory(this.Name, "ลบ สิทธิ์!", "ทำการลบ สิทธิ์! [" + cboUserSelect1.Text + "] ในระบบ", "จากเครื่อง " + System.Environment.MachineName);
DataLoad2(cboUserSelect1.Text);
DataLoad(cboUserSelect1.Text);
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}
public static bool PermissionScreen(string ScreenName)
{
bool ck = false;
try
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
OpenForm op = db.OpenForms.Where(o => o.LinkNode == ScreenName).FirstOrDefault();
if (op != null)
{
tb_UserPermission up = db.tb_UserPermissions.Where(u => u.ScreenName == op.TextNode && u.UserID == dbClss.UserID).FirstOrDefault();
if (up != null)
{
ck = true;
}
}
//TextNode
}
}
catch { }
return(ck);
}
private void btnCopy_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("ต้องการ copy สิทธิ์!", "copy", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (!cboUserSelect2.Text.Equals("") && !cboUserSelect2.Text.Equals(cboUserSelect1.Text))
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
var de = db.tb_UserPermissions.Where(p => p.UserID == cboUserSelect1.Text).ToList();
foreach (var rd in de)
{
tb_UserPermission ps = db.tb_UserPermissions.Where(p1 => p1.UserID == rd.UserID && p1.ScreenName == rd.ScreenName && p1.LayoutName == rd.LayoutName).FirstOrDefault();
if (ps != null)
{
db.tb_UserPermissions.DeleteOnSubmit(ps);
db.SubmitChanges();
}
}
var copy = db.tb_UserPermissions.Where(p => p.UserID == cboUserSelect2.Text).ToList();
foreach (var rd in copy)
{
tb_UserPermission ps = new tb_UserPermission();
ps.UserID = cboUserSelect1.Text;
ps.ScreenName = rd.ScreenName;
ps.LayoutName = rd.LayoutName;
db.tb_UserPermissions.InsertOnSubmit(ps);
db.SubmitChanges();
}
}
dbClss.AddHistory(this.Name, "copy สิทธิ์!", "copy Screen [" + cboUserSelect1.Text + "] ในระบบ", "จากเครื่อง " + System.Environment.MachineName);
DataLoad2(cboUserSelect1.Text);
DataLoad(cboUserSelect1.Text);
}
else
{
MessageBox.Show("เลือกข้อมูลไม่ถูกต้อง !", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}
