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);
}
