public static bool Delete(UserTypePermission UserTypePermission) { SqlConnection connection = PMMSData.GetConnection(); string deleteProcedure = "[UserTypePermissionDelete]"; SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection); deleteCommand.CommandType = CommandType.StoredProcedure; deleteCommand.Parameters.AddWithValue("@OldUserTypeID", UserTypePermission.UserTypeID); deleteCommand.Parameters.AddWithValue("@OldUserTypePermissionID", UserTypePermission.UserTypePermissionID); deleteCommand.Parameters.AddWithValue("@OldPermissionID", UserTypePermission.PermissionID); deleteCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); deleteCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); deleteCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(deleteCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }
private static MenuPrivilegeViewModel GetUserTypePermissionModel(UserTypePermission entity) { MenuPrivilegeViewModel model = new MenuPrivilegeViewModel(); model.PermissionRef = entity.PermissionRef; model.UserTypeRef = entity.UserTypeRef; return(model); }
public static UserTypePermission Select_Record(UserTypePermission UserTypePermissionPara) { UserTypePermission UserTypePermission = new UserTypePermission(); SqlConnection connection = PMMSData.GetConnection(); string selectProcedure = "[UserTypePermissionSelect]"; SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@UserTypeID", UserTypePermissionPara.UserTypeID); selectCommand.Parameters.AddWithValue("@UserTypePermissionID", UserTypePermissionPara.UserTypePermissionID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { UserTypePermission.UserTypeID = System.Convert.ToInt32(reader["UserTypeID"]); UserTypePermission.UserTypePermissionID = System.Convert.ToInt32(reader["UserTypePermissionID"]); UserTypePermission.PermissionID = System.Convert.ToInt32(reader["PermissionID"]); } else { UserTypePermission = null; } reader.Close(); } catch (SqlException) { return(UserTypePermission); } finally { connection.Close(); } return(UserTypePermission); }