public static string getemailIDs(List <user> list, string menuID)
{
//if opt==1, then check the email privilege for the user for the menu item
string emailIDs = "";
try
{
if (list.Count != 0)
{
foreach (user us in list)
{
string[] userOptionArray;
MenuPrivilegeDB mpdb = new MenuPrivilegeDB();
String menuPrivString = mpdb.getUserMenuPrivilege(us.userID);
userOptionArray = menuPrivString.Split(';');
for (int i = 0; i < userOptionArray.Length; i++)
{
if (userOptionArray[i].StartsWith(menuID))
{
string[] privileges = userOptionArray[i].Split(',');
if (privileges[5] == "M")
{
//find email id and add in to address
string eid = EmployeeDB.getEmployeeEmailID(us.userEmpID);
if (eid.Trim().Length > 0)
{
emailIDs = emailIDs + EmployeeDB.getEmployeeEmailID(us.userEmpID) + ";";
}
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
return(emailIDs);
}
//04-04-2018
public static DataGridView PrivilageListView(string docid)
{
DataGridView LV = new DataGridView();
try
{
DataGridViewCellStyle dataGridViewCellStyle1 = new DataGridViewCellStyle();
dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
dataGridViewCellStyle1.BackColor = System.Drawing.Color.LightSeaGreen;
dataGridViewCellStyle1.Font = new System.Drawing.Font("Arial", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
dataGridViewCellStyle1.ForeColor = System.Drawing.SystemColors.WindowText;
dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle1.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle1.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
LV.EnableHeadersVisualStyles = false;
LV.AllowUserToAddRows = false;
LV.AllowUserToDeleteRows = false;
LV.BackgroundColor = System.Drawing.SystemColors.GradientActiveCaption;
LV.BorderStyle = System.Windows.Forms.BorderStyle.None;
LV.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;
LV.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter;
LV.ColumnHeadersHeight = 27;
LV.RowHeadersVisible = false;
LV.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DataGridViewTextBoxColumn colempid = new DataGridViewTextBoxColumn();
colempid.Width = 50;
colempid.Name = "EmployeeID";
colempid.HeaderText = "Employee ID";
colempid.ReadOnly = false;
LV.Columns.Add(colempid);
DataGridViewTextBoxColumn colempname = new DataGridViewTextBoxColumn();
colempname.Width = 50;
colempname.Name = "EmployeeName";
colempname.HeaderText = "Employee Name";
colempname.ReadOnly = false;
LV.Columns.Add(colempname);
DataGridViewCheckBoxColumn colview = new DataGridViewCheckBoxColumn();
colview.Width = 50;
colview.Name = "View";
colview.HeaderText = "View";
colview.ReadOnly = false;
LV.Columns.Add(colview);
DataGridViewCheckBoxColumn colAdd = new DataGridViewCheckBoxColumn();
colAdd.Width = 50;
colAdd.Name = "Add";
colAdd.HeaderText = "Add";
colAdd.ReadOnly = false;
LV.Columns.Add(colAdd);
DataGridViewCheckBoxColumn colEdit = new DataGridViewCheckBoxColumn();
colEdit.Width = 50;
colEdit.Name = "Edit";
colEdit.HeaderText = "Edit";
colEdit.ReadOnly = false;
LV.Columns.Add(colEdit);
DataGridViewCheckBoxColumn colDel = new DataGridViewCheckBoxColumn();
colDel.Width = 50;
colDel.Name = "Delete";
colDel.HeaderText = "Delete";
colDel.ReadOnly = false;
LV.Columns.Add(colDel);
DataGridViewCheckBoxColumn colMail = new DataGridViewCheckBoxColumn();
colMail.Width = 50;
colMail.Name = "Mail";
colMail.HeaderText = "E-Mail";
colMail.ReadOnly = false;
LV.Columns.Add(colMail);
MenuPrivilegeDB MPDB = new MenuPrivilegeDB();
List <usermenuprivilege> Allpriv = MPDB.getUserMenuPrivilegeforall();
int i = 0;
foreach (usermenuprivilege fordoc in Allpriv)
{
LV.Rows.Add();
LV.Rows[i].Cells[0].Value = fordoc.EmpID.ToString();
LV.Rows[i].Cells[1].Value = fordoc.EmpName.ToString();
string mpString = fordoc.menuItemString;
string[] strArr = mpString.Split(';');
int intex = 0;
intex = Utilities.checkMenuPrivilege(docid, strArr);
if (intex >= 0)
{
string[] prvArr = strArr[intex].Split(',');
if (prvArr[1].Equals("V"))
{
LV.Rows[i].Cells[2].Value = true;
}
if (prvArr[2].Equals("A"))
{
LV.Rows[i].Cells[3].Value = true;
}
if (prvArr[3].Equals("E"))
{
LV.Rows[i].Cells[4].Value = true;
}
if (prvArr[4].Equals("D"))
{
LV.Rows[i].Cells[5].Value = true;
}
try
{
if (prvArr[5].Equals("M"))
{
LV.Rows[i].Cells[6].Value = true;
}
}
catch (Exception ex)
{
LV.Rows[i].Cells[6].Value = false;
}
}
else
{
LV.Rows[i].Cells[2].Value = false;
LV.Rows[i].Cells[3].Value = false;
LV.Rows[i].Cells[4].Value = false;
LV.Rows[i].Cells[5].Value = false;
LV.Rows[i].Cells[6].Value = false;
}
i++;
}
}
catch (Exception)
{
}
return(LV);
}