public IEnumerable<StaffRole> PostStaffRoleDeleteAll(StaffRole item) { objConn = objDB.EstablishConnection(); List<StaffRole> staffroledelete = new List<StaffRole>(); string strSQL = "UPDATE staffrole SET Deleted = '" + item.Deleted + "'"; strSQL += "WHERE StaffRoleID = '" + item.StaffRoleID + "';"; objDB.sqlExecute(strSQL, objConn); objConn.Close(); return staffroledelete.ToArray(); }
public IEnumerable<StaffRole> GetStaffRoleAll() { objConn = objDB.EstablishConnection(); List<StaffRole> staff = new List<StaffRole>(); string strSQL = "SELECT * FROM staffrole WHERE Deleted = 0"; DataTable dt = objDB.List(strSQL, objConn); objConn.Close(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { StaffRole staffData = new StaffRole(); staffData.StaffRoleID = Convert.ToInt32(dt.Rows[i]["StaffRoleID"].ToString()); staffData.StaffRoleName = dt.Rows[i]["StaffRoleName"].ToString(); staff.Add(staffData); } } return staff.ToArray(); }
public StaffRole GetStaffRoleAll(int id) { objConn = objDB.EstablishConnection(); StaffRole staffrole = new StaffRole(); string strSQL = "SELECT * FROM staffrole sr INNER JOIN staffaccess sa ON sa.StaffRoleID = sr.StaffRoleID WHERE sr.StaffRoleID = '" + id + "'"; DataTable dt = objDB.List(strSQL, objConn); objConn.Close(); staffrole.StaffRoleID = Convert.ToInt32(dt.Rows[0]["StaffRoleID"].ToString()); staffrole.StaffRoleName = dt.Rows[0]["StaffRoleName"].ToString(); return staffrole; }
public IEnumerable<StaffRole> PostStaffRoleDelete(StaffRole item) { return repository.PostStaffRoleDeleteAll(item); }