public List <usermenuprivilege> getUserMenuPrivilegeforall() { usermenuprivilege usr; List <usermenuprivilege> usrlist = new List <usermenuprivilege>(); try { SqlConnection conn = new SqlConnection(Login.connString); string query = "select b.EmployeeID,b.Name,a.MenuItemString from " + " MenuPrivilege a,ViewUserEmployeeList b where a.UserID=b.UserID "; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { usr = new usermenuprivilege(); usr.EmpID = reader.GetString(0); usr.EmpName = reader.GetString(1); usr.menuItemString = reader.GetString(2); usrlist.Add(usr); } conn.Close(); } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(usrlist); }
public Boolean insertUserMenuPrivilege(usermenuprivilege mp) { Boolean status = true; string utString = ""; try { DateTime cdt = DateTime.Now; string updateSQL = "insert into MenuPrivilege (UserID,MenuItemString,CreateTime,CreateUser)" + " values (" + "'" + mp.userID + "'," + "'" + mp.menuItemString + "'," + "GETDATE()" + "," + "'" + Login.userLoggedIn + "'" + ")"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "MenuPrivilege", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception ex) { status = false; } return(status); }
public Boolean validateUser(usermenuprivilege mp) { Boolean status = true; try { if (mp.userID.Trim().Length == 0 || mp.userID == null) { return(false); } } catch (Exception) { } return(status); }
public Boolean updateUserMenuPrivilege(usermenuprivilege mp) { Boolean status = true; string utString = ""; try { string updateSQL = "update MenuPrivilege set MenuItemString='" + mp.menuItemString + "' where UserID='" + mp.userID + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "MenuPrivilege", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception) { status = false; } return(status); }